1. Working with EPM Automate for Oracle Enterprise Performance Management Cloud
  2. Command Reference
  3. EPM Automate Commands
  4. setDemoDates

setDemoDates

Updates Oracle internal demo data as needed.

Use this command only on installations setup with Oracle internal demo data.

Account Reconciliation only: This command resets dates for all reconciliations that have associated Demo Code attribute values of setdemodates or setdemodatesnostatuschange. This command handles reconciliations for up to 12 periods: a current period and 11 prior (historic) periods. If reconciliations from more than two periods are tagged with the Demo Code attribute, the command treats those periods as being in the prior period. Reconciliations that do not have this attribute value are not affected.

  • If the value is setdemodates, the command resets the reconciliation dates based on the specified date and a random status
  • If the value is setdemodatesnostatuschange, the command resets the reconciliation dates based on the specified date without changing the reconciliation status

Financial Consolidation and Close and Tax Reporting only: This command resets the tasks start and end dates, and other related date information, to make the tasks look good for a demo. It calculates the new task dates based on the value of the SETDEMODATES attribute set in the task's schedule along with the value of the Demo Date value that you provide. If Demo Date value is not specified, the command uses today's date to calculate the new task dates.

Note:

Tasks in schedules that do not have SETDEMODATES value are not affected.

Based on the Demo Date that you specify, this command moves forward all dates associated with the task. This includes core run time dates (start date, end date, etc.) and ancillary dates including those of history, individual workflow due dates, and start date (actual). Task status is not affected.

Applies to

Planning, Planning Modules, FreeForm, Financial Consolidation and Close, Tax Reporting, and Account Reconciliation, Sales Planning, and Strategic Workforce Planning

Required Roles

  • Service Administrator
  • Power User
  • User
  • Viewer
Users with Power User, User, and Viewer predefined roles may require additional application roles.

Usage

epmautomate setDemoDates [DEMO_DATE] where DEMO_DATE is an optional date in YYYY-MM-DD format. Reconciliations are reset to the current date if you do not specify this value.

Example

epmautomate setDemoDates 2020-02-15