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 where FILE_NAME identifies the CSV file containing the status of import into the ERP system.

Example

epmautomate setEJJournalStatus JournalStatus.csv