Consumption Advice is Stuck in Pending Status After Supplier Merge or Supplier Changes on Agreement (Doc ID 2617161.1)

Last updated on FEBRUARY 21, 2023

Applies to:

Symptoms

Create Consumption Advice is not showing any records
and Transfer to Owned transaction types are still showing
the consumption advice status as pending after supplier merge.

EXPECTED BEHAVIOR
-----------------------
Create Consumption Advice should show the records of
transactions that have been transferred to owned.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a requisition
2. Generate to a PO and approve it
3. Receive and put away the receipts.
4. Create account alias issue for receipts for transaction that are consigned. Do supplier changes on blanket agreement like a supplier merge or site change.
5. Supply Chain Execution > Inventory Management > Review Completed Transactions
6. Query the transactions that are issued out using account alias issue and see that transactions have 'Consumption Advice Status' set to 'Pending'
7. Tools > Scheduled Process > Run the Create Consumption Advice program, and review the report output.
8. See the output shows 'No Data Found'

Cause

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