ERRORMSG: Adsplice action did not go through successfully.

Hello every one,

We have encountered a issue with adop prepare phase where it was failing with below. This issue happened when we added custom application post 12.2.8 upgrade with adsplice.

Inside evalADPATCHStatus()...

=============================

message_status: ERROR

Adsplice action did not go through successfully.

*******FATAL ERROR*******

PROGRAM : (/u01/app/***/KLNMRY/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl)

TIME  : Fri Apr 19 12:49:55 2019

FUNCTION: main::execADSPLICE [ Level 1 ]

ERRORMSG: Adsplice action did not go through successfully.

Solution

======

We've below custom applications in our environment installed. we'd got this custom products in a report from the script ADZDPSUM.sql at Enable online patching.

SQL> select ORACLE_ID,ORACLE_USERNAME,ENABLED_FLAG from FND_ORACLE_USERID WHERE ORACLE_USERNAME in ('KAAPO','KAAGL','KKKAA','KAAAP','KKE4A','KKE4ARW');

ORACLE_ID ORACLE_USERNAME        E

---------- ------------------------------ -

   20043 KAAAP

   20044 KAAGL

   20045 KAAPO

   50505 KKE4A             N

   50506 KKE4ARW            N

   20046 KKKAA

**Take backup of table "FND_ORACLE_USERID"

SQL> create table FND_ORACLE_USERID_bkp as select * from FND_ORACLE_USERID;

Table created.

**Run below command for custom application products.

UPDATE FND_ORACLE_USERID SET ENABLED_FLAG = 'N' WHERE ORACLE_ID in (20043,20044,20045,20046);

SQL> select ORACLE_ID,ORACLE_USERNAME,ENABLED_FLAG from FND_ORACLE_USERID WHERE ORACLE_USERNAME in ('KAAPO','KAAGL','KKKAA','KAAAP','KKE4A','KKE4ARW');

ORACLE_ID ORACLE_USERNAME        E

---------- ------------------------------ -

   20043 KAAAP             N

   20044 KAAGL             N

   20045 KAAPO             N

   50505 KKE4A             N

   50506 KKE4ARW            N

   20046 KKKAA             N

6 rows selected.

Then kick start adop prepare phase. It will compete with no issues.

ML :: 1932207.1

Thanks.

Sreeharsha