How to avoid 2 same concurrent program to run at a time?
Hi Experts,
we have one customized concurrent program scheduled for every 2 hrs. sometimes we need to run the same program manually.
But whenever we running that customized program manually at the same time of scheduled time we getting the error.
Cause: FDPSTP failed due to ORA-02049: timeout: distributed transaction waiting for lock ORA-06512: at "APPS.PWC_SITE_TO_APPS_GRN", line 579 ORA-06512: at line 1
I want to avoid this error.
If the program is submitted manually at the same time of scheduled program running i need the manually submitted one to wait untill the scheduled one completes.
I need this for that particular program.
we have one customized concurrent program scheduled for every 2 hrs. sometimes we need to run the same program manually.
But whenever we running that customized program manually at the same time of scheduled time we getting the error.
Cause: FDPSTP failed due to ORA-02049: timeout: distributed transaction waiting for lock ORA-06512: at "APPS.PWC_SITE_TO_APPS_GRN", line 579 ORA-06512: at line 1
I want to avoid this error.
If the program is submitted manually at the same time of scheduled program running i need the manually submitted one to wait untill the scheduled one completes.
I need this for that particular program.
0