FIFGLDN1 and FIFGLDN3 Batches does Not Use Currency Conversion Rate to Populate Data into General Ledger Staging Table (Doc ID 2010310.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

The issue described in this document is known to Oracle, and a fix already scheduled for future release.
This article will be updated as official patch information becomes available.

 FIFGLDN1 and FIFGLDN3 batches does not use currency conversion rate to populate data into general ledger staging table.

Instructions to Re-create:

1.    Ensure that there are many rows in IF_TRAN_DATA for locations whose currency is different than the primary currency.
2.    Run fifgldn1,2,3 batch.
3.    Notice that the columns PRIM_CURRENCY_CODE, PRIM_ENTERED_DR_AMOUNT and PRIM_ENTERED_CR_AMOUNT are populated with location currency values.

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