Can we duplicate standard query Search Master Agreements and Agreements.

[Former Member]

Hi Experts,

I have a requirement to hide Agreement Manager and Business Unit & Region result fields in standard Search Master Agreements and Agreements query.

I have duplicated this standard query and deleted Agreement Manager and Business Unit & Region result fields. Try to run this query but it is giving error.

Execution Type is Java.

Query Executor Class: com.sap.eso.contracts.query.SearchAllMAandAgreements

Error:  SQL Exception: Fail to convert to internal representation, ANSI-92 SQL State: 99999, Vendor Error Code: 17059. Fail to convert to internal

          representation.

Does anyone have idea about this functionality or how this standard query can be modified.

Thanks,

Lava

[kushagra_agrawal · Accepted solution]

Hi Lava,

There is the Standard Query ODP-ESO-MasterAgreementList

Duplicate the query and remove the fields from the Result fields whcih you dont want. I think you will get the result required.

Thanks

Kushagra A

[kushagra_agrawal · Accepted solution]

Also remove the fields at query level as well.

[Former Member · Accepted solution]

Hi Agrawal,

Thanks for your support.

Regards,

Lava.

[Former Member]

From my limited experience, I have gotten this error when I was adding a field and forgot to change the output field data type from it's default numeric setting.

HTH,

Mike