GP THA: The SSO 6-10 Report Goes To No Success.
Last updated on MAY 11, 2018
Applies to:PeopleSoft Enterprise HCM Global Payroll Thailand - Version 9.2 and later
Information in this document applies to any platform.
On : 9.2 version, Reporting
When attempting to run the SSO 6-10 Report goes to no success with the following error occurs.
Statement: update ps_gpth_sso610_tmp set GPTH_NAME_PREFIX=(SELECT MAX(GPTH_NAME_PRE_DIS) FROM PS_GPTH_PREFIX_VW WHERE NAME_PREFIX=PS_GPTH_SSO610_TMP.GPTH_NAME_PREFIX) WHERE NAME_PREFIX<>' ' AND PROCESS_INSTANCE=:1 AND EXISTS (SELECT 1 FROM PS_GPTH_PREFIX_TBL TBL WHERE TBL.NAME_PREFIX = PS_GPTH_SSO610_TMP.NAME_PREFIX)
The issue can be reproduced at will with the following steps:
1.Add a Person on : 03/05/2016 and Job Data Hire on 16/05/2016
2.Run the report for whole company got no success.
3.Found the person in the group who make report goes no success.
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