My Oracle Support Banner

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
PO_REQ_REF_VAL_TYPE.sql


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

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
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.