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

Last updated on FEBRUARY 13, 2025

Applies to:

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

 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

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