INV_SUP_CONS_AUTO_CREATE_FAIL Create Consumption Advice Program Is Not Creating Releases Against The BPA (Doc ID 1326588.1)

Last updated on JUNE 21, 2023

Applies to:

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

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.

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Symptoms

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.