My Oracle Support Banner

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

Last updated on FEBRUARY 27, 2019

Applies to:

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


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.



To view full details, sign in with your My Oracle Support account.

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

In this Document

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