Guidance on Business Intelligence Cloud Connector job orchestration
Summary:
Guidance on Business Intelligence Cloud Connector job orchestration
Content (please ensure you mask any confidential information):
We need to execute JOURNAL_INGESTION_EXTRACT_JOB (a Business Intelligence Cloud Connector job) right after an “Import Accounting Transaction” is triggered. However, we need first to wait till such job triggers the Create Accounting for Data Set and the Post Journals for Single Ledger. Once both these jobs are completed, the BICC job can be run (so that journals that are being posted will be included in the extract job).
To orchestrate this process we adopted the following approach:
- Creation of a report in Fusion that retrieve the status of the 3 abovementioned jobs (Import Accounting Transaction, Create Accounting for Data Set, Post Journals for Single Ledger)