PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Implement incremental logic for Peoplesoft Tables

We have a critical requirement to send incremental data to our data lake on a daily basis. However, some of our PeopleSoft tables lack an exclusive last update date-time field. Our downstream team insists on having access to the actual transaction data rather than just views, as they plan to use it for future use cases.

Source - Peoplesoft Database
Target - Data Lake
Integration Tool - IICS

Below is the list of tables for which we need insights on implementing incremental logic:

PS_JRNL_HEADER
PS_JRNL_LN
PS_VOUCHER
PS_PYMNT_VCHR_XREF
PS_PAYMENT_TBL
PS_VCHR_ACCTG_LINE

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center