adsplice errors

Posted by ali evrim on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/adsplice-errors-tp103.html

Hi,

I am getting an error when add a custom top  for XXTKB  

SQL Command: SELECT status||',' FROM ad_adop_session_patches WHERE node_name = 'erpprod' AND applied_file_system_base = '/apps/fs2' AND patch_file_system_base IS NULL AND bug_number = 'ADSPLICE_xxtkb' ORDER BY TO_CHAR(end_date,'YYYY.MM.DD:HH24:MI:SS') DESC
patch_status = Y,Y,Y
STATUS has MULTIPLE VALUES. Picking up the latest value.
Updated patch_status = Y
EXIT STATUS: 1
=============================
Inside evalADPATCHStatus()...
=============================
message_status: ERROR
Adsplice action did not go through successfully.
*******FATAL ERROR*******
PROGRAM : (/apps/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl)


Result of the above select :

STATUS
Y,
Y,
Y,
Y,




Also :

select ORACLE_ID from FND_ORACLE_USERID where oracle_username like '%XXTKB%'
13555

select application_id from fnd_application where application_short_name = 'XXTKB';
13355

select * from fnd_product_installations where oracle_id=13555
application_id  oracle_id
    13355     13555
    13555   13555
    50017   13555

Different three values for oracle_id 13555

Please help me!!!!