Delta Data or Incremental in Oracle Fusion

 

About Incremental Data logic In Oracle Fusion

 What is Delta or Incremental Data in Oracle Fusion?

Delta Data (often referred to as Incremental Data) refers exclusively to the data that has changed.

meaning when it was created, updated, or deleted

since a specific point in time,

usually the last successful integration or extraction run.

 

Instead of processing the entire database data every time (a "Full Load"), integrations use delta extracts to pull only the fresh updates. This is crucial for maintaining high-performing, real-time, or daily synchronized systems.

 

How it works with practical example

Consider a bank statement, a full load is the  entire transaction history since the account was opened. A delta load is just the transactions that happened yesterday.

Feature	Full Data Load	Delta / Incremental Data
Volume	High (Processes all records)	Low (Processes only changed records)
Performance	Slower, resource-intensive	Fast, lightweight
Frequency	Typically one-time, weekly, or monthly	Frequent (Hourly, daily, or near real-time)
Primary Use	Initial system cut-over or data reconciliation	Regular, automated downstream integrations

 

SQL Query:

select to_char(sysdate ,'mm/dd/yyyy hh:mi:ss') systimestamp,

to_char(dha.creation_date ,'mm/dd/yyyy hh:mi:ss') ord_Cre_Date,

dha.creation_date crfea_date,

dha.order_number

 

FROM

    doo_headers_all dha

WHERE 1=1

               AND To_date(To_char(dha.creation_date,

'DD-MM-YYYY HH24:MI:SS'

                           )

                   ,

                       'DD-MM-YYYY HH24:MI:SS') BETWEEN

                   To_date(:p_from_date, 'DD-MM-YYYY HH24:MI:SS') AND

                   To_date(:p_to_date, 'DD-MM-YYYY HH24:MI:SS'

                   )

--and submitted_flag='Y'

ORDER BY

    dha.order_number,dha.creation_date DESC

 

 

 

 

 

Execution Part