My Oracle Support Banner

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

Last updated on SEPTEMBER 17, 2021

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.

Purpose

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
Purpose
Troubleshooting Steps
 SETUP CHECKS
 PROFILES
 ITEM
 SHIPPING NETWORK
 LOCATION
 SOURCING RULE
 PROCESSES
 NAVIGATION / TESTING
 TROUBLESHOOTING
 FND DEBUG LOG CAPTURE
 DEBUG LOG CONDITIONS
 FAQ
 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.
 COMMON ERRORS
 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
References

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