1. Administering Data Management for Oracle Enterprise Performance Management Cloud
  2. System Maintenance Tasks
  3. Lifecycle (LCM) Snapshots
  4. Exporting Data to a Snapshot
  5. Executing a Snapshot Export Job

Executing a Snapshot Export Job

The data export process exports all artifacts from setup and data folders including the ID columns to a ZIP file. Artifacts are exported by POV and retain the ID of the setup artifact when data is exported and then imported to the target environment.

The snapshot export options supports: All, All Incremental, Incremental, and Setup export types.

To execute a snapshot export:

  1. On the Workflow tab, under System Maintenance Tasks, select Execute Snapshot Export.
  2. Click Execute.

    Image shows Execute Script page.

  3. In Snapshot Type, select the type of snapshot to export.

    Available snapshot types:

    • All—Includes all setup and historical artifacts.
    • All Incremental—Include only new or changed historical artifacts based on the POV since the last snapshot was exported and include setup artificats and all POVs (old and new) in the output file.
    • Incremental— Include only new or changed historical data based on the POV since the last snapshot was exported and include only setup artifacts and new POVs in the output file.
    • Setup—Includes only setup artifacts.
  4. In Snapshot File Name, specify the file name of the ZIP with the ZIP extension to be written to the outbox for the snapshot export.

    For example, you might type: DMSnapshot_082021.zip.

    If a file doesn't end with a ZIP extension, Data Management forces a ZIP extension by appending a .zip suffix at the end of the file name.

  5. In Overwrite Output File, specify Yes to overwrite a ZIP that has the same name as the one you are creating. Otherwise, specify No.

    Tip:

    If you specify an existing output file and specify No to overwrite the existing output file (ZIP), the job fails and the system shows the message: "Rule Execution did not complete successfully."

    Image shows the Execute Script page.

  6. Click OK.

    One Execute Snapshot Exports job can be executed at a time.

    The message: Custom script executed initiated with Process ID: XXX is displayed (where XXX is the process id number generated for the job).

    You can access the job log from the Process Details page in Data Management.

    You can view the snapshot export ZIP after the snapshot export has completed by downloading the output ZIP in Process Details.

    You can also download the snapshot ZIP using the EPM Automate downloadFile command.

  7. Optional: Click Schedule to schedule the job.

    For information on scheduling jobs, see Scheduling Jobs.