Can you provide us with a sample of the concurrent requests' names you are talking about?
Some requests became obsolete in R12. Others have their parameters changed.
For the first case, you should check the requests you use for replacement ones in R12 and schedule them.
For the second case, you need to reschedule them using the new parameters.
We are having multiple concurrent request standard and custom running in
our production. There are around 150 pragrams.
Is there any way to bring those program during upgrade.
On 3 May 2015 20:28, "community-admin" <firstname.lastname@example.org>
The upgrade does not change the scheduling of any concurrent request.
It changes the setup of some requests as I have explained.
The custom requests are not affected.
If you query the requests table, what is the status of the last request run for those requests?
If it is error, then something prevented the application from resubmitting the request again.
Can you provide the log files of one of the requests that ran after the system was brought up right after the upgrade.
None of our request have been upgraded during our upgrade. I want to know
why all those program were not upgraded during our upgrade, whether we need
to do anything in our preupgrade steps to have the scheduled programs.
Can you please leat us know the steps to have the scheduled programs in our
On 3 May 2015 21:00, "community-admin" <email@example.com>
Can you upload the result of the following query:
where actual_start_date >= <The date you finished the upgrade and started the services>
and status_code = 'E'
Please find the attached result.
Along with this mail, I have attached both the result for the given query
and the scheduled program supposed to be in Upgrade and which is not
On Mon, May 4, 2015 at 9:12 AM, community-admin <
Since there are many requests involved, I cannot check the issue with each one of them.
I'll try to diagnose a sample number of programs to see if there is a common problem.
Can you check the log of the following requests and if you can't figure out the problem then upload the files for me to review them.
The following requests have errors related to the application and database objects. You need to review them and make the necessary changes such as ensuring that the packages are valid:
Cause: FDPSTP failed due to ORA-01861: literal does not match format string
ORA-06512: at "APPS.CUST_ACC_REC_CC", line 266
Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'XXALG_BANK_IDS_11IR12_UPD_PRC'
Cause: FDPSTP failed due to ORA-00001: unique constraint (APPS.SYS_C002363933) violated
ORA-06512: at "APPS.XXALG_BANK_IDS_11I_AND_R12_PKG", line 51
Cause: FDPSTP failed due to ORA-28113: policy predicate has error
ORA-06512: at "APPS.XX_FRENCH_LANG_TAB_COUNT_PRC", line 36