INV_SUP_CONS_AUTO_CREATE_FAIL Create Consumption Advice Program Is Not Creating Releases Against The BPA

(Doc ID 1326588.1)

Last updated on SEPTEMBER 25, 2017

Applies to:

Oracle Inventory Management - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

Consumption records are flagged in 'error' and no releases have been created against the blanket purchase agreement (BPA).

Error may or may not be seen as well.

Consumption transactions have error

INV_SUP_CONS_AUTO_CREATE_FAIL

Create Consumption Advice Worker (INVCTXCW) may or may not end with error in the request log, like this:

INV_CONSUMPTION_ADVICE_PROC: -1002 : ORA-01002: fetch out of sequence

What is working

Sometimes works.
Happens when batch_id already exist in po_headers_interface.

Steps
1. Run Create consumption advice
2. Request completes in error.

Changes

 

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