Batch Fifgldn2 Aborted With Error: No Ccid Exist

(Doc ID 1310151.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.0.2 and later
Information in this document applies to any platform.
Checked for relevance as on 7th Nov 2012.


While extracting data from transaction staging table (IF_TRAN_DATA), the program FIFGLDN2  aborts when an unmapped General Ledger(G/L) account is encountered. This will require manual intervention to correct the G/L Cross Reference data and re-run the program every time it encounters an unmapped G/L account error.

Steps To Recreate:

1. Select row in IF_TRAN_DATA so that there is no (General ledger) G/L account mapping for at least one dept, class, subclass, location, and tran code combination.

2. Run the program fifgldn2

3. Program aborts with error

"No ccid exist for dept %s class %s subclass %s location %s tran_code %s cost_retail_flag %s for gl upload".


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