VFP Deal Has the Income on Deals Table Converted to the Deal Currency Twice (Doc ID 1581128.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.1.4.4 to 13.1.8 [Release 13.1]
Information in this document applies to any platform.

Symptoms

For a vendor funded promotion (VFP) deal, when posting the deal income to the tables DEAL_ACTUALS_ITEM_LOC and DEAL_ACTUALS_FORECAST, the income is being converted twice between GBP and EUR.

The table DEAL_ACTUALS_ITEM_LOC should have the income in GBP (local currency) and the table DEAL_ACTUALS_FORECAST should have the income in EUR (deal currency).  What is instead happening is that on DEAL_ACTUALS_ITEM_LOC table the income is in EUR, and in the DEAL_ACTUALS_FORECAST table, the income is being converted once again.  But since the income on DEAL_ACTUALS_ITEM_LOC is already in EUR, the conversion is repeated, but over the EUR amount.  This results in an incorrect calculation.  In TRAN_DATA the income is correct.

 

Steps to Reproduce:

1. Create a VFP for one item/store combination in Retail Price Management (RPM) and create a Deal for the VFP.
2. Go to Retail Merchandising System (RMS).  Complete the creation of the deal that was interfaced from RPM with a different currency from the local one.  Submit and Approve the deal.
3. Run the nightly batch.
4. Feed sales into ORMS through Retail Sales Audit (ReSA) and upload them through POSUPLD batch.
5. Run the nightly batch.
6. Check that the income of the deal in the tables DEAL_ACTUALS_ITEM_LOC is not in the local currency.  It is instead based on the data posted in TRAN_DATA for those sales, and the data in DEAL_ACTUALS_FORECAST has the income converted twice.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms