ADOP Frequently Using Commands

How to check Patch applied status

Select bug_number,creation_date from ad_bugs where bug_number=<Patch Number>

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 EBS CPU level

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

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;