R12 E-Business Suite XML Gateway Users Are Unable To Send Document PROCESS_PO_007 To OSN Due To Error 'ORA-06502: PL/SQL: numeric or value error: character to number conversion error - ECX_ACTIONS.BIND_VARIABLES_FOR_VIEW'
Last updated on APRIL 24, 2018
Applies to:Oracle XML Gateway - Version 12.1.3 and later
Information in this document applies to any platform.
E-Business Suite R12 XML Gateway, Install, Setup, Design, and Transport related issues
Users are unable to send Purchasing (PO) XML Documents to OSN as there is an error using the PROCESS_PO_007 mapping need by OSN:
The issue was reported on OMCS related to XML Outbound Message Errors.
Using other maps like cXML_OrderRequest and itg_process_po_007_out the messages are generated and sent however, OSN is not able to process them.
The issue can be reproduced at will with the following steps:
1. Create a PO with supplier having XML setup
2. Approve PO ( self approved in our case)
3. PO will be sent through cXML via OSN
4. Go to System administrator -> Workflow -> transaction Monitor
5. Doc ID found with error -
ORA-06502: PL/SQL: numeric or value error: character to number conversion error - ECX_ACTIONS.BIND_VARIABLES_FOR_VIEW
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms