Create Consumption Advice Worker is not populating Column MTL_CONSUMPTION_TRANSACTIONS.PO_DISTRIBUTION_ID Properly
Last updated on AUGUST 21, 2016
Applies to:Oracle Inventory Management - Version 22.214.171.124 and later
Information in this document applies to any platform.
Executable:INVCTXCW - Create Consumption Advice Worker
When running Create Consumption Advice, the PO_DISTRIBUTION_ID field in table MTL_CONSUMPTION_TRANSACTIONS is not being populated properly.
If the MTL_CONSUMPTION_TRANSACTIONS.PO_LINE_ID has no value and pending to be processed then it was being marked as processed without PO releases being created.
Some user may see errors like the following in the log file:
INV_CONSUMPTION_ADVICE_PROC: Error Code : 3
INV_CONSUMPTION_ADVICE_PROC: << Create Documents
INV_CONSUMPTION_ADVICE_PROC: >> Update Consumption
INV_CONSUMPTION_ADVICE_PROC: consumption_po_header_id :
INV_CONSUMPTION_ADVICE_PROC: consumption_release_id :
INV_CONSUMPTION_ADVICE_PROC: consumption_processed_flag : E
INV_CONSUMPTION_ADVICE_PROC: error_code : INV_SUP_CONS_AUTO_CREATE_FAIL
Stamping correct PO_DISTRIBUTION_ID in each unprocessed record having NULL PO_LINE_ID in MTL_CONSUMPTION_TRANSACTIONS before processing them.
1. Run Create Consumption Advice concurrent program
2. Run Pay on Receipt Autoinvoice
3. Check BPA Releases and Invoices have been created for the same quantities that have been consumed.
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