ERRORMSG: Adsplice action did not go through successfully.

ADOP prepare phase failed with below Error:

Reading language information from applUS.txt ...
  Temporarily resetting CLASSPATH to:
  "/web03/TEST/fs2/EBSapps/appl/ad/12.0.0/java/adjava.zip:/web03/TEST/fs2/EBSapps/comn/util/jdk32/lib/dt.jar:/web03/TEST/fs2/EBSapps/comn/util/jdk32/lib/tools.jar:/web03/TEST/fs2/EBSapps/comn/util/jdk32/jre/lib/rt.jar:/web03/TEST/fs2/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/ebs3rdpartyManifest.jar:/web03/TEST/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-fmw/WEB-INF/lib/ebsFMWManifest.jar:/web03/TEST/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/web03/TEST/fs2/FMW_Home/oracle_common/modules/oracle.uix_11.1.1/uix2.jar:/web03/TEST/fs2/EBSapps/comn/java/classes:/web03/TEST/fs2/EBSapps/10.1.2/forms/java:/web03/TEST/fs2/EBSapps/10.1.2/forms/java/frmall.jar:/web03/TEST/fs2/EBSapps/10.1.2/jlib/ewt3.jar:/web03/TEST/fs2/EBSapps/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar"

  Calling /web03/TEST/fs2/EBSapps/comn/util/jdk32/jre/bin/java ...
*******FATAL ERROR*******
PROGRAM : (/web03/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl)
TIME    : Mon Dec 11 15:03:31 2017
FUNCTION: main::execADSPLICE [ Level 1 ]
ERRORMSG: Adsplice action did not go through successfully.

    [UNEXPECTED]Error occurred running "perl /web03/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/web03/TEST/fs1/inst/apps/TEST_epswdev/appl/admin/TEST_epswdev.xml -patchcontextfile=/web03/TEST/fs2/inst/apps/TEST_epswdev/appl/admin/TEST_epswdev.xml -promptmsg=hide -console=off -patchtop=/web03/TEST/fs_ne/EBSapps/patch -mode=update -sync_mode=patch -sessionid=10 -timestamp=20171211_142941 -workercount=16 -outdir=/web03/TEST/fs_ne/EBSapps/log/adop/10/20171211_142941/prepare/epswdev -autoskip=No"
    [UNEXPECTED]Error calling runSyncFS subroutine.
    Stopping services on patch file system.
    Stopping admin server.

You are running adadminsrvctl.sh version 120.10.12020000.10


 The AdminServer is already shutdown

AdminServer logs are located at /web03/TEST/fs2/FMW_Home/user_projects/domains/EBS_domain_TEST/servers/AdminServer/logs

adadminsrvctl.sh: exiting with status 2

adadminsrvctl.sh: check the logfile /web03/TEST/fs2/inst/apps/TEST_epswdev/logs/appl/admin/log/adadminsrvctl.txt for more information ...

    Stopping node manager.

You are running adnodemgrctl.sh version 120.11.12020000.12


The Node Manager is already shutdown

NodeManager log is located at /web03/TEST/fs2/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1

adnodemgrctl.sh: exiting with status 2

adnodemgrctl.sh: check the logfile /web03/TEST/fs2/inst/apps/TEST_epswdev/logs/appl/admin/log/adnodemgrctl.txt for more information ...

    [ERROR]     Prepare phase has failed.


[STATEMENT] Please run adopscanlog utility, using the command

"adopscanlog -latest=yes"

to get the list of the log files along with snippet of the error message corresponding to each log file.


adop exiting with status = 1 (Fail)


=============================
Inside evalADPATCHStatus()...
=============================

message_status: ERROR
Adsplice action did not go through successfully.
*******FATAL ERROR*******
PROGRAM : (/web03/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl)
TIME    : Mon Dec 11 15:03:31 2017
FUNCTION: main::execADSPLICE [ Level 1 ]
ERRORMSG: Adsplice action did not go through successfully.

Solution:

select ORACLE_ID,ORACLE_USERNAME,ENABLED_FLAG from FND_ORACLE_USERID WHERE ORACLE_USERNAME ='XBOL';

ORACLE_ID ORACLE_USERNAME ENABLED_FLAG
20043           XBOL   

UPDATE FND_ORACLE_USERID SET ENABLED_FLAG = 'N' WHERE ORACLE_ID = 20043;

select ORACLE_ID,ORACLE_USERNAME,ENABLED_FLAG from FND_ORACLE_USERID WHERE ORACLE_USERNAME ='XBOL';

ORACLE_ID ORACLE_USERNAME ENABLED_FLAG
20043           XBOL              N

If issue still Persist follow below action plan.

Run adop phase=cleanup cleanup_mode=full
Run adop phase=fs_clone

Reference : Adop Prepare ERRORMSG: Adsplice Action Did Not Go Through Successfully After Add new Custom Application in R12.2 (Doc ID 1932207.1)