Xml Gateway : Po Xml : Generate Trading Partner Xml Document Ora-00904 (Doc ID 1374713.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Oracle Internet Procurement Connector - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When a purchase order is approved and sent to a supplier with XML setup, the workflow fails with the following error:

Facility Activity: Generate Trading Partner XML Document
Activity Type: Function
Error Name: ECX_PROGRAM_EXIT_EMBD
Error Message: 6012: XML Gateway process aborted: 'ORA-01003: no statement parsed - ECX_ACTIONS.BIND_VARIABLES_FOR_VIEW'. For further details, see the log corresponding to FND-Logging AFLOG MODULE Name: 'ecx.plsql.OAG.out.PO.PRO.19.0:84.6.log'
Error Stack: ECX_STANDARD.getXMLCover(OAG, PO, PRO) ECX_STANDARD.getXMLTP(POXML, 2011-2055, 180896, RUN) Wf_Engine_Util.Function_Call(ECX_STANDARD.GETXMLTP, POXML, 2011-2055, 180896, RUN)

Error Message: 6012: XML Gateway process aborted: 'ORA-00904: "STYLE_NAME": invalid identifier - ECX_ACTIONS.BIND_VARIABLES_FOR_VIEW". For further details, see the log corresponding to FND-Logging AFLOG MODULE Name: 'ecx.plsql.OAG.out.PO.PRO.17.0:84.4.log'
Error Stack: ECX_STANDARD.getXMLCover(OAG, PO, PRO) ECX_STANDARD.getXMLTP(POXML, 1014-2049, 180896, RUN) Wf_Engine_Util.Function_Call(ECX_STANDARD.GETXMLTP, POXML, 1014-2049, 180896, RUN)

Steps to reproduce:

1-Create a purchase order
2- Send it for approval

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms