R12: Import Standard Purchase Orders Errors Out While Importing Requisition Line with Supplier Reference Number (Doc ID 2631155.1)

Last updated on APRIL 10, 2025

Applies to:

Symptoms

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


ERROR

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.

Cause

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