ADOP Frequently Using Commands

How to check EBS CPU level

Select max (CODELEVEL) "CPU" from AD_TRACKABLE_ENTITIES where ABBREVIATION in ('ebscpu');

    

How to check AD and TXK Code level

Select abbreviation,codelevel from ad_trackable_entities where abbreviation in( 'ad','txk','cc_pf','atg_pf','scp_pf' ) order by abbreviation;

    

How to check Patch applied status

Select bug_number,creation_date from ad_bugs where bug_number=
    

How to check Installed language in EBS

SELECT Language_code, NLS_language, Installed_flag FROM fnd_languages WHERE installed_flag IN ('I', 'B');

I- Installed Language

B- Base Language
    

Is System crash/Unable to continue the Adop session 

Execute below querys to find which session is causing theissue

select adop_session_id from ad_adop_sessions where status='R';
    

  select ADOP_SESSION_ID,PREPARE_STATUS,APPLY_STATUS,FINALIZE_STATUS,CUTOVER_STATUS,CLEANUP_STATUS,ABORT_STATUS,STATUS,ABANDON_FLAG,NODE_NAME from AD_ADOP_SESSIONS where ADOP_SESSION_ID='&sid';
    

Set the status to Completed 'C' for that session to re- try the adop phase.

update ad_adop_sessions set status='C'where status='R’;
    

update ad_adop_sessions set APPLY_STATUS='C' where adop_session_id=28;
    

update ad_adop_sessions set PREPARE_STATUS='C' where adop_session_id=28;
    

update ad_adop_sessions set CUTOVER_STATUS='C' where adop_session_id=28;
    

update ad_adop_sessions set CLEANUP_STATUS='C' where adop_session_id=28;
    

update ad_adop_sessions set ABORT_STATUS='C' where adop_session_id=28;