consigned inventory vmi document id 406390 1

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

Modified: Jun 20, 2013 Type: HOWTO

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 advise does not work...

3.3 Sample Diagnostic

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.4: 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: Drill Down in Material Workbench Displays the Wrong Quantity

Document 406390.1 https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrl-state...

1 of 21 3/31/2014 5:34 PM

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?

References

APPLIES TO:

Oracle Inventory Management - Version 11.5.10.0 and laterInformation in this document applies to any platform.FORM:INVCNSUP.FMB - Consigned/VMI ConsumptionFORM:POXSCASL.FMB - Define Approved Supplier ListFORM:POXSTASL.FMB - Setup Approved Supplier ListFORM:POXSVASL.FMB - Summary Approved Supplier List

GOAL

Here are some common questions or tips about Consigned Inventory.

SOLUTION

1: OVERVIEW

IMPORTANT: This note focuses on "Consigned Inventory From Supplier". For details on "Consigned Inventory to Customers", seeNote 391582.1 - Obtain Information On Consignment Orders


2 of 21 3/31/2014 5:34 PM

1.1 What is Consigned Inventory From Supplier?

From the "Consigned inventory from supplier" User's Guide:Consigned inventory from supplier exists when inventory is in the possession of oneparty (a dealer, agent, distributor, and so on), but remains the property of another party(such as the manufacturer or primary contractor) by mutual agreement. Consignedinventory from Supplier refers to one type of consigned inventory practice where youreceive and maintain goods belonging to one or more of your suppliers. Both suppliersand customers benefit through a consigned inventory strategy:

Suppliers can compete on the basis of availability and delivery when finished goods are at the customer site, particularly whenlead times are lengthy.Holding material on consignment reduces the lead time for items that might be required to fill sales orders.Customers experience increased inventory turns thus, reducing funds invested in inventory. Financial resources are free untilcustomer commitments are ensured, or items are used in production.

1.2 What is Consigned Inventory to Customers?

2. DEMO

2.1: Full Demonstration

There is a nice brief demonstration in Note 1083776.1.Here is a full demonstration created by Oracle Development in flash-wave format. It should be run in your browser after you downloadthe file.

2.2: Common Consignment Steps

Here are some other demonstrations for Consigned Inventory. Currently these are .exe files for Windows machines only:


3 of 21 3/31/2014 5:34 PM

a. Miscellaneous Receipt for Consigned Inventoryb. Transfer to Regularc. Viewing Consigned Inventory

3: Helpful Documents / Patches

3.1(a): Helpful Documents from Oracle Development:

These are some helpful documents provided by Oracle Development to Oracle Support for diagnosing problems as well as to help betterunderstand consignment. Providing them here for reference by support and customers :

a. Consigned Notes - Review of Consignment Functionalityb. Consigned Support Diagnostics - Review of Common Consignment Issuesc. Consigned Bug Logging - Things to provide when logging a consignment SR/Bug

3.1(b): Critical Consignment Patches

Ensure that you already have the critical consignment patches: Patch 5036673 for 11.5.9 and Patch 5200436 for 11.5.10.

Patch 5036673 (for 11.5.9) includes the following files:invcons.odf 115.7.11590.3INVRCADB.pls 115.22.11590.31INVVTPSB.pls 115.12.11590.14b4649230.sql 115.4

You could use commands like the following to check your version:

grep '$Header' $INV_TOP/patch/115/odf/invcons.odfgrep '$Header' $INV_TOP/patch/115/sql/INVRCADB.plsgrep '$Header' $INV_TOP/patch/115/sql/INVVTPSB.plsgrep '$Header' $INV_TOP/patch/115/sql/b4649230.sql

Patch 5200436 (for 11.5.10) includes the following files:invcons.odf 115.13.115100.3INVMCTUPG.sql 115.1INVRCADB.pls 115.55.115100.29INVVTPSB.pls 115.22.115100.4

You could use commands like the following to check your version:

grep '$Header' $INV_TOP/patch/115/odf/invcons.odfgrep '$Header' $INV_TOP/patch/115/sql/INVMCTUPG.sqlgrep '$Header' $INV_TOP/patch/115/sql/INVRCADB.plsgrep '$Header' $INV_TOP/patch/115/sql/INVVTPSB.pls

3.1(c) Other patches

There have been a number of other patches released for consignment on 11.5.10 since the initial critical patch. The easiest way to stayup to date is to stay on the latest inventory rollup (INV RUP). The rollups are continually improving the inventory and consignmentmodules fixing issues, preventing data corruption, helping performance, etc. See the latest Rollups in Note 726226.1.

Below is a summary of helpful fixes between the critical patch and more recent patches on 11.5.10:

Patch 5200436 - 11.5.10: Consigned Inv consolidated bugfix patch -- CORRUPT CONSUMPTION ADVICE RELEASES CREATED


4 of 21 3/31/2014 5:34 PM

INVRCADB.pls 115.55.115100.30* This is the patch listed as critical. It also included a number of performance fixes in earlier releases like the following patches:Patch 5107164 - 11.5.10: Consigned Inventory performance patchINVRCADB.pls 115.55.115100.24Patch 5113003 - GBL : 11.5.10 CU FOR CONSIGNED INVENTORYINVRCADB.pls 115.55.115100.28

Patch 5367157 - DROP UPGRADE SCRIPT FROM 5107164 FOR BETTER PERFORMANCEINVRCADB.pls 115.55.115100.30

Patch 5506999 - TRACKING BUG FOR PERFORMANCE ISSUE RELATED TO 5092489INVRCADB.pls 115.55.115100.33

Patch 5659866 - CONSOLIDATED PATCH FOR CREATE CONSUMPTION ADVICE PERFORMANCE ISSUEINVRCADB.pls 115.55.115100.35

Patch 6945480 - NO NEW RELEASES ARE GETTING CREATED FOR CREATE CONSUMPTION ADVISEINVRCADB.pls 115.55.115100.38* At the time of this note edit in February 2010, this was the highest one-off consumption advise patch.

Patch 9063156 - Oracle Inventory and Receiving (PO): Release 11.5.10, Rollup Patch 18INVRCADB.pls 115.55.115100.44* This was the latest rollup patch when this note was last edited in February 2010.It has a number of releases above 38 related to consumption but no one-offs available.

3.1(d) Enhancement Requests

Here are some commonly referenced enhancement requests (ERs) related to consigned inventory or consumption advise. Note that anenhancement request is tracked as a low-level bug. Therefore, you can query these enhancements via the bug tracking system.

Bug 5156251 - Allow implicit transfer back to consigned

Bug 6845969 - Allow Transactions To Issue Out Non-Consigned Ma terial Only

Bug 6845983 - Subinventory Transfer Specifying Owning Party Fo r Consigned Transactions

Bug 6842739 - Resubmit Consumption Transactions Via Form

