ADOP FS_CLONE Issues

Performing CLONE steps...
  Log: /opt/oracle/CLOUD/fs_ne/EBSapps/log/adop/11/fs_clone_20150806_103139/CLOUD_ebsclone4
*******FATAL ERROR*******
PROGRAM : (/opt/oracle/*****/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl)
TIME : Thu Aug 6 10:34:59 2015
FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ] 
MESSAGES:
SQLPLUS error: buffer=

SQL*Plus: Release 10.1.0.5.0 - Production on Thu Aug 6 10:34:59 2015

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> SQL> Connected.
SQL> SELECT clone_status||',' FROM ad_adop_session_patches WHERE status in ('R','F','N') AND bug_number = 'CLONE' AND node_name = 'ebsclone4' AND adop_session_id =
  *
ERROR at line 1:
ORA-00936: missing expression
:
:

A. For a manual workaround:

1. Apply Patch 19045166 to obtain the diagnostic information for the latest adop sessions.

2. From generated diagnostics check the adzdshowstatus.out.

  For example:

=========================================================================
=                 Summary of the Last 10 ADOP Cycles
=========================================================================

Session ID Node Name  Node Type Started    Elapsed(Prepare) Elapsed(Cutover) Elapsed(Cleanup) Elapsed(Apply)  Status       Patches Applied      Session Type
---------- ---------- --------- ---------- ---------------- ---------------- ---------------- --------------- ------------ -------------------- ---------------
       13 ebsystem  master    24-AUG-15  1:04:50          0:00:00          0:00:00          0:00:00         FAILED       --                   --

       11 ebsystem  master    04-AUG-15  0:33:39          0:00:00          0:01:56          0:00:00         FAILED       CONFIG_CLONE         CONFIG_CLONE

3. Take a back up for table ad_adop_session_patches.
4. Run the following sql:

 update ad_adop_session_patches set
 bug_number='CLONE',status='N',SESSION_TYPE='CLONE',CLONE_STATUS='NOT STARTED'
 where bug_number='CONFIG_CLONE' and status <> 'Y' and adop_Session_id=<*>  ;
 commit;

Where <*> =  the session_id related to the CONFIG_CLONE row, in above example eg.  adop_Session_id= '11'.

5. Re-run adop phase=fs_clone to confirm the results.

B. For a patching solution:

1. Download and review the readme of Patch  21132723.  This patch is part of 21132723:R12.AD.C 1-OFF Fixes on top of R12.AD.C.DELTA.6.

2. Apply the patch in a test instance after a backup and re-test.

3. Confirm the file version:  $AD_TOP/perl/ADOP ClonePhase.pm 120.0.12020000.8

3. Apply the patch to other instances the same as needed.

12.2 E-Business Suite - Collecting Online Patching and fs_clone Log Files (Doc ID 1542162.1)