My Oracle Support Banner

FIFGLDN1.PC Batch Fails With "ORA-01403: No Data Found" Error When the General Ledger (GL) Account Mapping Is Missing (Doc ID 1570504.1)

Last updated on MAY 16, 2022

Applies to:

Oracle Retail Merchandising System - Version 13.2.5 and later
Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 to 19.3 [Release 19.3]
Information in this document applies to any platform.

Symptoms

The "Financial General Ledger Download 1" (fifgldn1.pc) batch fails when the General Ledger (GL) account mapping is missing for at least one DEPT, CLASS, SUBCLASS, LOCATION, and TRAN_CODE combination.


Steps to Reproduce:

1. Update a row in the IF_TRAN_DATA table, so there is no GL account mapping for at least one DEPT, CLASS, SUBCLASS, LOCATION, and TRAN_CODE combination.
2. Run batch program fifgldn1.pc.
3. Notice: The program aborts with the error shown above.


Cause

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
Symptoms
Cause
Solution
References


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