INVCTXNM: Create Consumption Advice Runs But Does Not Process Anything, Check Billing Cycle Days (Doc ID 2068566.1)

Last updated on JUNE 21, 2023

Applies to:

Symptoms

The Create Consumption Advice (INVCTXNM) program runs but does not process any records.

Already checked that have consumption transactions "Pending" but they are not processing.

Error

If the billing cycle has not yet passed, you might see something like the following in the "Create consumption advice worker" log file with Inventory Debug enabled:

INV_CONSUMPTION_ADVICE_PROC: Consumption Txn Worker(l_elapsed)1.

Steps
1. Navigate to Inventory > Reports > Transactions (The submit window opens)
2. Choose to submit a Single Request
3. Choose "Create Consumption Advice".
4. Run the program for your parameters.
5. Review results and nothing processes. (The Create Consumption Advice Worker (INVCTXNW) program also does not run.)

Changes

Cause

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