My Oracle Support Banner

EGPJP: Cannot Extract Data While Running GPJP_YEALOAD (Doc ID 2692368.1)

Last updated on JULY 20, 2020

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

Cannot Extract Data While Running GPJP_YEALOAD.

When checking INSERT sentences in the log file and this issue occurs due to criteria (WHERE) is incorrect as below:

(1) Data cannot extract due to the criteria of TERMINATION_DT is like "TERMINATION_DT Is Null AND TERMINATION_DT> PYMT_DT".(Step02,Step03,Step03A)
(2) 'LEGL' in PS_ADDRESS cannot extract when TERMINATION_DT is Null. (Step03,Step03A)
(3) Data in PS_ADDRESS cannot extract when TERMINATION_DT is Null. (Step03,Step03A)


This issue can be replicated by below step:

1. Run GPJP_YEALOAD

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.