EGPJP: Error Occurred At GPJP_YEALOAD.03UPD1.Step140 (Doc ID 1920226.1)

Last updated on AUGUST 25, 2014

Applies to:

PeopleSoft Enterprise HRMS Global Payroll Japan - Version 9 and later
Information in this document applies to any platform.

Symptoms

On: PeopleSoft Enterprise HRMS Global Payroll Japan Release 9.0, Year End

ACTUAL BEHAVIOR
---------------
When a current PS_ADDRESSES.STATE is null and the history of PS_ADDRESSES.STATE is not null, the following error occurs on the Load YEA Report Data JPN (GPJP_YEALOAD) report:

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1603 Error Position: 29 Return: 1407 - ORA-01407: cannot update ("SYSADM"."PS_GPJP_YEA_TABLE"."GPJP_YEA_FLADDR") to NULL
Failed SQL stmt:UPDATE PS_GPJP_YEA_TABLE SET GPJP_YEA_FLADDR = ( SELECT SUBSTRB (RTRIM(S.DESCR,' ') || RTRIM(A.CITY,' ') || RTRIM(A.ADDRESS1,' ') || RTRIM(A.ADDRESS2,' ') || RTRIM(A.ADDRESS3,' ') || RTRIM(A.ADDRESS4,' '), 1, 120) FROM PS_ADDRESSES A , PS_STATE_NAMES_TBL S WHERE A.EMPLID = PS_GPJP_YEA_TABLE.EMPLID AND A.ADDRESS_TYPE = 'HOME' AND S.STATE = A.STATE AND S.COUNTRY = 'JPN' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_ADDRESSES B WHERE B.COUNTRY = 'JPN' AND A.EMPLID = B.EMPLID AND A.ADDRESS_TYPE = B.ADDRESS_TYPE AND TO_CHAR(B.EFFDT,'YYYY')  
 ????? 168062 ?????? GPJP_YEALOAD.03UPD1.Step140 (SQL) ??????????RC = 1407? (108,524)

This ORA-error was caused by inserting null data to GPJP_YEA_TABLE.GPJP_YEA_FLADDR.

EXPECTED BEHAVIOR
-----------------------
Having the current of PS_ADDRESSES.STATE as null should not error out the Load YEA Report Data JPN.

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

1. Ensure current PS_ADDRESSES.STATE is null and the history of PS_ADDRESSES.STATE is not null, for this error occurs (via Workforce Administration > Personal Information > Modify a Person).
2. Calculate the Payroll (via Absence and Payroll Processing > Calculate Absence & Payroll)
3. Load YEA Report Data JPN (via Global Payroll & Absence Mgmt > Year End Processing > Load YEA Report Data JPN)

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete their Year End report.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms