Compare Task Setup Data

As a best practice, you can compare the exported setup data of a task before you import it into an environment.

For example, you have made some changes to the setup data in a test environment and exported it. Now, you want to import the same data into a production environment. But before you import, you can compare the exported data of the test environment with the existing production data or another configuration package. You can preview how the setup data in production will change after the import.

To compare offering setup data from a CSV file, you must have the Export Import Functional Setups User (ORA_ASM_FUNCTIONAL_SETUPS_USER_ABSTRACT) role, and a role with task-specific privileges to enter and modify setup data. If you intend to handle setup data for an offering, you might need an appropriate application administrator role as well.

  1. In the production environment, go to the Setup and Maintenance work area.

  2. In your offering, navigate to the setup task for which you want to compare the setup data.

    Tip: If you can't see your task, click Show > All Tasks. If you don't see the Actions column, click View > Columns > Actions to enable it.
  3. Select the task and click Actions > Compare Setup Data > Create New. The compare setup data process begins.

  4. On the Compare Setup Data page, for Configuration 1, click the CSV File Package list and select Upload New.

  5. On the Upload Setup Data page, browse and select the CSV file package containing the exported task setup data and click Open.

  6. In the CSV File Package Details section, verify the details to be sure of selecting the correct exported file. If it's not the correct file, click Update to browse and select the correct file.

  7. For Configuration 2, the option Data in this environment is selected by default to compare with the existing data in the environment. But if you want to compare with another configuration package, click Source and upload another configuration package file.

  8. Enter a name in the Process Name field.

  9. Click Submit. The comparison process starts.

  10. To review the comparison summary after the process completes, go to Actions > Compare Setup Data and click the process that you submitted. The latest process appears at the top of the list. The Comparison Process Results page appears with details.

  11. Review the details in each section. The details from the CSV file package and the production environment are separately displayed so that you can compare the results.

  12. Examine the contents and check for discrepancies, if any.

    Note: Configuration 1 refers to the contents of the CSV file package, and Configuration 2 refers to the data in the production environment. For detailed description of the comparison results, see topic Setup Data Comparison Results.
  13. Click the value in the relevant column. A spreadsheet appears listing the discrepant details.

  14. Scroll through the listed entries to examine the details. If you need to correct any data before the import, make sure that the modifications are included in the exported files you selected for comparison.

    Note: Importing the CSV file doesn't delete data records in the production environment. Therefore, if you want to remove anything from the production data, you must manually delete the specific records.
  15. Import the CSV file package once you're satisfied with the comparison results and have made the necessary changes in the CSV file package and the production environment.