R12: Import Standard Purchase Orders Errors Out While Importing Requisition Line with Supplier Reference Number
(Doc ID 2631155.1)
Last updated on JULY 07, 2020
Applies to:Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.
PDOI: Import Standard Purchase Orders
While attempting to run PDOI: Import Standard Purchase Orders program for importing Punchout Purchase Requisition line with Supplier Ref Number
and create Standard Purchase Orders, the following error occurs
ORACLE error 6510 in FDPSTP
Cause: FDPSTP failed due to ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PO_PDOI_GRP", line 392
ORA-06512: at line 1
When the requisition is created for few suppliers, the supplier_ref_num is populated from supplier punchout.
These requisitions are not getting imported by Import Standard Purchase Orders program.
When a requisition does not have supplier_ref_num, the import program could able to create standard PO.
Steps to reproduce:
1. Responsibility: Purchasing
2. Create Blanket Purchase Agreement (BPA) # XXXX
for Item xxxxx
3. Create Requisition # XXXXX
4. Update SUPPLIER REF NUMBER
SQL> update po_requisition_lines_all
Set SUPPLIER_REF_NUMBER = 'abcdefxxxxxx'
Where REQUISITION_LINE_ID = xxxxx;
5. Insert data into interface tables.
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