Bug 6845989 - Allow flag consumption transactions to cancel wi th reason

Bug 12971726 - Allow Create Consumption Advice If Consumed Befo re PO Cancelled

Bug 6510841 - Seeded Consignment Workflow For Shipping Invento ry From Supplier

Bug 3877988 - Printed Consumption Advise for Manual Communicat ion to Suppliers

Bug 7241511 - Show Request/Log From Consumption Worker (INVCTX CW) in Inventory** This was implemented in 11.5.10 INV RUP 11 and h igher. See Note 726226.1 for details on therollups (RUPs).If you do NOT have the fix, you can ask your system admin to look for all recently completedrequests for "Create consumption advise worker". Or use this SQL:

select request_id, PROGRAM_SHORT_NAME, STATUS_CODE, PRIORITYfrom fnd_conc_req_summary_v cwhere REQUEST_DATE > sysdate - 10and PROGRAM_SHORT_NAME = 'INVCTXCW';

Bug 6795450 - Consignment Transactions In Error With Code INV_ SUP_CONS_NO_BPO_EXISTS** This was implemented in 11.5.10 INV RUP 16 and h igher. See Note 726226.1 for details on therollups (RUPs).

Bug 7672084 - Cycle Counting For Consigned Stock

Bug 9201771 - Allow consigned items to be interfaced using the open interface(MTL_TRANSACTIONS_INTERFACE) -- OWNING_ORGANIZATION_ID is NOT honored** This appears to work fine on 11.5.10+. Tested on INV RUP 16.


5 of 21 3/31/2014 5:34 PM

3.2(a): Resubmit a stuck consumption transaction?

The application does not provide a method at this time for resubmitting stuck consumption transactions. An enhancement request (ER)Bug 6842739 was logged requesting the functionality. Until then, users must resubmit transactions using SQL. The following identifies iftransactions are stuck and provides SQL to resubmit:

a. Check for stuck transactions by looking at batch_id and the consumption processed flag:

Select count (*) from mtl_consumption_transactionsWhere nvl (batch_id, -1) <> -1And consumption_processed_flag in ('N','E');

b. If count is greater then ZERO, do the following to resubmit the transactions:

Update mtl_consumption_transactionsSet batch_id = NULLWhere batch_id is NOT NULLAnd consumption_processed_flag in ('N','E');COMMIT;

3.2(b): Consumption advise does not work...

The "consumption advise" is the name of a concurrent program that generates Purchase Orders or Purchase Order Releases so that asupplier can bill for used material. This also helps suppliers know what inventory needs to be replenished. See Chapter 3 (especiallypage 3-4) of the "Consigned Inventory From Supplier Process Guide" for an explanation of the program and process.

There are a few notes and bugs related to the consumption advise program completing but not generating purchase orders or releases-- Here are some Notes that might be helpful:

Note 404609.1 Create Consumption Advice Program Not Creating Releases For PaymentNote 394123.1 Transactions in MTL_CONSUMPTION_TRANSACTIONS with INV_SUP_CONS_NO_BPO_EXISTSNote 308875.1 Create Consumption Advice For Consignment Not WorkingNote 312724.1 and <> How to Print the Consumption Advise Report?Note 333027.1 11i INVRCADB Invoices Not Being Created For Consignment Inventory <> FAQ: Using Consigned Inventory /Consumption Advise /Vendor Managed Inventory (VMI)Note 1087599.1 Vision Demo - How To Consume Consigned Inventory (Consumption Advise)

Here are some common situations and helpful SQL used to check for the issues:

a. Check for NULL transaction_source_id :

Select count (*) from mtl_consumption_transactions mct, mtl_material_transactions mmtWhere mct.transaction_id = mmt.transaction_idAnd mct.consumption_processed_flag in ('N','E')And mmt.transaction_source_id is NULL;

If Count is greater then ZERO, 'Create Consumption Advice' will fail. See Note 452970.1 for a root-cause patch and Note 438935.1for a datafix.

b. Check for INVALID blankets:Check if the blankets are valid at the time 'Create Consumption Advice' is run. By design, the blankets MUST BE OPEN/ACTIVE whenCreate Consumption is run.

You have to check the validity at:. The blanket header / line level. Expiry dates set if any at the line level and in the 'Terms' of the blanket. Purcahse Order 'Control' Options.


6 of 21 3/31/2014 5:34 PM

The "Create Consumption Advice Worker" will show an "****INVALID LINE" error for invalid blankets.

c. Check the billing cycleCheck the billing cycle in the approved supplier list. The 'Consumption Advice' will NOT be created unless the billing cyle has beenelapsed. To check the billing cycle, you could review the Approved Supplier List (ASL) via the Purchasing (PO) forms using PO >Suppliers > Approved Supplier List. If the billing cycle has not passed, regardless of how many times 'Create consumption' is run,the transactions will not be picked up. People often miss looking at the billing cycle so think that consumption advise is broken as itdoes not generate releases. Actually, they had setup the application to only bill every 30 days for example and that is why nothingis generated. Here is an example query as well that we were working on to help look for stuck transactions where the billing cyclehas not yet passed. You could modify it to limit by item (mmt.inventory_item_id) if there are too many results.

Here is the sample query:select distinct paa.ASL_ID, paa.last_billing_date, paa.consigned_billing_cyclefrom apps.po_asl_attributes paawhere paa.last_billing_date + paa.consigned_billing_cycle < sysdateand paa.asl_id IN (select pad.asl_idfrom apps.po_asl_documents pad,apps.po_lines_all pol,apps.mtl_consumption_transactions mct,apps.mtl_material_transactions mmtwhere pad.document_header_id = mmt.transaction_source_idand pad.document_line_id = pol.po_line_idand pol.item_id = mmt.inventory_item_idand mct.consumption_processed_flag IN ('E','N')and mct.transaction_id = mmt.transaction_idand mmt.organization_id = &EnterYourOrgID);

* If the billing cycle has not yet passed, you might see something like the following in the "Create consumption advise worker" logfile with Inventory Debug enabled: "INV_CONSUMPTION_ADVICE_PROC: Consumption Txn Worker(l_elapsed)1". This means billingcycle days did not pass yet. It is followed by "<< Delete Record where the record is purged from the batch." The developers explainthis message indicates: "If the billing date for the current asl entry has not elapsed yet then the associated change of ownershiptransactions held in MTL_CONSUMPTION_TRANSACTIONS should not be processed yet. The current record slipped into this loop forthat reason and should therefore be deleted from the current batch."

d. Check for NULL blanket_price:Select count (*) from mtl_consumption_transactionsWhere consumption_processed_flag in ('N','E')And blanket_price is NULL;

A script will have to be run to populate the blanket price(b4649230.sql). Create consumption Advice will fail for NULL blanket prices.See Note 401787.1 for details on the script. If you already have the patch that provides the script, you could rerun the script tocorrect the data. If you have the patch, but continue to have this issue occur, log a service request for assistance.

e. Check for PO Auto Create failure:If the log file contains INV_SUP_CONS_AUTO_CREATE_FAIL, see Note 601692.1 checking if you have a global Approved Supplier List(ASL), and if so ensuring you have the right patch level. If the issue remains, log an SR to get assistance as we may need to log abug with Purchasing (502) for Auto Create Failure.

f. Duplicate Releases CreatedIf you have this issue, you are likely on a very old version of the Consigned files. Please confirm you have patch 5200436 (for11.5.10) and 5036673 (for 11.5.9)

In order to retrieve the duplicate releases, the following query will have to be run:SELECT DISTINCT por.po_release_idFROM po_releases_all por, po_line_locations_all pollWHERE por.po_release_id = poll.po_release_idAND poll.shipment_type = 'BLANKET'And por.consigned_consumption_flag = 'Y'AND por.po_release_id NOT IN(Select DISTINCT consumption_release_id


7 of 21 3/31/2014 5:34 PM

FROM MTL_CONSUMPTION_TRANSACTIONSWhere consumption_release_id is NOT NULL);

Often you can remove duplicates via the forms. See the sections below "Handling unwanted releases?". We also have scripts tocancel the duplicates. Log an Service Request to get help from Oracle Support if you cannot accomplish this via the form. They willlikely first have you run invgcacl.pls followed by invgposf.sql

g. Consigned Stock Not IssuedCheck if regular stock and consigned stock are co-mingled for the same item in a given subinventory. Should this be the case, thestock is always issued on FIFO basis. This may be the reason why regular stock may be issued ahead of Consigned stock.

h. Ownership Transfer Not Occuring For Consigned Stock: Invalid Blanket1. Check if any of the blanket or any of the lines in the blanket is closed.2. Check the expiration date on the lines3. Check the End Date on the TERMS page in the blanket4. Item Revision (if any) must exist on the blanket5. If there is no blanket number specified on the ASL, ensure that the profile PO%Automatic Document Sourcing is set to 'Yes'. Thiswould pick up the latest blanket.6. Ensure that vendor product number is less than 10 characters if patch 3223055 is not applied

i. Subinventory Transfer Not Triggering Consumption:Check the Consumption/VMI Rules setup: By default, a subinventory transfer carried the 'Consigned Stock' status to the destinationsubinventory in subinventory transfers.

If explicit rules have been setup (using the Consigned / VMI Rules setup form), the consumption will be triggered and thedestination subinventory would have regular stock.

j. Accrual Reconcialiation Failure / Missing Po_Distribution_Id In MTL_CONSUMPTION_TRANSACTIONSPO_DISTRITIBUTION_ID is automatiacally populated when 'Create Consumption Advice' is run. However, for customers who havenot applied patch 5200436, the Accrual Reconcialiation process may fail. So, please ask the customers to appy 5200436.Note: This fix is available only for 11.5.10

k. Consumption Advice Is Splitting Shipments On A Daily Basis For Local BlanketsCheck the Profile option: "INV: Summarize Consumption By Need By Date". By default, the value is NULL. If set to Yes, theshipments in a release will be grouped according to the transaction dates.Note: This profile option does NOT affect consumptions referring to global blankets.

l. INV_CONS_SUP_INVALID_BPO (or other versions INV_CONS_SUP_E_INVALID_BPO and INV_CONS_SUP_A_INVALID_BPO)Description: Standard application text for the error codes: Ensure that the blanket agreement is approved. The agreement and therelevant purchase order lines must have future effectivity end dates and open status. Cannot release this item using the blanketagreement.Suggestion: As stated by the error description, the first thing to check is the blanke.t Make sure it is open, approved, has thecorrect effective date, item, approved supplier list, etc. The patch 6766266 and patch 6945480 were recommended in the past forthis issue on 11.5.10 via Bug.7249870. The patch 6945480 provides INVRCADB.pls 115.55.115100.38

m. INV_CONS_SUP_NO_BPO_EXISTSThere must be a Valid Blanket Purchase Agreement in effect for the item you wish to transact.See Note 342366.1.

3.3 Sample Diagnostic

The following diagnostic is still being developed.

Here is an updated version of the diagnostic: Consignment Diagnostic - NEW VERSION!The output is the same but this version skips the check for batch id so returns all consignment records waiting to process even ifthe batch id is -1 or NULL which signifies the record was not picked up yet. This was required because many customers werefinding the batch id remained NULL, but the record resulted in error during consumption advise.Here is an Older version - Consignment DiagnosticThis version checks for the batch id to be NOT NULL. Often this was not returning data. If the new version above returns toomany rows, you can try this version to limit the results.


8 of 21 3/31/2014 5:34 PM

Here is the sample output: Sample Output.

4: Transfer to Consigned:

4.1: How does one perform 'Transfer to Consigned' w hen consumption transaction was generated implicitl y?

The short answer is that "Transfer to Consigned" is not available at this time for implicit "Transfer to Regular" transactions. From abusiness point of view, this means that if you accidentally used inventory from a vendor, you cannot simply transfer it back via a"Transfer to Consigned". You might expect 'Transfer to Consigned' to work for implicit consumption transactions. When you take thefollowing steps, there are no transactions available. Due to this issue, unable to handle/process returns for over receipts of consignedinventory.

That you might have expected to work follow:1. Navigation: Inventory > Transactions > Consigned Transactions2. Enter type as Transfer to Consigned3. Click transaction lines button.4. Try to use the LOV for "Owning Party" or "Consumption Transactions"5. No list of values are returned.** Transferring back to "Consigned" is not supported for implicit transfers to regular.

From NOTE: 258630.1:- If the change of ownership from the Supplier has taken place via 'Implicit Consumption' viz. MoveOrder Transaction, or Back flush etc, then this problem will happen.

- For Implicit Consumption the Transaction Type 'Transfer to Consigned' will not work.This is because the link for the originating Transaction for consigned Receipt is lost whenan Implicit Consumption is done. Only when you do a 'Transfer to regular' transaction (Explicit Consumption) to changethe ownership from Supplier you will be able to return this to the supplier using 'Transfer toconsigned'

- As a workaround, when you need to move the Items back to the supplierin case of a Implicit consumption, you can use the following limited option.You can do a Misc issue of the Item from the subinventory. Using Folder / Show fieldchoose the Owning Party as the Supplier, and in the Account choose 'AP Accrual Account'Then Subsequently you can use a Misc receipt to with Owning Party againas the supplier to increase the Consigned Inventory Stock.

- This Workaround does not apply if there exists a Purchasing Price Variance.(Suppose in a standard Costing Organization you receive the Items to Consigned Stock at 12$and the Standard Cost of the Item is 10$, then the implicit consumption will result in a 2$ PPV.However, when you do a misc Issue it will be done at 10$ - standard cost. This will result in anunbalance of 2$).

From NOTE: 364738.11. The "Transfer to Consigned" does not work because of the following:a. Transfer to consigned transaction is currently supported only for 'Transfer to regular'transactions entered manually using Consigned Transactions window.b. Only 'Transfer to regular' entered manually are called Explicit consumptions all other createdby the system are implicitconsumptions.c. In case of Miscellaneous issue, the ownership transfer is created by the system and is stillimplicit though the owning party might have been specified.d. The documentation text might have created the confusion and will modified.e. More details exist in section 4-6 of the Consignment User's Guide under the Return to Vendorsection.f. Support for 'Transfer to consigned' for implicit transactions is a known issue and we alreadyhave an ER to address that, but as of now the support is only for 'Transfer to Regular'transactions entered manually using the Consigned Transactions window.

2. The following workarounds are available:a. Manually transfer to regular instead of performing an explicit consumption transaction.b. Correct mistakes in transfers via miscellaneous issues from the owning organization andmiscellaneous receipt into the supplier organization.

4.2: Transfer to Consigned Enhancement


9 of 21 3/31/2014 5:34 PM

Please monitor for Enhancement Request (ER) Bug 5156251 that focuses on the suggestion requesting that implicit transfers also allow"Transfer to Consigned".

4.4: When is Transfer to Consigned Available?

After Patch 4890407 with the transaction form INVTTMTX 115.239.115100.22 or higher, the list of available consignment transactions islimited to those transactions that have a source code of EXPLICIT. Before this patch, the 'TRANSACTION_BATCH_SEQ' inMTL_MATERIAL_TRANSACTIONS was used to differentiate between IMPLICIT and EXPLICIT consumption transactions. This was causingissues in "Return to Vendor" Transactions for mobile transactions. The query for the List of Values is something like the following:

SELECT mmt.*FROM MTL_MATERIAL_TRANSACTIONS mmt , MTL_CONSUMPTION_TXN_TEMP mcttWHERE mmt.transaction_id=mctt.transaction_id AND mmt.transaction_type_id=74 AND mmt.source_code = 'EXPLICIT'AND nvl(mctt.net_qty,0) > 0

4.4: SQL to review Transfer to Regular Used for Tra nsfer to Consigned?

You can track what transaction was responsible for a transfer to consigned using the parent id. To perform a transfer to consigned, onemust have at transfer to regular. Upon saving the transfer to consigned, the related transfer to regular transaction is recorded in thenew transaction's parent transaction id column. The following SQL returns the transfer to regular transaction responsible for the transferto consigned. It prompts for the transaction id of the transfer to consigned as &EnterTransactionID.

select * from mtl_material_transactions mmtwhere mmt.transaction_id IN (select mct.parent_transaction_id from mtl_consumption_transactions mctwhere mct.transaction_id = &EnterTransactionID)

5: Can one view the owner party in the subinventory transfer form?

No, see more details in NOTE: 344337.1 Issue With Inventory Movement From Consigned Subinventory.Here is a snippet:

Current behavior is that for subinventory transfers there is no owning party access on the form.In other words the system does not distinguish between consigned and non-consigned stock whenperforming a subinventory transfer. the system does consumption on the basis of FIFO.

This question was addressed in bug 4246717 and Bug 4128396 - TRANSFER TO REGULAR NOT DECREMENTED CORRECTLY.

Suggested workaround:In the subinventory where both consigned and non-consigned stock will be maintained, create 2locators: one that will be designated for consigned quantities only, and one that will bedesignated for non-consigned quantities only. Thereafter when receiving or transferring stock outof that subinventory, be sure to specify the correct locator to pull from, based on whetherconsigned or non-consigned stock is to be transacted. When consuming consigned stock, use the'Transfer to Regular' option, specifying the non-consigned locator into which the consumed stockwill be put.


10 of 21 3/31/2014 5:34 PM

Correcting Comingled InventoryComingled inventory would occur when you have both regular (owned) inventory and consigned (supplier-owned) inventory in the samelocation (like the same subinventory when not using locators).

A. If the regular stock has the oldest receipt date, you can simply subinventory transfer.The oldest stock thru FIFO goes first, so it can be transferred to another subinventory. You can review the receipt date by queryingagainst the MTL_ONHAND_QUANTITIES_DETAIL table looking at the DATE_RECEIVED and ORIG_DATE_RECEIVED columns. Originaldate received is only used when the profile option "INV: FIFO for Original Receipt Date" is set to track original receipt date.

B. If the consigned stock has the oldest receipt date, you have to trick the system so that the receipt flag is reset on the consignedinventory. This will make the regular / owned stock have the oldest receipt date and let you do the transaction like in #1. To trick thesystem, take the following steps:

Let's say you have 20 in consigned and 19 in regular comingled into the same subinventory.a. Perform 'Transfer to regular' of the consigned stock - let's say 20b. Now transfer the 20 back thru 'Transfer to Consigned.'* This reset the receipt date on the consigned inventory to the NEWEST.c. Now you can perform a subinventory transfer of the 19. The FIFO rules will ensure that the regular stock is now used.

6: How does one manage consigned inventory with loc ators?

For example, do we transfer the inventory to company owned when we need to use it?

The point about using a separate locator is so that your users will know when they are going toconsigned inventory or when they are using inhouse inventory. Depending on how you are using theapplication and what types of transactions, you should not have to manually transfer fromconsigned. You should just simply use the inventory in the consigned locator.

You should be able to use the inventory from the locator via normal processing. The applicationshould determine where to get the inventory. For miscellaneous issues from the consigned locator,the transfer to regular will occur and the inventory will be issued. The same can be setup forsubinventory transfer from the consigned locator. For the transfer to regular to be automated,you would use the "Consignment Setup" screen. This is in Setup > Transactions > Consigned/VMIConsumption.

See some test cases listed above outlining how the transfer to regular and the use of consignedinventory can be automated.

7: Consigned Setup

7.1: What are the setup steps required for using Co nsigned Inventory?

See Section B of the "Consigned Inventory User's Guide". This walks through the following steps:Step 1 Set Up OrganizationsStep 2 Set Up Oracle Inventory ItemsStep 3 Set Up Oracle Approved Supplier List and Supplier SitesStep 4 Set Up Profile OptionsStep 5 Numbering OptionsStep 6 Set Up Oracle Purchasing Blanket Purchase AgreementStep 7 Define Consumption Rules (optional)Step 8 Set Up Pay Options in Oracle PayablesStep 9 Set Up Oracle Workflows

See the demonstrations above in FAQ point #1.Also see Note 405518.1.

7.2: What Setup Required for Consigned Orders in Pu rchasing?

See Note 428100.1.

7.3: What setup should Suppliers perform for consig ned inventory?

The consignment functionality provides warehouses purchasing consigned inventory with features to track and even allow suppliers to


11 of 21 3/31/2014 5:34 PM

review inventory usage. But what if the supplier has implemented the Oracle Applications? Will they have features withinConsignment? A supplier using the Oracle Applications internally will need to ship inventory but not bill the customer until confirmationis received that the inventory was consumed.

In R11i you have to modify the Order Management workflow to handle this custom billing process. This is the basic approach to take inR11i:1) Use the shipping feature of trip stop planning. In case of FOB point being customer destination thenperform the ship confirm but do not close the trip and defer the inventory interface.This way the inventory is still held in the Inv org. Once the goods are received, update the "Trip" and allow inventory interface (COGS)and AR invoicing.2) Map COGS account to Intransit account. Control the Invoicing process by workflow wait activity before fulfillment if its fixed daysbased. Use an extension to systematically revert and book actual COGS once the line is invoiced.3) Alternatively use invoice hold in the above case.4) Consider using the defererred revenue accounting with sl no-2.

In R12 we have a new feature called Deferred Revenue Recognition which handles the scenario. It also takes into considerationwhen the COGS account is updated.

8: How do I specify the owning party during Miscell aneous Transactions?

a. Using the Miscellaneous Transaction form

To specify the owning party on the miscellaneous transaction form, one must use the folder tools and add the column "OWNINGPARTY". This column IS NOT available for all types of transactions, for example, not available in Account Alias transactions. After addingthe column, one can enter the specific owning party for the inventory being used. For example, you might want to explicitly pick theowning party for a miscellaneous issue. To do this, you would take the following steps:

Navigate to Inventory > Transactions > Miscellaneous TransactionsEnter the transaction header information, for example, Miscellaneous IssuePress the Transaction Lines buttonEnter the itemThe cursor moves to the next field, Subinventory.Choose Folder > Show Field from the top MenuSelect Owning PartyPress OkThe owning party field now displaysThe combination of Supplier and Supplier Site are selected in this fieldThe value is validated against available selections

b. Using the Open Interface

The ER / Bug 9201771 indicates that consignment transactions cannot be done passing in the owning organization as it is ignored. Anumber of support engineers have tested this on 11.5.10 and higher. It worked fine. Below are details of the test and example SQL:

You can use the inventory interface for loading consigned inventory into your warehouse as a miscellaneous Receipt of consigned items.Specially required if you are migrating data due to an initial installation. You can use the following script as example for which you haveto perform the changes accordingly to your specific needs. After successful process, the Material Workbench form will show theconsigned item with the quantity 1 in a subinventory. Enter variables that match your environment for inventory item subinventory,inventory organization and supplier site id.

Here is the insert:

INSERT INTO mtl_transactions_interface(transaction_interface_id, transaction_uom, transac tion_date,source_code, source_line_id, source_header_id, proc ess_flag,transaction_mode, lock_flag, last_update_date, last _updated_by,creation_date, created_by, inventory_item_id, subin ventory_code,organization_id, transaction_quantity, transaction_ type_id,owning_organization_id, owning_tp_type)VALUES (mtl_material_transactions_s.NEXTVAL, 'Ea', SYSDATE,'Miscellaneous Receipt', -1, -1, 1,3, 2, SYSDATE, 1318,SYSDATE, 1318, '&EnterItemID', '&EnterSubinventory' ,'&EnterINVOrgID', 1, 42,'&EnterSupplierSiteID', 1);


12 of 21 3/31/2014 5:34 PM

Example parameters:EnterItemID: 317990EnterSubinventoryCode: FGIEnterSupplierSiteID: 1414(In Vision, 1414 is the supplier site id of Corp HQ from Vendor ID 600 / 3M Health Care)

You might use SQL like the following to help identify the supplier site (VENDOR_SITE_ID):

SELECT VENDOR_SITE_ID,VENDOR_SITE_CODE,ADDRESS_LINE1,CITY,STATE,COUNTRYFROM PO_VENDOR_SITES_ALLWHERE VENDOR_SITE_CODE LIKE UPPER('%&SUPPLIER_SITE%');

Or you can use SQL like this that looks at the supplier and supplier site:

Select b.Vendor_Site_Id USE_THIS_ID, a.vendor_id, a .segment1, a.vendor_name, b.VENDOR_SITE_CODE,b.Vendor_Site_Id, b.Vendor_Site_Code, b.Address_Lin e1, b.City, b.State, b.CountryFROM PO_VENDOR_SITES_ALL b, PO_VENDORS aWhere a.vendor_name Like Upper('%&SUPPLIER_NAME%')and B.Vendor_Site_Code Like Upper('%&SUPPLIER_SITE% ')and a.vendor_id = b.vendor_id;

9: Inter-Org Transfer Loses Owning Party / Transfer to Regular

An Inter-Org Transfer results in the onhand quantity no longer belonging to the consigned party. Effectively, the inter-org transfer losesthe Owning Party and takes the destination organization as the new owner. If you look at the transactions after the inter-org transfer,you will see that the system does an implicit consumption Transfering to the onhand quantity to Regular in the source organizationbefore doing the transfer.

This is a known issue logged in Enhancement Request Bug 5555142. The issue is very critical to many customers. Unfortunately, it isnot something the product does yet (as of the time this note was written).

10: Other Common Errors:

10.1: Error: This supplier site combination must ha ve a valid Approved Supplier List.

If you receive the error, "This supplier site combination must have a valid Approved Supplier List", ensure the item has an approvedsupplier listed. See Note 406392.1 for details on the error and the related setup.

10.2: Purchase Price Variance (PPV) Report errors w ith ORA-01476

See note 293403.1 that discusses the datafix as well as Note 552072.1 that has an explanation of the cause and details on how toavoid future occurrences of data issues.

10.3: Error: There must be a Valid Blanket Purchase Agreement in effect

Confirm your setup per Section B of the "Consigned Inventory From Supplier Process Guide". Also see Note 342366.1.


13 of 21 3/31/2014 5:34 PM

10.4: Error: APP-FND-01030: Value longer than 20 ch aracters

Full error: APP-FND-01030: Value xyz is longer than its maximum length of 20 characters. See Note 559326.1.

11: Onhand Shows Zero (0) Attempting to use Consign ed Inventory

During a transfer to regular, if the Onhand quantity shows zero (0), you might check out Note 273958.1.

12: Drill Down in Material Workbench Displays the W rong Quantity

If the drill down in Material Workbench (INVMATWB.fmb) displays the wrong quantity for consigned inventory, see Note 306397.1.

13: Using Consigned Inventory With OPM?

If you are using Process Manufacturing (OPM), you might be wondering if you can use Consigned Inventory. As of 11.5.10, this was notsupported. See Note 404597.1.

