ETL9.2: The ACA Employee Threshold Report Terminates The Connection.

(Doc ID 2312222.1)

Last updated on DECEMBER 01, 2017

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to run ACA Report,
the ACA Employee Threshold runs for about 5 minutes and terminates the connection (like a timeout of sort)

REPLICATION STEPS
=================
1. Navigation is Time and Labor> Reports>Interactive Reports> ACA Employee Threshold Report
2. Run Report for 10k employee and period 1/2016 thru 12/2016
3. The ACA Employee Threshold report runs for about 5 minutes and terminates the the connection (like a timeout of sort)
4. When running for the smaller range of dates (1 month), were getting the error:
*** Generic error while executing the Query datasource. (268,91)
PT_PGPACKAGE.PT_PGInformation.OnExecute Name:ExecuteDrillDn PCPC:128267 Statement:2063
Called from:PTPG_API.Execution.OnExecute namve:ExecuteDrilldown Statement:328
Called from:PTPG_API.Model.OnExecute Name:getDetailView Statement :422
Called from:PTS_SEARCH.PivotGridSearch.OnExecute Name:GetsearchResults Statement:988

Called from:PTS_SEARCH.PivotGridSearch.OnExecute Name:populateSearchGrid Statement:134 Called from:PTS_SEARCH.Pi
5. After adding the role and reconfiguring the models w/ the following steps
a) Navigate to: Main Menu > Reporting Tools > Pivot Grid > Pivot Grid Wizard
b) Reconfigure the following:
c) Find an Existing Value.
d) Enter pivot grid name, { Just select ANY existing Pivot Grid model }
e) Click " Search" button.
f) In Step 1, Click "Next" button.
g) Hit the "Next" button without any modifications up until Step 5.
h) Click the "Saved" button.
and retesting, than on ACA_WEEKLY_RPT getting the error
*** Generic error while executing the Query datasource (268,91)
PT_PGPACKAGE.PT_PGInformaton.OnExecute Name:ExecuteChat PCPC:107027
Statement:1756
Called from:PTPG_WIZ_DISP.Activate Statement:422

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