adop hotpatch

[satish]

Thanks for the update erman.we will check it

[Satish]

Thanks erman.

Any idea how session I'd will be populated in adop tables

[satish]

Dear erman,

could you please let us know how the session id gets populated in adop tables

[ErmanArslansOracleBlog]

It is done internally. But here is what I find;

For ad_adop_session_patches;

Note: STATUS

N - Not Applied In the current node but applied in other nodes
R - Patch Application is going on.
H - Patch failed in the middle. (Hard Failure)
F - Patch failed in the middle but user tried to skip some failures.
S - Patch Application succeeded after skipping the failed jobs.
Y - Patch Application succeeded.

C - Reserved for clone and config_clone. Indicates clone completed

So in your case, the patch number 23021248 seems to be applied to both of the nodes.
It seems you have tried it multiple times, and each time the status column of the table is updated with "Y" value.

Maybe that's what stopping you..

Please run the script documented in following note and analyze the output of it..

Script to Diagnose adop and Other AD-TXK Issues in Oracle E-Business Suite Release 12.2 [ Patch 19045166:R12.AD.C ] (Doc ID 1901242.1)