setEJJournalStatus

In Financial Consolidation and Close, sets the Enterprise Journal posting result from the ERP System. Use this command to update the posting status of Journals that are in Post in Progress status irrespective of their workflow status.

This command uses a CSV file identifying the status of import into the ERP system. You use the uploadFile command to upload the import file to the environment. The CSV file format is as follows:

Year,Period,Journal ID,Posting Status,Message
2020,Dec,1000001021,Posted,"SUCCESS"
2020,Dec,1000001022,Failed,"Row Header No: 2,10000415 - Linked value 6 does not exist Application-defined or object-defined error 65171"
2020,Dec,1000001022,Failed,"Row Header No: 7,10000415 - Z_ECS_MSG (001)Enter a valid account number"
2020,Dec,1000001022,Failed,"Row Header No: 7,10000415 - Z_ECS_MSG (002) Enter a valid cost center"

Message column is optional and may be omitted.

This command does not export Enterprise Journal data from Financial Consolidation and Close or import it into the ERP system.

Applies to

Financial Consolidation and Close

Required Roles

Service Administrator

Usage

epmautomate setEJJournalStatus FILE_NAME.csv [OPERATION=posting|validation] where:

• FILE_NAME identifies the CSV file containing the status of import into the ERP system.
• Operation, optionally, is the operation to perform. Possible values are posting and validation. Default is posting

  operation=posting provides a CSV file containing the results of the journal posting with these columns: Year, Period, Journal ID, Posting Status (Posted/Failed), Message, Error Code, and Error Message. The Message, Error Code and Error Message columns are optional. Posting status of the journals is updated based on the status provided in the file. Only journals with a Posting status of Post in Progress are be updated.

  operation = validation generates a CSV file containing the results of the journal validation with these columns: Year, Period, Journal ID, Validation Status (Valid/Failed), Message, Error Code, Error Message. The Message, Error Code and Error Message columns are optional. Validation status of the journals is updated based on the status provided in the file. Only journals with a Validation status of Validation In Progress will be updated.

Example

• Set the Enterprise Journal posting results from a file:

  epmautomate setEJJournalStatus JournalStatus.csv
• Set the Enterprise Journal posting results from a file: and perform validation operation:

  epmautomate esetEJJournalStatus JournalStatus.csv Operation=validation