My Oracle Support Banner

The PO_REQUISITION_UPDATE_PUB API Is Erroring With "Item is Missing, Invalid, or Not Internally Orderable For the Purchasing Organization" Error (Doc ID 2365815.1)

Last updated on JULY 15, 2020

Applies to:

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

Symptoms

Users are trying to use PO_REQUISITION_UPDATE_PUB for addition of new requisition lines to existing purchase requisitions.

Even though an item is enabled in an organization and enabled for internal orders this error occurs


Error:
-------
Number of Requisition Lines in Error: 1 Item is missing, invalid, or not internally orderable for the purchasing organization.

Cause The item is missing, invalid or not internal-order enabled for the purchasing organization. This is required for a source type of 'INVENTORY'


STEPS TO REPRODUCE
-----------------------

1. Create a requisition   put an item on it that's not internal ordered

2. Run an insert script to call the API and put a new line on the req

3. Notice the error





Script is as follows to test out scenario

 

 

 

Changes

 

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