Monday, June 16, 2014

EBS 12.2 -- Patch: 17020683 ORA-02289: sequence does not exist

If you are upgrading from 12.2.0 to 12.2.3 and if you have applied TXK and AD Delta 4 patches  before upgrading to 12.2.3; you may encounter "ORA-02289: sequence does not exist " error during upgrade patch. (17020683)

Actually, you patch can be completed successfully, but you may find following in your patch log file.

Starting phase 40 (A40): daa
AutoPatch error:
The following ORACLE error:
ORA-02289: sequence does not exist
occurred while executing the SQL statement:
SELECT to_char(APPLSYS.AD_TASK_STATUS_S.NEXTVAL) FROM SYS.DUAL

Unable to get the current value of sequence APPLSYS.AD_TASK_STATUS_S.
AutoPatch error:
adptaskPrepatchTiming: Error calling aiuoqg()
AutoPatch error:
aijpsp: Error calling adptaskPrepatchTiming.

There are an SR record in the Oracle Support ,for the same error, altough it is reported for a different activity. On the other hand, there are no patch info for fixing this issue. So we have raised an SR for this.

The solution is to apply 18880325:R12.AD.C patch , before the 12.2.3 upgrade patch.(17020683)

So when you encounter this ORA-02289 error; 
abort the patching cycle; start a new patching cycle;
grant select on applsys.ad_task_status_s to apps;  
in this patching cycle apply 18880325:R12.AD.C
grant select on applsys.ad_task_status_s to apps;
Check your relink log. ensure that there are nor erorrs. 
then apply 17020683 in the same patching cycle... 
After this 2 patches are completed, complete your patching cycle using finalize,cutover, cleanup and fs_clone..

No comments :

Post a Comment