Can't Perform Purchase Order Interface In The OSP .. Got PO_PDOI_INVALID_ITEM_ID Error (Doc ID 1480543.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

PO error messages (below) raised when performing Purchase Order Interface in CMRO OSP ie.  clicking on the 'Synchronize POs' button 

PO_PDOI_ITEM_RELATED_INFO
&COLUMN_NAME (VALUE=&VALUE) specified is inactive or invalid for item_id (VALUE=&ITEM).

PO_PDOI_INVALID_ITEM_ID
ITEM ID (VALUE =&VALUE) is not a valid purchasable item.

PO_PDOI_ITEM_RELATED_INFO
&COLUMN_NAME (VALUE=&VALUE) specified is inactive or invalid for item_id (VALUE=&ITEM).

Steps

1. Create Lot ( On-hand, Availability > Lots )
2. Create Instance
3. Assign the Instance to the UC position
4. Approve UC
5. Create a Non-routine from the Work Order
6. Assign the Instance to the Non-routine
7. Remove the Item from the UC in the Non-routine Work Order
8. Change work order's department to new one that has 'Vendor' department class
9. Setup Item Service Relationships
10. Create OSP
11. Submit OSP
12. Synchronize POs .. got the errors below:
- Error: CATEGORY_ID (VALUE=1) specified is inactive or invalid for item_id (VALUE=XXXXXX).
- Error: ITEM ID (VALUE =XXXXXX) is not a valid purchasable item.
- Error: UNIT_MEAS_LOOKUP_CODE (VALUE=Each) specified is inactive or invalid for item_id (VALUE=XXXXXX).

Changes

Cause

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