PRIM_ENTERED_CR_AMOUNT Values Populated Incorrectly in STG_FIF_GL_DATA Table (Doc ID 2085281.1)

Last updated on MAY 01, 2017

Applies to:

Oracle Retail Merchandising System - Version 13.2.4 and later
Information in this document applies to any platform.

Symptoms

In Oracle Retail Merchandising System (RMS) 13.2.x, values for 'prim_entered_cr_amount' are being populated incorrectly in the STG_FIF_GL_DATA table.  This is causing discrepancies between General Ledger (GL) and RMS.


Steps to Reproduce:

  1. Create a fixed deal for a department and add around 2000 stores in the deal.
  2. Ensure that deal currency, supplier currency, store currency are the same.
  3. Run dealfinc batch.  (GL cross ref information should be available for the stores in the deal, else the batch will fail)

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