Oracle Purchasing - Version: 11.5.9 This problem can occur on any platform. PDOI
Symptoms
"Import Standard Purchase Orders" program is failing in few cases with the following error message.
Error Message in Output file -------------------------------- DECLARE * ERROR at line 1: ORA-1403: no data found ORA-6512: at line 55
The log file shows: Action: ORIGINAL Interface Header ID: 1929535 Check if any active catalogs exist with the same vendor document number. Start deriving data for po_headers Start header defaulting process Start header create process Start header validation process -->Intfc error occurred ...PO_PDOI_INVALID_PAY_TERMS Start update the process_code
Payment_terms is NULL in the po_header_interface, other Lines can be imported with payment_terms = NULL
Cause
Invalid term defined in the Vendor or vendor site. If terms_id or payments terms is not populated, then system try to default the terms id from vendor site and if null then from vendor.
Solution
Change the setup for the supplier and Site Use a Valid Payment Term in the vendor and Vendor Site used in the import
References
Bug 5690677 - ''IMPORT STANDARD PURCHASE ORDERS'' PROGRAM IS THROWING AN ERROR ''ORA-01403: NO
