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 AUGUST 17, 2016

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.

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

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