14: Helpful SQL

14.1: Review consumption transaction status via SQL ?

One can view the status of consumption via the Material Transactions form available via Inventory > Transactions MaterialTransactions. After querying the transaction, one can goto the Consumption Advise tab and look at the From Owning Party, status ofthe consumption, and any associated errors.

One can view the similar data via SQL. The consumption table (MTL_CONSUMPTION_TRANSACTIONS) stores the status of consumptiontransactions by transaction id. The following SQL would look at a specific transaction id and view the process status and errorexplanation.

SELECT DECODE(CONSUMPTION_PROCESSED_FLAG,'Y', 'Created', 'E', 'Error','Pending'), ERROR_EXPLANATION

FROM MTL_CONSUMPTION_TRANSACTIONS

WHERE TRANSACTION_ID = &EnterYourTransactionID

/

15: Pricing / Value

15.1: Can I update the blanket price for a consign ed line item?

You can update the blanket price on a blanket agreement for a consigned line item. Without using retroactive pricing, the price on thecreated consumption advices will NOT be changed. For new transactions (transfer to regular txns), the new blanket price would bestamped to consumption (MTL_CONSUMPTION_TRANSACTIONS) table.

15.2: How can I use retroactive price update for co nsigned shipments?

The process of applying retroactive price updates to purchasing documents for consigned material is same as that for regular material.Consumption advices are retroactively update only when the profile - "PO: Allow Retroactive Pricing of Po" is set to "ALL RELEASES".You can execute retroactive price updates either from the PO Approval screen or by submitting the Retroactive Price Update concurrentprogram. When using the PO Approval screen to make retroactive price updates, enable the "Apply Retroactive Price Update to ExistingPO/Releases" check box.


14 of 21 3/31/2014 5:34 PM

Note: Retroactive price update only applies to the consumption advice. Consumption transactions, for which consumption adviceshave not been created, will not be affected by retroactive price updates. Also note that "Agreed Amount" limit defined in BlanketPurchase Agreement is not imposed when the price of the consumption advice is updated retroactively.

15.3: Can price breaks be used for Consigned Stock?

Yes, price breaks are used for giving discounts based on the quantity.

15.4: Does retroactive pricing update Standard POs used for receiving consigned stock?

The standard POs for receiving consigned stock have no refernce to the blanket. So, retroactive pricing does NOT have any impact onthese standard POs.

15.5: Finding Price / Value of Consigned Stock?

Open purchase order summary form and query for PO by checking the View releases check box and see that the shipment shows price.

16: What is Misc issue / Misc Receipt of Consigned Stock?

Misc receipt of Consigned Stock:

When consigned stock is received thru' a Misc receipt (by specifying the owning party), the supplier is still the owner of the stock. Noaccounting entries are hit.

Misc issue of Consigned Stock:

On performing a 'Misc issue' of consigned stock, an implicit consumption (ownership transfer) of consigned stock is triggered. So, thematerial is transferred from the supplier to the Inventory organization first and then, the misc issue transaction is triggered. Accountingentries will be hit. So, the behaviour you see is the expected behaviour.

Any transaction other than a 'Consigned Transaction' (explicit consumption) - for instance WIP issue, SO issue, InterOrg transfer (ofconsigned stock)- will result in implicit consumption.

Note: Misc receipt of consigned stock is from a supplier and material is received into an inventory organization. Misc issue ofconsigned stock is from the inventory organization and material is issued out of the inventory organization. Misc issue of Consignedstock DOES NOT return material back to the supplier; ownership transfer transactions are triggered when a misc. issue of consignedstock is performed.

Relating Issue and Transfer

You can see the transfer to regular that occurred due to a miscellaneous issue by comparing the transaction_batch_id. If material wastransferred to regular from consignment for the miscellaneous issue, then the batch will be the same for the three transactions (1)transfer from consigned, 2) transfer to regular, 3) miscellaneous issue). Here is an example SQL to review the values of a specific item:

select TRANSACTION_BATCH_ID, TRANSACTION_SET_ID, tr ansaction_type_id, owning_organization_id,transaction_quantity, c.*from mtl_material_transactions cwhere inventory_item_id = &EnterItemIDand creation_date > sysdate - 1;

17: What is Consumption Rules Setup used for?

By default, transfer transactions within an INV org, suchs as subinventory transfers, do NOT create ownership transfer transactions.However, if we want to force consumption, we can set it as a rule in the Consumption Rules setup form.


15 of 21 3/31/2014 5:34 PM

18: How does FIFO rules apply for consigned stock?

FIFO rules apply to consigned stock in the same way they apply to regular stock. Please note that when consigned and regular stock ofitems are co-mingled in the same subinventory, FIFO rules decide which stock will be issued first.

19: Sometimes, consumption transactions refer to a different source blanket. Why does this happen?

Check the profile option PO: Automatic Document Sourcing. If set to Yes, the latest blanket available for the item/supplier/sitecombination is always used irrrespective of the blanket specified in the ASL

20: How do we back-out erroneous misc. receipt of c onsigned stock?

Consigned/VMI receipt transaction is the same as Misc. Receipt transaction for recieving consigned stock (by specifying the owningparty).

Receiving consigned stock through Misc receipt is NOT a normal scenario (though it is supported). We do NOT support return ofconsigned stock (to the supplier) received through Misc receipt.

The recommended approach this case (data entry mistakes while receiving consigned stock through misc. receipts (cons/VMI receipt inmobile)) is to consume the stock, finally close the created consumption advice (so that it is not invoiced) and manually make theaccounting entry reversals. We agree that it is a cumbersome procedure, but nonetheless, the safest way to back-out the consignedstock.Also, it is strongly recommended that the customer receive consigned stock through PO receipts so that corrections can be adjustedthrough RTV transactions. PO receipt is the standard way of receiving consigned stock.

If the customer performs a Cons/VMI issue (same as misc. issue), the stock will NOT be backed out; instead the stock will be consumed(i.e ownership transfer transactions are triggered) and so, the stock liability is transferred to the INV. org.

21: Is Cycle counting supported for Consigned Inven tory?

NO, unfortunately there is no straightforward support for making cycle counting or physical counting of consigned inventory. When youdo misc. issue we donot know whether it is due to wrong misc. receipt entry or a true issue of stock, we always consume the consignedstock. The only way is to use workaround in such cases of data entry mistakes. Manually make accounting adjustments to reverse theentries created at Misc. issue and also finally close the consumption advice that is create due to this so as not to invoice the same.

** We logged ER / Bug 7672084 - Cycle Counting For Consigned Stock

22: Consumption advice shipments are split date-wis e for local blankets?

Please check the profile option: INV: Summarize consumption releases by Need By DateIf this profile option is set to 'Yes', a shipment line will be created for an item based on the consumption date (which is what ishappening for the customer). If set to 'No' (or NULL), all the consumption transactions for a particular item will be grouped into a singleshipment. 'The default value for this profile is 'No' or NULL.

