GP CHE - GPCHTX06 Performance
Last updated on MAY 02, 2018
Applies to:PeopleSoft Enterprise HCM Global Payroll Switzerland - Version 9 and later
Information in this document applies to any platform.
GPCHTX06 performance issue: The report gets stuck on temp table GPCHTX061_TMP, and never ends. It was full because of failed processes that inserted data in this table, but after a delete of dummy data, user still cannot have this report in success.
We found a workaround by replacing the $SecurityClause in GPCHTX06.sqc with a table instead of GPCH_RP_FAST_VW.
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