My Oracle Support Banner

Cannot Generate PO Xml Output For Non Numeric PO Number (Doc ID 2164598.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Fusion Purchasing Cloud Service - Version and later
Oracle Fusion Purchasing - Version and later
Information in this document applies to any platform.


Users cannot generate PO xml output from data model, and encountering an error.
The PO PDF is getting generated fine.

XML data is working for numeric Document Numbers such as "659", "238", but not working for any Document Number with character prefix , e.g.:"TWP1234".

Information is printing on POs incorrectly and due to this issue, unable to diagnose the issue because cannot generate XML data.
The issue is impacting Purchase Orders with are external business documents.


Failed to load XML

When click on export, users see this message in the xml file:

ORA-06502: PL/SQL: numeric or value error: character to number conversion error.

Steps To Reproduce
1. Log in and access the BI Catalog.
2. Navigate: Procurement > Purchasing > Data Model
3. Open the data model, enter parameters and click view.
4. The 'Failed to load XML ' error is presented.
5. Click on export, ORA-06502 error is generated in xml file.



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.