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