Updates Oracle internal demo data as needed.

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

Account Reconciliation only: This command renames the periods in Account Reconciliation to be consistent with the specified date. It also resets dates for all reconciliations that have associated Demo Code attribute values of setdemodate or setdemodatenostatuschage.

This command handles reconciliations in up to two periods; a current period and a prior (historic) period. 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 setdemodate, the command resets the reconciliation dates based on the specified date and returns it to Open with Preparer status
  • If the value is setdemodatenostatuschage, 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.


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, Oracle Sales Planning Cloud, and Oracle Strategic Workforce Planning Cloud

Required Roles

Service Administrator, Power User, User, Viewer

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


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.


epmautomate setDemoDates 2020-02-15