My Oracle Support Banner

FAQ: Using Consigned Inventory / Consumption Advice / Vendor Managed Inventory (VMI) (Doc ID 406390.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Inventory Management - Version and later
Oracle Purchasing - Version 12.2.9 to 12.2.9 [Release 12.2]
Information in this document applies to any platform.
FORM:INVCNSUP.FMB - Consigned/VMI Consumption
FORM:POXSCASL.FMB - Define Approved Supplier List
FORM:POXSTASL.FMB - Setup Approved Supplier List
FORM:POXSVASL.FMB - Summary Approved Supplier List


Here are some common questions or tips about Consigned Inventory. Also see <Note 2048039.1> - EBS Inventory Consignment Analyzer.


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
 1.1 What is Consigned Inventory From Supplier?
 1.2 What is Consigned Inventory to Customers?
 2. DEMO
 2.1: Full Demonstration
 2.2: Common Consignment Steps
 3: Helpful Documents / Patches
 3.1(a): Helpful Documents from Oracle Development:
 3.1(b): Critical Consignment Patches
 3.1(c) Other patches
 3.1(d) Enhancement Requests
 3.2(a): Resubmit a stuck consumption transaction?
 3.2(b): Consumption advice does not work...
 3.3 Analyzer
 4: Transfer to Consigned:
 4.1: How does one perform 'Transfer to Consigned' when consumption transaction was generated implicitly?
 4.2: Transfer to Consigned Enhancement
 4.3: When is Transfer to Consigned Available?
 4.4: SQL to review Transfer to Regular Used for Transfer to Consigned?
 5: Can one view the owner party in the subinventory transfer form?
 6: How does one manage consigned inventory with locators?
 7: Consigned Setup
 7.1: What are the setup steps required for using Consigned Inventory?
 7.2: What Setup Required for Consigned Orders in Purchasing?
 7.3: What setup should Suppliers perform for consigned inventory?
 8: How do I specify the owning party during Miscellaneous Transactions?
 a. Using the Miscellaneous Transaction form
 b. Using the Open Interface
 9: Inter-Org Transfer Loses Owning Party / Transfer to Regular
 10: Other Common Errors:
 10.1: Error: This supplier site combination must have a valid Approved Supplier List.
 10.2: Purchase Price Variance (PPV) Report errors with ORA-01476
 10.3: Error: There must be a Valid Blanket Purchase Agreement in effect
 10.4: Error: APP-FND-01030: Value longer than 20 characters
 11: Onhand Shows Zero (0) Attempting to use Consigned Inventory
 <- 12 : Removed. ->
 13: Using Consigned Inventory With OPM?
 14: Helpful SQL
 14.1: Review consumption transaction status via SQL?
 15: Pricing / Value
 15.1:  Can I update the blanket price for a consigned line item?
 15.2: How can I use retroactive price update for consigned shipments?
 15.3: Can price breaks be used for Consigned Stock?
 15.4: Does retroactive pricing update Standard POs used for receiving consigned stock?
 15.5: Finding Price / Value of Consigned Stock?
 16: What is Misc issue / Misc Receipt of Consigned Stock?
 Misc receipt of Consigned Stock:
 Misc issue of Consigned Stock:
 Relating Issue and Transfer
 17: What is Consumption Rules Setup used for?
 18: How does FIFO rules apply for consigned stock?
 19: Sometimes, consumption transactions refer to a different source blanket. Why does this happen?
 20: How do we back-out erroneous misc. receipt of consigned stock?
 21: Is Cycle counting supported for Consigned Inventory?
 22: Consumption advice shipments are split date-wise for local blankets?
 23: Why is no PPV generated when I perform subinventory transfer from an expense subinventory to an asset subinventory?
 24: Performance
 25. Handling unwanted releases?
 26. Is the "Transfer to Consigned" Transaction type supported when performing transactions using MSCA?
 27: Consumption Flow/Diagrams
 27.0 New Column PO_LINE_ID
 27.1: What is the general consignment flow and flags?
 28: Can you reverse already processed consumption advice transactions?

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