Configure Oracle Cloud Application Replication Package

The Replication screen in the Management Console allows you to create and manage replication packages that extract data from your Oracle Cloud Application (OCA) instance and migrate it to SAP Central Finance (CFIN).

Note: The configuration steps in this topic apply to Oracle Fusion implementations.

Enable Data Extraction for the Replication Screen

The Replication screen is visible once the Oracle Cloud Application template is imported, but the following configuration is required to enable data extraction.

1. Access the configured metadata store using an appropriate tool such as pgAdmin or SQL Server Management Studio.
2. Connect to the application database and open the SettingT table.
3. Locate the IsOCAEnabled property and set the value to true.
4. Save the changes.
5. Open Internet Information Services (IIS) Manager, and in the Actions panel, click Restart to apply the changes.

The Replication option is now accessible in the left navigation bar of the Management Console.

Note: You must have at least one Oracle Cloud Application data source configured before creating a replication package. For more information, see Configure an Oracle Cloud Application Data Source in the Installer and Management Console Guide.

To access the Replication screen, select Replication in the left navigation bar.

Create a Replication Package

1. On the Replication screen, click Create Package.
2. Complete the following tabs and click Next to proceed through each step.

Information

Enter the following details:

• Replication Name: Enter a name for the replication package.
• Description: Enter a brief description.
• OCA Data Source: Select the Oracle Cloud Application data source to use. The Management Console automatically tests the connection on selection.

Scheduler

Enable the Enable Scheduler toggle to run the replication automatically on a set schedule. When enabled, configure the schedule using one of the following options:

• Simple Schedule: Select the frequency (hourly, daily, or weekly), time, and repeat interval. Select Exclude Night Runs to set a start and end time for the exclusion window.
• CRON Expression: Enter a CRON expression directly. The configured schedule is displayed once set. The Exclude Night Runs toggle is also available here.

If the scheduler is not enabled, the package runs as a one-time load.

Configuration

Select a source schema from the Source Schema drop-down list. Oracle Financial Analytics is supported for this release. The table below the drop-down lists all available PVOs for the selected schema. Select the PVOs you want to extract.

Content

Review the replication summary before saving:

• Selected Tables: The number of PVOs selected for replication.
• Total Replicated Records: The total number of records in the selected PVOs.
• Tables to Replicate: Lists the schema, table name, replicated row count, and last sync date for each selected PVO.

Click Save Package to create the package.

Manage Replication Packages

Once created, each package appears in the Replication screen with its current status and available actions.

Initialize a Package

Click Initialize to start the initial data extraction. This triggers a full load of all selected PVOs from the Oracle Cloud Application instance. The extracted data is downloaded as CSV files and migrated to the configured Azure schema using the ORAFSN_Core_Extraction job, before being processed through to CFIN.

During initialization, all other actions are disabled. You can monitor progress using View Logs.

View Logs

Click View Logs to open the logs panel. The following options are available:

• Fetch All Logs: Displays all logs from the package creation date to the current status.
• Refresh Logs: Refreshes the log view with the latest entries.
• Filter logs by status (warning, error, or information) or by date range.

By default, only logs from the most recent run are displayed.

Full Replication Refresh

Once a package has been initialized, use Full Replication Refresh to trigger a full reload of all selected PVOs. This replaces the Initialize option after the first run.

Incremental Replication Refresh

Available for scheduled packages only. Use Incremental Replication Refresh to manually trigger an incremental data load, extracting only the data that has changed since the last run.

Custom Table Refresh

Available in the Edit mode under the Content tab. Select a single PVO and click Refresh to re-extract data for that PVO only. This is useful when a specific PVO's data has been corrupted or needs to be refreshed without triggering a full reload.

Note: Only one PVO can be refreshed at a time using this option.

Pause and Resume

For scheduled packages, use Pause to stop automatic replication and Resume to restart it. The next scheduled run resumes based on the configured interval.

Note: A package that is actively running cannot be stopped. Actions other than View Logs are disabled during an active run.

Edit a Package

Click the more options button in the Action column and select Edit Replication to modify an existing package. The Information tab is read-only and cannot be changed. You can update the scheduler configuration, select different PVOs in the Configuration tab, and perform a custom table refresh in the Content tab.

Delete a Package

Click the more options button in the Action column and select Delete Replication to permanently remove a replication package. Deleting a package also deletes its associated folder and CSV files from the OCA data files directory.

Note: Deleting the Oracle Cloud Application data source associated with a package also deletes all packages linked to that data source.

Folder Structure

Extracted CSV files are stored in the following path: C:\OCADataFiles\OCAInputs\DataFiles\<DataSourceName>\<PackageName>

Each package has its own folder containing the extracted PVO CSV files. Once the data has been successfully migrated to CFIN, the CSV files are deleted and archived in an Archive folder within the package directory for future reference.