Missing On Hand Quantity in R12 for Non-Nettable Subinventories (Doc ID 1467672.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.0 and later
Information in this document applies to any platform.
*** Checked for relevance on 03-Dec-2014 ***

Goal

On hand qty exists in our ERP source instance (R12) for a subinventory that is non-nettable
We run Planning Data Pull in our VCP instance
We then run a sql statement to check MSC_ST_SUPPLIES for the subinventory code that is non-nettable
The query results in no rows selected.

We performed the same procedure collecting from our R11 source instance instead, and the same query shows rows for non-nettable subinventory.

How do we resolve this when collecting from the R12 source instance?
 

Solution

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