If you are running two or more different PeopleSoft applications, you have probably heard of the SYNC and FULLSYNC integrations. These are Integration Broker Service Operations that Oracle delivers to keep different database tables in sync between PeopleSoft instances. It is important to understand the difference and the nuances between the two. Often you need a combination of both.
SYNC operations provide near real-time synchronization of data. When an update is made in the publishing system, the subscribing system knows about it within seconds.
Examples of delivered SYNC operations:
SavePostChange event of the component.AUDIT_ACTN field:| AUDIT_ACTN | Meaning |
|---|---|
| A | A row was added |
| C | Correction mode update (non-key values changed, effective date NOT changed) |
| N | A key value changed (typically the effective date was changed) |
| K | “Sister” row accompanying an N row, containing the old key values |
| D | A row was deleted |
| blank | Nothing has changed |
OnNotify handler to process incoming messages.The hard error on D and K values is intentional. It forces a human to evaluate the change because automatic processing could cause data corruption.
If the code had automatically changed the effective date, all employees hired between January 1 and June 30 would have an invalid department – that is data corruption. The hard error forces manual review.
FULLSYNC operations push the full table from the publishing system to a subscribing system. If your department table has 1,000 rows, all 1,000 are sent. This typically runs nightly, weekly, or monthly.
Enterprise Components > Integration Definitions > Full Data Publish RulesEOP_PUBLISHT) publishes all FULLSYNCs
Enterprise Components > Integration Definitions > Initiate Process > Full Data PublishFor information on controlling which data goes to which subscriber, see FULLSYNC Chunking Rules.
OnNotify subscription handlers with straight SQL insertsBe careful when the subscribing system has data from multiple sources. For example, if your HCM system has department values from both PeopleSoft Financials and JD Edwards, a DEPT_FULLSYNC from PeopleSoft Financials could potentially truncate and delete the JD Edwards departments.
Chris Malek is a PeopleTools® Technical Consultant with over two decades of experience working on PeopleSoft enterprise software projects. He is available for consulting engagements.
Work with ChrisSWS turns SQL into production REST APIs — ready for AI, modern apps, and partner integrations. One install, unlimited potential.
A powerful PeopleSoft bolt-on that makes REST web services easy. You bring the SQL, SWS handles the rest.
Traditional PeopleSoft web services cost $3,600–$13,000 each to develop. SWS deploys production REST APIs in under 5 minutes through configuration alone.
Turn PeopleSoft data into clean REST APIs for AI integrations, modern applications, and vendor data feeds. Configuration-driven — no PeopleCode required.