Consumption Releases Created - Negative Number And Missing Distributions MTL_CONSUMPTION_TRANSACTIONS Table Erroring With INV_SUP_CONS_AUTO_CREATE_FAIL - (Doc ID 1625464.1)

Last updated on SEPTEMBER 30, 2014

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Inventory Transactions

MTL_CONSUMPTION_TRANSACTIONS table erroring with INV_SUP_CONS_AUTO_CREATE_FAIL

After Create Consumption Advice is run
MTL_CONSUMPTION_TRANSACTIONS table erroring with INV_SUP_CONS_AUTO_CREATE_FAIL
=> consumption_release_id, po_distribution_id are NULL for these records
=> po_line_id is populated with proper value.

As a result it creates PO Blanket Releases against PO with invalid release numbers (negative release numbers such as -77012)
Also, not creating any records in PO_DISTRIBUTIONS_ALL for these Consumption transactions (where distribution_type = 'BLANKET')

Error:
INV_SUP_CONS_AUTO_CREATE_FAIL

Replication Steps:
The issue can be reproduced at will with the following steps:

After Create Consumption Advice is run
MTL_CONSUMPTION_TRANSACTIONS table erroring with INV_SUP_CONS_AUTO_CREATE_FAIL
=> consumption_release_id, po_distribution_id are NULL for these records
=> po_line_id is populated with proper value.

As a result it creates PO Blanket Releases against PO with invalid release numbers (negative release numbers such as -77012)
Also, not creating any records in PO_DISTRIBUTIONS_ALL for these Consumption transactions (where distribution_type = 'BLANKET')

Other:
17863140:R12.PO.B    Latest Recommended Patch Collection for Oracle Purchasing
 - This patch was applied
 - The issue occurs when the system is on file version - POXBWP1B.pls  120.73.12010000.65

For Rel 12.2.x apply patch  19486192:R12.PO.D to get the fixed file

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