What Options Are Available when Replicating Data from an Oracle Fusion Cloud Applications Data Source

When you replicate data from an Oracle Fusion Cloud Applications data source, use these options.

Some View Objects record change history (similar to slowly changing dimensions). To replicate the change history, click Include History on the replication setup dialog.

Keep replicated data synchronized with the source data using the Include Deletions option on the replication setup dialog. If you select Include Deletions and a record is deleted from the source data, it’s also deleted from the target database.

To synchronize data, you use the Include Deletions option in incremental data loads (where the Load Type option is Incremental). In full data loads, the target table rows are deleted before the replication starts.

With Custom View Objects, you can replicate data in any custom view using the Add a custom view object option on the replication setup dialog. Enter the full path and name of the view, for example, FscmTopModelAM.TaskDffBIAM.FLEX_BI_TaskDFF, then click Add to add the view to the Replicate Objects list so you can select fields.