Asset Sale Receivables does not Consolidate Based on the Sales Order and Instead Grouping Rule in AR is being Used (Doc ID 3031928.1)

Last updated on JUNE 28, 2024

Applies to:

Symptoms

Asset sale receivables should consolidate based on the sales order. When billing group is enabled at the system level, billing group name is being passed on to interface_line_attribute2 and based on billing group invoice format, contract id is being passed on to interface_line_attribute12. Grouping Rule in AR for OKL_CONTRACTS is being used for all OKL Invoices.

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

1. Using lease super user responsibility, navigate to Setup >> System options >> Operational Options and enable Billing Group.
2. Book 2 contracts (Contract1 and Contract2) with invoice format as Multi Contract consolidation in Billing Group BG1.
3. Book 2 contracts(Contract3 and Contract4) with invoice format as Single Contract Consolidation in Billing Group BG2.
4. Terminate 4 contracts without purchase.
5. Remarket assets of all 4 contracts in same Order.
6. Using lease administrator, run billing request set.
7. Instead of one invoice for sales order, multiple invoices are being created.
8. A total of 3 invoices will be created instead of 1.
9. Invoice 1 for contracts Contract1 and Contract2. Invoice 2 for contract Contract3. Invoice 3 for contract Contract4.

Cause

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