When Import a Standard PO via PDOI, Using an Item Number, Error: Can Not Derive Item_id For The Specified Buyer Item_number Or Vendor_product_num (Doc ID 2143936.1)

Last updated on DECEMBER 23, 2016

Applies to:

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

Symptoms

 On : 12.1.3 version, Purchasing Processes

When attempting to use PDOI with 'Import Standard Purchase Orders' for adding PO lines,
the following error occurs.

ERROR
-----------------------
table PO_INTERFACE_ERRORS

Error: Can not derive item_id for the specified buyer item_number or vendor_product_num, and import fails.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Using PDOI to create a new PO , insert data with item_number

2. Run Import Standard Purchase Order.

3. Verify the PO_INTERFACE_ERRORS

PS: For the same item when use inventory_item_id, it works. It is for all items.

 

From the log, it shows.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms