Oracle ERP Financial Cloud Configuration for Chart of Account

This section focuses on importing the files that come as a part of the package and configuring them in Oracle ERP Financial Cloud for the integration to run successfully. Make sure to follow the same sequence for successful configuration.

• Migrating Reports in Oracle Cloud Instances

• Running the Chart of Account Report

Migrating Reports in Oracle Cloud Instances

The migration process involves three main steps:

1. Archiving the report and data model.

2. Un-archiving the report and data model.

3. Pointing the report to the correct data model.

To migrate reports:

1. Navigate to Tools > Report and Analytics.

2. Browse to the folder where the report and data model is placed.

3. In Shared Folders > Custom Folder, create a folder with name “FINWACS”.

4. Select the files in the package that have an extension “.xdm.catalog” and “xdo.catalog”.

5. Un-archive the report and data model.

6. Un-archive the files in the new instance.

7. Navigate to the folder created in step 3 to upload the report.

8. Click Unarchive in the Tasks pane.

The system will prompt you to browse and upload the file from your desktop. Make sure to select the “.xdo.catalog” file for the report and “.xdm.catalog” file for the data model.

9. Point the report to the correct data model.

10. After uploading the report and/or data model, select the report and click Edit.

11. Click Search to navigate to the respective folder and select the data model.

12. Save the changes.

If the report is not generated:

1. Generate the sample data from the data model.

2. Save the data to create the report.

3. Select the same folder and override the existing “xdm.catalog” file.

Running the Chart of Account Report

To run the Chart of Account Report:

1. Login to Oracle ERP Financial Cloud.

2. Navigate to Tools > Report and Analytics.

3. Open the “FIN_COA_WACS.xdo” report.

4. Enter the COA Name, Effective Date, and Run Type.

To schedule the file:

1. Login to Oracle ERP Financial Cloud.

2. Navigate to Gear Icon > Schedule > Output.

3. Select Compress.

4. Select the Destination Type as “Content Sever” and click Add Destination.

5. From the Security Group drop-down list, select “FAFusionImportExport”.

6. Enter the report name and click Submit.

Note the following:

• BULK Run Type: Date should be the business start date.

Example: Business started on 01 January, 2000. Use that or from when the records are created for code combination table.

• Incremental Run Type: Current date of the report run to pull the changes from the last run date.