Create Consumption Advice Worker is not populating Column MTL_CONSUMPTION_TRANSACTIONS.PO_DISTRIBUTION_ID Properly (Doc ID 1177833.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Inventory Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
Executable:INVCTXCW - Create Consumption Advice Worker


Symptoms

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

EXPECTED BEHAVIOR
-----------------------
Stamping correct PO_DISTRIBUTION_ID in each unprocessed record having NULL PO_LINE_ID in MTL_CONSUMPTION_TRANSACTIONS before processing them.

STEPS
-----------------------
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.

Cause

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