My Oracle Support Banner

FIFGLDN2 Failling with "ORA-01403: no data found~ No ccid exist" When All Accounts are Defined in FIF_GL_CROSS_REF Table (Doc ID 2924035.1)

Last updated on JANUARY 27, 2023

Applies to:

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

Symptoms

On : 19.3 version, Operations & Maintenance

FIFGLDN2 failing

FIFGNDN2 batch is failing due to missing accounts for some records. Accounts are defined in the system.

ERROR
-----------------------
fifgldn2_5~20230123172104~get_gl_mapping~fif_gl_cross_ref~1403~ORA-01403:
no data found~ No ccid exist for dept 16 class 161 subclass -1 location 101 tran_code 22 cost_retail_flag C fro gl upload


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create inventory adjustment
2. Run nightly batch
3. Check fifgldn2 batch log

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.