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

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Complex Maintenance, Repair & Overhaul - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 19-Feb-2014***

PO_PDOI_ITEM_RELATED_INFO
PO_PDOI_INVALID_ITEM_ID
PO_PDOI_ITEM_RELATED_INFO
POXPIVLB.pls
PO_LINES_SV7

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=213955).
- Error: ITEM ID (VALUE =213955) is not a valid purchasable item.
- Error: UNIT_MEAS_LOOKUP_CODE (VALUE=Each) specified is inactive or invalid for item_id (VALUE=213955).

 

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