FIFGLDN2_JOB Failed with get_gl_mapping~fif_gl_cross_ref~1403~ORA-01403: no data found~ No ccid exist for dept %s class -1 subclass -1 location %s tran_code %s cost_retail_flag R for gl upload (Doc ID 2813701.1)

Last updated on FEBRUARY 14, 2023

Applies to:

Symptoms

FIFGLDN2_JOB failed with below error in the POM log:

...
2021-10-07T21:24:42,602 [Thread-3679] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/rms/oracle/proc/bin/rmswrap_multi.ksh: fifgldn2_1~20211007212245~get_gl_clr_account_mapping~fif_gl_setup~1403~ORA-01403: no data found~Clearing account not found for set of book id %s.
2021-10-07T21:24:42,602 [Thread-3679] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/rms/oracle/proc/bin/rmswrap_multi.ksh: fifgldn2_1~20211007212247~get_gl_mapping~fif_gl_cross_ref~1403~ORA-01403: no data found~ No ccid exist for dept %s class -1 subclass -1 location %s tran_code %s cost_retail_flag %s for gl upload
...
2021-10-07T21:24:42,807 [Thread-3679] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/rms/oracle/proc/bin/rmswrap_multi.ksh: fifgldn2_6~20211007212437~get_gl_clr_account_mapping~fif_gl_setup~1403~ORA-01403: no data found~Clearing account not found for set of book id %s.
2021-10-07T21:24:42,807 [Thread-3679] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/rms/oracle/proc/bin/rmswrap_multi.ksh: fifgldn2_6~20211007212440~process~tran_data_errors~0~ORA-0000: normal, successful completion~ERROR: There are unposted GL records at end-of-month run.
2021-10-07T21:24:42,807 [Thread-3679] DEBUG BatchShellCommandRunnerBatchlet - ***********************************************************************************************
2021-10-07T21:24:42,807 [Thread-3679] DEBUG BatchShellCommandRunnerBatchlet - ******* END SYSOUT FOR PROGRAM: /u01/retail/rms/oracle/proc/bin/rmswrap_multi.ksh
2021-10-07T21:24:42,807 [Thread-3679] DEBUG BatchShellCommandRunnerBatchlet - ***********************************************************************************************
2021-10-07T21:24:43,073 [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO ExecEngineUtils - updateJobStatus: response: oracle.retail.apps.poam.ext.jobadmin.model.ReSTResponse@6951a39c[statusCode=200,reasonPhrase=OK,payload={"scheduleName":"MERCH","processName":"FIFGLDN2_PROCESS","jobName":"FIFGLDN2_JOB","jobStatus":"ERROR","jobExecutionId":"226215"}]
2021-10-07T21:24:43,074 [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR AbstractPOMBatchlet - An exception occurred Forked process failed, returned exit code(255).
java.lang.RuntimeException: Forked process failed, returned exit code(255).
...

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.