My Oracle Support Banner

GPJPN: GPJP_YEALOAD Aborted Due To Inserting NULL Value After Applied Bug2580393 (Doc ID 2428754.1)

Last updated on FEBRUARY 13, 2019

Applies to:

PeopleSoft Enterprise HCM Global Payroll Japan - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Issue:
=============================
1.
After applied a fix for Bug 25803935, and then creating 2 resignees, GPJP_YEALOAD aborted due to below error #1.

2.
After applied a fix for Bug 25803935, and then creating 2 resignees, GPJP_YEALOAD aborted due to below error #2.

Error:
--------------------------------
1.
File: e:\pt85513b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #:1723  Error Position: 0  Return: 8601 -
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot insert the value NULL into column 'GPJP_IH_SPEC_CLC',
table'dbo.PS_GPJP_YEA4_TAO6'; column does not allow nulls. UPDATE fails.
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Statement ended.
(SQLSTATE 01000 Failed SQL stmt: UPDATE PS_GPJP_YEA4_TAO6 SET GPJP_IH_SPEC_CLC =
( SELECT GPJP_IH_SPEC_CLC FROM PS_GPJP_IH_MUNIC2 A WHERE A.GPJP_MUNC_IH_CD = PS_GPJP_YEA4_TAO6.MUNICIPAL_CD_JPN AND
A.GPJP_TAX_ESTAB = '00627712' AND A.EFFDT = ( SELECT MAX(B.EFFDT)
FROM PS_GPJP_IH_MUNIC2 B WHERE A.MUNICIPAL_CD_JPN = B.MUNICIPAL_CD_JPN AND A.GPJP_TAX_ESTAB = B.GPJP_TAX_ESTAB AND B.EFF_STATUS = 'A')
AND EXISTS ( SELECT MC1.MUNICIPAL_CD_JPN FROM PS_GPJP_IH_MUNIC2 MC1 WHERE MC1.MUNICIPAL_CD_JPN = A.MUNICIPAL_CD_JPN
AND MC1.GPJP_TAX_ESTAB = A.GPJP_TAX_ESTAB AND MC1.MUNICIPAL_CD_JPN = ( SELECT MUNICIPAL_CD_JPN FROM PS_POSTAL_TBL_JPN
WHERE POSTAL = ( SELECT ADR.POSTAL FROM PS_ADDRESSES ADR WHERE ADR.EMPLID = PS_GPJP_YEA4_TAO6.EMPLID AND ADR.ADDRESS_TYPE = 'HOME'
AND ADR.EFF_STATUS = 'A' AND ADR.EFFDT = ( SELECT MAX(ADR_ED.EFFDT) FROM PS_ADDRESSES ADR_ED WHERE ADR_ED.EMPLID = ADR.EMPLID
AND ADR_ED.ADDRESS_TYPE = ADR.ADDRESS_TYPE AND ADR_ED.EFFDT <= { fn CURDATE() })) ))) WHERE PROCESS_INSTANCE = 182502
AND EXISTS ( SELECT 'X' FROM PS_GPJP_IH_MUNIC2 A WHERE A.GPJP_MUNC_IH_CD = PS_GPJP_YEA4_TAO6.MUNICIPAL_CD_JPN AND A.GPJP_TAX_ESTAB = '00627712'
AND A.EFF_STATUS = 'A')

Process 182502 abended at Step GPJP_YEALOAD.03UPD1.Step02A (SQL). RC = 8601 (108,524)

2.
-- 10:46:55.288 Process 186355 ABENDED at Step GPJP_YEALOAD.02INSRTB.Step03 (Action SQL) -- RC = 805
ROLLBACK
/
-- 10:46:55.353 SQL Error: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]

Cannot insert duplicate key row in object 'dbo.PS_GPJP_YEA4_TAO6' with unique index 'PS_GPJP_YEA4_TAO6'. The duplicate key value is (186355, S01166, 0).


Step:
--------------------------------
1.
 1) Applying a fix for Bug 2580393.
 2) Run payroll for Dec 2017.
 3) Run Load YEA Report Data JPN.
 4) While running a process, error #1 occurred.

2.
 1) Applying a fix for Bug 2580393.
 2) Run payroll for Feb 2018.
 3) Run Pre-Load Inhabitant Tax JPN
 4) After running above process, Japanese Municipal Code was populated for the FY2018 inhavitant tax data  with below criteria;
   (1) Employee1: HOME = LEGL: Japanese Municipal Code which is related to a postal code of HOME was set.
   (2) Employee2: HOME =<> LEGL: Japanese Municipal Code which is related to a postal code of LEGL was set.
 5) With above states, running Load YEA Report Data JPN.
 6) While running a process, error #2 occurred.


Actual Behavior:
--------------------------------
After applied a fix for Bug 25803935, and then creating 2 resignees, GPJP_YEALOAD aborted due to errors.


Expected Behavior:
--------------------------------
GPJP_YEALOAD runs without errors.
 

Changes

 

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
Changes
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.