My Oracle Support Banner

cXML Generation errors with ORA-31011 and ORA-19202 and LPX-00115: Warning: element "PCard" is missing required attribute 'number' (Doc ID 1274952.1)

Last updated on FEBRUARY 20, 2019

Applies to:

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

Symptoms

When attempting to communicate certain purchase orders via XML Gateway with  P-Card information, the cardholder name and the expiration date is no longer in ap_cards_all view.

If a PO is created without P-Card then it successfully transmits the cXML to the supplier.

ERROR
-----------------------
Generation Message:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00115: Warning: element "PCard" is missing required attribute "number' Error at line 1

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a requisition in iProcurement, entering the PCard
2. Save and submit for approval
3. PO is created from the requisition and approved
4. cXML generation fails in error which can be seen in the Transaction Monitor. (This is assuming Trading partner is setup in XML Gateway as well as Supplier in PO)
5. Drill down on the appropriate Document ID for the Internal Transaction Typ: PO which has a Generation Status: Warning

FILE VERSIONS
-------------
poecx.odf 120.1.12010000.6
cXML_OrderRequest.xgm 120.4.12010000.3

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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