CUPPRC_BJ_100_01 Batch Job - txn_poq_dt format (Doc ID 2698411.1)

Last updated on AUGUST 08, 2020

Applies to:

Symptoms

While executing CUPPRC_BJ_100_01 as part of account processing, customer observed Errors.

ERROR
-----------------------
Error in : cupprc_en_100_01.get_formula_value
please see attached Debug log: Line 525
07/07/2020 14:51:09: gtt_formula_tab(i).GTT_VARIABLE_VALUE1>>
07/07/2020 14:51:09: cmnsyc_cl_000_01.get_ptc_parameter_value parameter: CMN_GL_POST_DT
07/07/2020 14:51:09: Company : ****** GL Post Date :: 07/06/2020
07/07/2020 14:51:09: cupprc_en_100_01.get_acc_rec
07/07/2020 14:51:09: cmnsyp_cl_000_01.get_syp_parameter_value parameter: CMN_ALERT_DEBUG_METHOD
Context : Error in : cupprc_en_100_01.get_formula_value

alert log: Line 20051.

OFSLL Error Msg :
Ora Error Code : 1843
Ora Error Msg : ORA-01843: not a valid month
Context : Error in : cupprc_en_100_01.get_formula_value

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Execute Batch Job CUPPRC_BJ_100_01
2. Check For Any errors

BUSINESS IMPACT
-----------------------
The issue has the following business impact:

Due to this issue, users not able process the account further

Changes

Cause

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