My Oracle Support Banner

Troubleshooting & FAQ for Internal Requisitions Item Setup And Automatic Sourcing Setup For iProcurement (Doc ID 403291.1)

Last updated on DECEMBER 11, 2023

Applies to:

Oracle iProcurement - Version 11.5.9 to 12.2 [Release 11.5 to 12.2]
Oracle Purchasing - Version 11.5.9 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.


This document is intended to provide help for diagnosing problems related to Internal Requisitions in iProcurement. It includes setup checks, scripts to run, logs to investigate and SQL queries which can be used to help pinpoint issue details and determine potential causes. Some of the information is also applicable to Internal Requisitions in core apps Purchasing.

Troubleshooting Steps

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
Troubleshooting Steps
 QUESTION 1:  Can Sourcing Rules be used to control items returned in the Search Results in iProcurement?
 QUESTION 2:  How can iProcurement users see on hand Available quantity for Internally sourced items?
 QUESTION 3:  At what point does the internal inventory on hand available quantity get decremented for an item on an internal requisition created in iProcurement?
 QUESTION 4:  Why are only some of the internal source organizations listed after clicking the Click here to select source link in iProcurement search results?  The item has plenty of on hand quantity in other internal source organizations, so users expect to see more choices for the internal sources of the item.
 Row 1 Deliver-To Location - Deliver-To Location is not customer associated for the internally sourced item
 Item ABC123 is not internally orderable for the default Deliver-to location. Select another item or contact purchasing administrator.
 There is no source available for this item

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