Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Correlation between Parent and Child ESS Jobs in ERP Cloud Scheduled Processes

Abhishek TrivediNov 21 2022

Hi Everyone,
Is there a way to find the link/correlation between the job Ids of Parent ESS Jobs and Child ESS Jobs in Oracle Fusion Scheduled Processes?
Problem Scenario-
In ERP Cloud we have several ESS Jobs that trigger child ESS jobs to complete the orchestration. For Example- 'Create Accounting' triggers 'Create Accounting: Subprocess', 'Post Subledger Journal Entries', 'Post Subledger Journal Entries: Subprocess' etc.
We have another case of 'Load Interface File for Import' where the child jobs can be easily identified using the below query.
select * from ess_request_history where absparentid=<parentEssJobId>
Do we have any similar approach that would help identify the Job Ids of child processes for standard ESS jobs like 'Create Accounting', 'Initiate Payment Process Request' etc.

Thanks in Advance.

Comments
Post Details
Added on Nov 21 2022
1 comment
1,020 views