FAQ: Using Consigned Inventory / Consumption Advice / Vendor Managed Inventory (VMI)
(Doc ID 406390.1)
Last updated on OCTOBER 20, 2022
Applies to:
Oracle Inventory Management - Version 11.5.10.2 and laterOracle 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
Goal
Here are some common questions or tips about Consigned Inventory. Also see <Note 2048039.1> - EBS Inventory Consignment Analyzer.
Solution
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
| Goal |
| Solution |
| 1: OVERVIEW |
| 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? |
| 27.2: Table MTL_ONHAND_QUANTITIES_DETAIL vs. view MTL_ONHAND_QUANTITIES? |
| 28: Can you reverse already processed consumption advice transactions? |
| References |