My Oracle Support Banner

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' (Doc ID 2385894.1)

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.

Symptoms

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

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.