My Oracle Support Banner

Batch FIFGLDN2.PC Fails With an Error “No ccid exist for dept %s class %s subclass %s location %s tran_code %s cost_retail_flag %s for gl upload” (Doc ID 744361.1)

Last updated on JULY 19, 2018

Applies to:

Oracle Retail Merchandising System - Version 12.0.5 to 12.0.8 [Release 12.0]
Information in this document applies to any platform.
Checked for relevance on 30-Sep-2010


Symptoms

While extracting data from transaction staging table(IF_TRAN_DATA),the program FIFGLDN2.PC aborts with the following error message,  this will require manual intervention to correct the GL Cross Reference data and re-run the program every time it encounters an unmapped G/L account error.

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

Steps To Reproduce:

1. Select row in IF_TRAN_DATA so that there is no General Ledger (GL) account mapping for atleast one dept, class, subclass, location,and trancode combination.
2. Run the program fifgldn2.pc
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”

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.