Fifgldn1 Does Not Retrieve the Correct General Ledger (GL) Mapping for a Tran Code With Two GL Entries (Doc ID 2085590.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

If a Tran Code has two General Ledger (GL) entries under different levels of the merchandise hierarchy, the base program (fifgldn1) does not retrieve the correct GL mapping.  The debit/credit accounts from the two GL entries are retrieved in any order. Then, the first two accounts are selected regardless of what GL and what type of account.  Usually, the selected accounts are debit from the two GL entries.

The GL at the lowest level of the merchandise hierarchy should precede the GL above it.  The debit/credit accounts should only be selected from the GL with the lowest level of the merchandise hierarchy.


Steps to Reproduce:

To test a transaction that references the tran ref no field in the GL mapping:

1. Create any transaction that will generate any of these tran codes: 22, 23, 37, 38, 63, 64, 87 or 88.
     The transaction can be an inventory adjustment that will generate tran code 22 (Stock Adjustment).
     Make sure that tran code 22 has two GL entries in the mapping table (FIF_GL_CROSS_REF) under different levels of the merchandise hierarchy.
2. Run salstage batch to create the transaction data in the snapshot table (IF_TRAN_DATA).
3. Run fifgldn1 batch to create the GL transaction in the staging table (STG_FIF_GL_DATA).

To test a transaction that does not reference the tran ref no field in the GL mapping:

1. Create any transaction that will generate any tran codes other than these: 22, 23, 37, 38, 63, 64, 87 or 88.
     The transaction can be a WAC adjustment that will generate tran code 70 (Cost Variance).
     Make sure that tran code 22 has two GL entries in the mapping table (FIF_GL_CROSS_REF) under different levels of the merchandise hierarchy.
2. Run salstage batch to create the transaction data in the snapshot table (IF_TRAN_DATA).
3. Run fifgldn1 batch to create the GL transaction in the staging table (STG_FIF_GL_DATA).

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