GPJPN: GPJP_YEALOAD was Aborted After Applied GP BUNDLE 2014-A (Doc ID 2216389.1)

Last updated on DECEMBER 20, 2016

Applies to:

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

Symptoms

Issue:
-------------------------------------
After applied GLOBAL PAYROLL 9.1 UPDATE 2014-A, GPJP_YEALOAD was aborted.
The error step is GPJP_YEALOAD.03UPD5.Step95 (SQL).

Error:
-------------------------------------
File: e:\pt85115b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #:1617 Error Position: 0 Return: 8601 -
[Microsoft][SQL Server Native Client 10.0][SQL Server]value NULL cannot insert into the column 'GPJP_RES_CHRDT7_2" of table 'MTCIT.dbo.PS_GPJP_YEA_TABLE'.
The value NULL is not permitted for this column. UPDATE will be failed.

Step:
-------------------------------------
This issue can be reproduced by the below step;
1. Enter the year end adjustment data for FY2015.
2. Run Payroll for Dec 2015.
3. Run GPJP_YEALOAD for FY2015.

Actual Behavior:
-------------------------------------
After applied GLOBAL PAYROLL 9.1 UPDATE 2014-A, GPJP_YEALOAD was aborted.

Expected Behavior:
-------------------------------------
Even if applying GLOBAL PAYROLL 9.1 UPDATE 2014-A, GPJP_YEALOAD runs successfully.

Business Impacts:
-------------------------------------
Due to this issue, users cannot do the year end adjustment.

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