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.

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

Troubleshooting Steps

SETUP CHECKS

ITEM

SHIPPING NETWORK

SOURCING RULE

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

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