GP CHE - GPCHTX06 Performance (Doc ID 2006385.1)

Last updated on JULY 26, 2016

Applies to:

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

Symptoms

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.

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