Schedule Request Set one request Parent is not waiting for it's child spawned program to be complete
We had defined a request set with the following requests:
1 | Bank Statement Loader |
1a | Run SQL*Loader- BAI2 |
1b | Load Bank Statement Data |
2 | ECC Bank Statement Populate Opening Balances |
3 | Bank Statement Import |
3a | Bank Statement Import Execution Report |
3b | Bank Statement Loader Execution Report |
4 | AutoReconciliation |
4a | AutoReconciliation Execution Report |
a/b are the child spawned program.
In this case we want the Program 3: ECCBank Statement Populate... should start after the child programs 1a/1b finishes which been called from Bank Statement Loader(1).But after making every program incompatible with each other the
Parent Program 1.Bak Statement Loader completes earlier to Child spawned program which is causing the 2>ECC... Bank statment program to start running before the two child spawned program(1a/1b) finishers.