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 JUNE 28, 2024
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 |