EGL9.2: Year End Close Process(GL_YC) Abends With "Cannot Update ("xxxxx"."PS_JP_JHDR_TAOn"."FISCAL_YEAR") to NULL Error" If Calendar Is Not Defined For Next Year (Doc ID 2276972.1)

Last updated on OCTOBER 22, 2019

Applies to:

Symptoms

When journal post process running, either triggered directly or triggered while running the closing GL_YC process getting below error:


ORA-01407: cannot update ("SYSADM"."PS_JP_JHDR_TAO4"."FISCAL_YEAR") to NULL
Failed SQL stmt: UPDATE PS_JP_JHDR_TAO4 SET FISCAL_YEAR = ( SELECT A.FISCAL_YEAR FROM PS_CAL_DETP_TBL A WHERE A.CALENDAR_ID = '01' AND A.SETID = 'SHARE' AND PS_JP_JHDR_TAO4.ADB_DATE BETWEEN A.BEGIN_DT AND A.END_DT), ACCOUNTING_PERIOD = ( SELECT A.ACCOUNTING_PERIOD FROM PS_CAL_DETP_TBL A WHERE A.CALENDAR_ID = '01' AND A.SETID = 'SHARE' AND PS_JP_JHDR_TAO4.ADB_DATE BETWEEN A.BEGIN_DT AND A.END_DT) WHERE BUSINESS_UNIT = 'SFGOV' AND ADJUSTING_ENTRY <> 'Y' AND PROCESS_INSTANCE = 51726


The issue can be reproduced at will with the following steps:

[A] Either:

- trigger the journal post GL_JP process from the batch run control page

- or, trigger the journal post GL_JP process from the online journal lines page

OR

[B] run the GL_YC Closing process which triggers the journal post GL_JP process

1. Set up Closing Rule
2. Set up Closing Group, using above closing rule
3. Run the Close process using above closing group

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.