Program SAEXPGL Does Not Use Currency Conversion Rate to Populate Data into GL Staging Table (Doc ID 2067521.1)

Last updated on MARCH 14, 2017

Applies to:

Oracle Retail Sales Audit - Version 14.0 to 14.0.3 [Release 14.0]
Information in this document applies to any platform.

Symptoms

Program SAEXPGL does not use currency conversion rate to populate data into the General Ledger (GL) staging table.

Retail Sales Audit (ReSA) program SAEXPGL does not use the currency exchange rate to populate data in STG_FIF_GL_DATA staging table for the ReSA totals created for a store which has local currency different from primary currency.  (In the test case, the store local currency is CAD and the primary currency is USD).  Both currency codes in the mentioned staging table are local currency codes (CAD), and both amounts are equal to local currency amounts.


Steps to Reproduce:

  1.  Import sales transactions into a ReSA store which has local currency different from primary currency.
  2.  Close the store.
  3.  Run SAEXPGL batch.
  4.  Check data in STG_FIF_GL_DATA table.
  5.  Notice that values on prim_currency_code, prim_entered_dr_amount, and prim_entered_cr_amount are not converted to primary currency.

 

Changes

 

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