Note: The above profile option is applicable ONLY for local blankets. For global blankets, irrespective of the value of this profile, asingle shipment will be created for each day for an item.

23: Why is no PPV generated when I perform subinven tory transfer from an expense subinventory to an as set subinventory?

While doing the subinventory transfer from expense subinventory to asset subinventory, an implicit consumption (if consumption ruleshave been setup for this subinventory transfer) is triggered first in the expense subinventory before it is transferred to the assetsubinventory, since this ownership transfer transaction takes place in expense subinventory, it is expensed at PO price and hence therewould not be any PPV. This is the expected behaviour.

24: Performance

See the consumption advise consolidated Patch 5659866.

25. Handling unwanted releases?


16 of 21 3/31/2014 5:34 PM

You can handle unwanted releases or duplicate releases without a datafix. Set the releases to "Finally Close" within the purchasingforms:1. Navigate to Purchasing > Po summary form2. Query the Releases / Consumption Advices from Po summary form3. Go to Tools->Control4. Select "Finally Close".Note that we also have scripts to cancel the duplicates. Log an Service Request to get help from Oracle Support if you cannotaccomplish this via the form. They will likely first have you run invgcacl.pls followed by invgposf.sql

26. Is the "Transfer to Consigned" Transaction type supported when performing transactions using MSCA?

No, the "Transfer to Consigned" transaction type is not supported. Mobile has "Transfer to Regular" but not "Transfer to Consigned".Mobile also allows for receiving and issue consigned material. "Return to Vendor" is another type of transaction NOT available onmobile.

You might be looking for it in mobile by using say the WMS responsibility,Navigation: Warehouse-->Inventory--->Transfer-->See "Transfer to Regular" but not "Transfer to Consigned".

You may want to also perform "Transfer to Consigned" transactions but it is not available... The "Transfer to Consigned" transactiontype is not supported via Mobile Web apps (MWA/MSCA). There are other transaction types that are not supported in MWA as well.Development states the business logic/reason is that transaction types that involve a physical move are supported. Also, supportedtransactions are those that can be performed by a lower level clerical person. Transactions that are not physical moves or may involvea higher level clerical person with increased responsibility would not be included. This is the case with Transfer to Regular which is doesnot involve a physical move and may have a higher financial impact.

27: Consumption Flow/Diagrams

27.0 New Column PO_LINE_ID

The MTL_CONSUMPTION_TRANSACTIONS table received a new column po_line_id to better track the line used to create theconsumption. Earlier, the consumption program would pick the first line that it found. The fix came for R12.1 and R12.0:

Release Patch Filename File Version

* R11i * Patch 12568433 (or INV RUP14 and higher)

invcons.odf 115.13.115100.6

R12.0.x Patch 11900144:R12.INV.A invcons.odf 120.4.12000000.3

R12.1.x Patch 11900144:R12.INV.B invcons.odf 120.5.12010000.3

* Note: The R11i fix was Bug 7534112 but a one-off was not specifically released for the issue. Another small one-offf exists withthe same files: Patch 12568433 so that is the patch suggested here. The R11i fix was included in INV RUP14 (Patch 8403245 and


17 of 21 3/31/2014 5:34 PM

higher). See Note 726226.1 for the latest R11i RUP fix.

27.1: What is the general consignment flow and flag s?

This illustration attempts to show the flow of consigned inventory. Inventory flows from the supplier into the warehouse, however, theinventory is still owned by the supplier. After the inventory is consumed, the inventory is now owned by 'your warehouse'. If theinventory is consumed automatically, this is considered 'implicit consumption'. If the inventory is consumed via a transfer to regulartransaction, it is an 'explicit consumption'.

Here is another view of the flow:


18 of 21 3/31/2014 5:34 PM

This illustration attempts to show the flags used for consignment in the onhand quantity table -- The OWNING_TP_TYPE andOWNING_ORGANIZATION_ID columns flag consignment onhand quantity in MTL_ONHAND_QUANTITITES_DETAIL. This also notes thatVMI uses PLANNING_ORG_TYPE and PLANNING_ORGANIZATION_ID :

The following diagram attempts to show the flow of data through the tables. Information is received into onhand quanties owned bythe supplier then decremented with a transfer to regular so it is owned by the warehouse. The consumption advise is run to createnotifications to the supplier for inventory used.


19 of 21 3/31/2014 5:34 PM

There is also a nice diagram in Note 1093731.1.

27.2: Table MTL_ONHAND_QUANTITIES_DETAIL vs. view M TL_ONHAND_QUANTITIES?

Why do the records in MTL_ONHAND_QUANTITIES_DETAIL differ when comparing it to the MTL_ONHAND_QUANTITIES view? MTL_ONHAND_QUANTITIES is a view in the database. You will notice that the where clause in this view (see below) restricts'is_consigned' = 2 which is not consigned inventory and owned by the company. This is as designed when development switchedMTL_ONHAND_QUANTITIES from a table to a view in a previous release, sometime prior to 11.5.9. mtl_onhand_quantities will nevershow any information that is consigned. This is the reason you may see a difference when comparing information between themtl_onhand_quantities view and the MTL_ONHAND_QUANTITIES_DETAIL table. At the time you move your inventory item fromconsigned inventory to regular inventory, the MTL_ONHAND_QUANTITIES_DETAIL table should then match. If you are designing anycustom code you should be aware of the is_consigned where clause on mtl_onhand_quantities. Here is the view definition:

CREATE OR REPLACE FORCE VIEW "APPS"."MTL_ONHAND_QUANTITIES"("INVENTORY_ITEM_ID", "ORGANIZATION_ID", "DATE_RECE IVED", "LAST_UPDATE_DATE", "LAST_UPDATED_BY","CREATION_DATE", "CREATED_BY", "LAST_UPDATE_LOGIN", "TRANSACTION_QUANTITY", "SUBINVENTORY_CODE","REVISION", "LOCATOR_ID", "CREATE_TRANSACTION_ID", "UPDATE_TRANSACTION_ID","LOT_NUMBER", "ORIG_DATE_RECEIVED","COST_GROUP_ID", "CONTAINERIZED_FLAG", "PROJECT_ID" , "TASK_ID") ASSELECT moqd.INVENTORY_ITEM_ID inventory_item_id ,moqd.ORGANIZATION_ID organization_id, moqd.DATE_REC EIVED date_received,moqd.LAST_UPDATE_DATE last_update_date, moqd.LAST_U PDATED_BY last_updated_by,moqd.CREATION_DATE creation_date, moqd.CREATED_BY c reated_by,moqd.LAST_UPDATE_LOGIN last_update_login,moqd.PRIMARY_TRANSACTION_QUANTITY TRANSACTION_QUANTITY ,moqd.SUBINVENTORY_CODE subinventory_code,moqd.REVISION revision, moqd.LOCATOR_ID locator_id,moqd.CREATE_TRANSACTION_ID create_transaction_id,


20 of 21 3/31/2014 5:34 PM

moqd.UPDATE_TRANSACTION_ID update_transaction_id,moqd.LOT_NUMBER lot_number, moqd.ORIG_DATE_RECEIVED orig_date_received,moqd.COST_GROUP_ID cost_group_id, moqd.CONTAINERIZE D_FLAG containerized_flag,moqd.PROJECT_ID project_id, moqd.TASK_ID task_id FR OMMTL_ONHAND_QUANTITIES_DETAIL moqd WHERE moqd.IS_CONSIGNED = 2;

REFERENCES

NOTE:1083776.1 - INV Webinar Series: Consignment Overview / IntroductionNOTE:1087599.1 - Vision Demo - How To Consume Consigned Inventory (Consumption Advise)NOTE:1093731.1 - What is Consignment Flow Of Data? Is There a Consignment Process Model / Consignment Data Model?NOTE:216050.1 - White Paper: Using Vendor Managed Inventory (VMI) in Oracle ApplicationsNOTE:258630.1 - No Lov Of Owning Party When Perform The Transfer To Consign TransactionNOTE:273958.1 - Onhand Zero for Regular Stock Consigned Transaction for Revision Control ItemNOTE:283488.1 - Asl Attribute 'Consigned From Supplier' Validated At Item Master LevelNOTE:344337.1 - Issue With Inventory Movement From Consigned SubinventoryNOTE:364738.1 - CONSIGNED TRANSACTION HAS NO LOV FOR CONSUMPT TRANSACTION - FRM-41830NOTE:293403.1 - Purchase Price Variance Report Runs Into ErrorNOTE:306397.1 - Drill Down in Material Workbench (INVMATWB.fmb) Displays the Wrong Quantity For Consigned InventoryNOTE:365454.1 - Cannot Transfer To Consigned InventoryNOTE:367843.1 - Open Purchasing Document Exists With Consigned Or Vmi Shipments And You Cannot MergeNOTE:376051.1 - Unable to Send Manual Consumption Advise for Release POXPRPOP Does Not Print The ReleaseNOTE:391582.1 - Obtain Information On Consignment OrdersNOTE:394123.1 - Transactions in MTL_CONSUMPTION_TRANSACTIONS with INV_SUP_CONS_NO_BPO_EXISTSNOTE:308875.1 - 11i - Create Consumption Advice For Consignment Not WorkingNOTE:312724.1 - How to Print the Consumption Advise Report?NOTE:333027.1 - 11i INVRCADB Invoices Not Being Created For Consignment InventoryNOTE:342366.1 - Transfer Consigned to Regular Errors: There Must Be A Valid Blanket Blanket Purchase AgreementBUG:7672084 - CYCLE COUNTING FOR CONSIGNED STOCKNOTE:404597.1 - Setup Vendor Consigned Inventory With Process Manufacturing (OPM)? No...NOTE:404609.1 - Create Consumption Advice Program not Creating Releases for PaymentNOTE:405518.1 - What Are The Steps Required To See Vendor Managed Items In iSupplier Portal?NOTE:405573.1 - For A Lot Controlled Consigned Item No Material Lot Number Records Are Created For Implicit ConsumptionNOTE:406390.1 - FAQ: Using Consigned Inventory / Consumption Advise / Vendor Managed Inventory (VMI)NOTE:401787.1 - Performance Issue With Create Consumption AdviceNOTE:406392.1 - Receive Error: Transaction Failed: This Supplier Site/Item Combination Must Have Approved SupplierNOTE:428100.1 - What Are The Steps Required To Setup And Transact Consigned Orders in Purchasing ?NOTE:438935.1 - Datafix To Stamp the TRANSACTION_SOURCE_ID on Consigned Inventory Transactions When It Is NullNOTE:566984.1 - Create Consumption Program (INVRCADB) Is Creating Invalid ReleasesNOTE:601692.1 - Create Consumption Advice for Global ASL Does Not Generate A Blanket ReleaseNOTE:452970.1 - Find NULL TRANSACTION_SOURCE_ID (Or Other Inventory Columns)NOTE:726226.1 - INV/WMS/RCV Family Patch Release History / Patchsets / RUPsNOTE:552072.1 - ORA-01476 In Purchase Price Variance Report (POXRCPPV)NOTE:559326.1 - Create Consumption Advice Request Error APP-FND-01030BUG:6842739 - RESUBMIT STUCK/ERROR MTL_CONSUMPTION_TRANSACTION VIA FORM, NOT SQLBUG:6845969 - ALLOW TRANSACTIONS TO ISSUE OUT NON-CONSIGNED MATERIAL ONLY OR FIRSTBUG:6845983 - SUBINVENTORY TRANSFER SPECIFYING OWNING PARTY FOR CONSIGNED TRANSACTIONSBUG:6845989 - ALLOW FLAG CONSUMPTION TRANSACTIONS TO CANCEL WITH REASONBUG:7241511 - DO NOT SEE REQUEST/LOG FROM CONSUMPTION WORKER (INVCTXCW)BUG:7249870 - CREATE CONSUMPTION ADVICE FOR CONSIGNMENT NOT WORKINGBUG:7534112 - CONSUMPTION ADVICE BLANKET RELEASE LINE NUMBER REFERENCE IS INCORRECTBUG:12971726 - ER: ALLOW CREATE CONSUMPTION ADVICE IF CONSUMED BEFORE PO CANCELLEDBUG:3877988 - PRINT CONSUMPTION ADVICES REPORT FOR CONSIGNED ITEMS NOT AVAILABLEBUG:4128396 - CANNOT TRANSFER ITEM IF THERE SUPPLIER CONSIGNED ITEM AT THE SAME SUBINVENTORYBUG:4246717 - TRANSFER TO REGULAR NOT DECREMENTED CORRECTLYBUG:5156251 - WHEN CREATING TXR TO CONSIGNED TXN, NO LOV FOR CONSUMPTION TXN FRM-41830BUG:5555142 - INTER-ORGANIZATION TRANSFER TRANSACTION TRIGGERING CONSUMPTIONBUG:6510841 - SEEDED CONSIGNMENT WORKFLOW FOR SHIPPING INVENTORY FROM SUPPLIERBUG:6795450 - CONSIGNMENT ERROR INV_SUP_CONS_NO_BPO_EXISTS BUT PO WAS ACTIVE AT CONSUMPTIONBUG:9201771 - CONSIGNED ITEMS, MTL_TRANSACTIONS_INTERFACE AND OWNING_ORGANIZATION_ID.


21 of 21 3/31/2014 5:34 PM