FIFGLDN1.PC Batch Fails With "ORA-01403: No Data Found" Error When the General Ledger (GL) Account Mapping Is Missing
Last updated on AUGUST 17, 2016
Applies to:Oracle Retail Merchandising System - Version 13.2.5 and later
Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms