Complex Deals for Partners Generate Wrong Revenue and Income Amounts (Doc ID 2939087.1)

Last updated on APRIL 06, 2023

Applies to:

Symptoms

Actual Behavior
---------------

The BBR or BB Complex Deals for Partners with the Supplier parent of the supplier Site associated with the Partner has more than one site, the transactions consider all suppliers sites associated with the Supplier parent from the TRAN_DATA_HISTORY table for Deals calculation.

This is causing wrong revenue and income amounts.

Expected Behavior
-----------------------
The process should consider the Purchase Order (PO)/Receiving transactions from TRAN_DATA_HISTORY associated with the Supplier Site of the Partner.

Steps to Reproduce
-----------------------
Assumptions:
1. One supplier Parent (SUP-A) with two sites in RMS (SUP-A1 and SUP-A2).
2. Item associated with both Supplier sites. (Item-A)
3. One Partner (PRTN-A) associated to site SUP-A1 in ITEM_SUPP_COUNTRY table (ITEM_SUPP_COUNTRY.SUPP_HIER_LVL_1 = PRTN-A for all supplier = SUP-A1)

Steps:
1. Create a Bill-Back rebate deal based on the value of receptions for a partner (PRTN-A) with the invoice to be generated to a supplier parent (SUP-A), Billing PERIOD Monthly.
2. Move the VDATE to the next day.
3. Check DEAL_ITEM_LOC_EXPLODE and note records associated with the site SUP-A1.
4. Creates POs for both sides: SUP-A1 and SUP-A2, and receive them.
Quantity received for SUP-A1 = 100
Quantity received for SUP-A2 = 500
5. Run batch process to calculate deals amount (SALSTAGE, PREPOST DEALACT_SALES PRE, DEALACT, etc.)
6. The amount of item Item-A in DEAL_ACTUALS_ITEM_LOC for the next reporting date is wrong.
7. The transactions from the TRAN_DATA_HISTORY table consider for the calculations are from the PO from both supplier sites (turnover units = 600, instead of just 100 of the PO from SUP-A1).

Cause

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