My Oracle Support Banner

GP CHE - GPCHTX06 Performance (Doc ID 2006385.1)

Last updated on MARCH 09, 2020

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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.