GP THA: The SSO 6-10 Report Goes To No Success. (Doc ID 2221257.1)

Last updated on JANUARY 09, 2017

Applies to:

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

Symptoms

On : 9.2 version, Reporting

When attempting to run the SSO 6-10 Report goes to no success with the following error occurs.

ERROR
-----------------------
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)


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


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