How Syntra automates extraction from PeopleSoft — an Application Engine program with PeopleCode enhancements, run-control safety checks, dynamic parameters, and Full / Change (delta) modes — producing HDL-compliant files for Oracle Fusion.
At the heart of the pipeline is a PeopleSoft Application Engine (AE) program, extended with PeopleCode, that orchestrates the whole extraction — from safety checks to file generation — writing to an intermediate staging table (PS_AZ_FILE_OC_STG) before producing HDL-compliant output.
Before a run starts, a SQL check against PSPRCSRQST prevents parallel runs that could corrupt the extract — protecting data integrity.
Country/region, file mode (Full or Change), file extension and last-run timestamp are resolved at runtime for flexible execution.
Full extracts for a baseline; Change/delta extracts use the LAST_RUN_DTM timestamp to pick up only what changed since the previous run.
Current, in-effect employee records are selected correctly using effective-dated logic.
Record counts are validated before file creation, so an extract can’t silently ship short.
Output files are named dynamically by region/mode, keeping multi-region, multi-cycle runs organised.
Core HR, Absence and Payroll data held in PeopleSoft.
Resolves parameters, runs safety checks, extracts from core tables and manages staging.
An intermediate repository for initial cleansing and standardization before file generation.
CSV/TXT files that adhere to Oracle Fusion Cloud specifications, ready for transformation and load.
Through a PeopleSoft Application Engine program (extended with PeopleCode) that resolves parameters, runs safety checks, extracts from core tables into a staging table, and generates HDL-compliant output files.
A Change-mode run uses the last-run timestamp (LAST_RUN_DTM) to extract only records changed since the previous run, so re-extracts are fast and incremental.
A run-control safety check queries the PeopleSoft process request table (PSPRCSRQST) for active runs and blocks a new run if one is already in progress.
Tell us your PeopleSoft footprint and target Fusion modules — Core HR, Absence, Payroll — and we’ll scope an automated, HDL-based migration on the Syntra ETL platform.