My Oracle Support Banner

Affordable Care Act (ACA) - ACA Data Extract Performance Recommendations (Doc ID 2116563.1)

Last updated on SEPTEMBER 03, 2020

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.1 to 9.2 [Release 9]
PeopleSoft Enterprise HCM Benefits Administration - Version 9.1 to 9.2 [Release 9.0 to 9]
Information in this document applies to any platform.

Details

 

 

 

This document is intended for PeopleSoft customers who seek advise on how to improve performance of the ACA Data Extract Application Engine process ACA_EXTRACT.

Actions

1. Create additional Index on BAS_PARTIC_OPTN record:

DROP INDEX PSZBAS_PARTIC_OPTN; /* If required */

CREATE INDEX PSZBAS_PARTIC_OPTN ON PS_BAS_PARTIC_OPTN (
EMPLID,
BENEFIT_RCD_NBR,
COVRG_CD,
OPTION_TYPE,
EVENT_ID,
PLAN_TYPE,
OPTION_CD);

UPDATE STATISTICS PS_BAS_PARTIC_OPTN WITH SAMPLE 100 PERCENT;

2. Apply all current patches:

Quick Link to patches –  <Document 1919696.1>

3. Breakdown employees to small batches to process through the system:

1) Navigate to Benefits=> ACA Annual Processing=> Create ACA Form Data=> ACA Data Extract
2) Select “Extract ACA Employee Data”
3) Enter Participants “Empl ID” in smaller batches to breakdown the process
4) When all participants have been processed Select “Extract ALE Employer Data” and run.

4. Archive BAS_PARTIC records.

Other customers have had major success by Archive and leaving two years worth of data for the following tables if you are a Benefits Administration customer

PeopleBooks on PeopleTools PeopleSoft Data Archive Manager

PeopleTools > Data Archive Manager > Manage Archive Objects

NAME TYPE DESCRIPTION
BAS_PARTIC TABLE BAS Participant
BAS_PARTIC_PLAN TABLE BAS Participant Plan
BAS_PARTIC_OPTN TABLE BAS Participant Option
BAS_PARTIC_COST TABLE BAS Participant Cost
BAS_PARTIC_ELIG TABLE BAS Participant Eligibility
BAS_PARTIC_DPND TABLE BAS Participant Dependent
BAS_PARTIC_INVT TABLE BAS Participant Investment

 5. Recommended Init.ora Parameters for Oracle database:

    _gby_hash_aggregation_enabled = false
    _unnest_subquery =false

    For more information please see Required Interim Patches for the Oracle Database with PeopleSoft <Document 1100831.1>,

 

 

Contacts

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
Details
Actions
Contacts
References


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