Apps R12 ORA-00001: unique constraint (APPLSYS.AD_APPL_TOPS_U2) violated

Another personal note just in case this issue recurs in PROD instance while creating additional oracle application node and while
executing perl

Instances are running in Oracle Enterprise Linux 5.6 x86_64.

ORA-00001: unique constraint (APPLSYS.AD_TIMESTAMPS_U1) violated (Doc ID 727990.1)

create table ad_appl_tops_joey as select * from  ad_appl_tops;
delete from ad_appl_tops where appl_top_id = 195 and name  = ‘tabak’;

create table  AD_TIMESTAMPS_joey as select * from AD_TIMESTAMPS;
select * from AD_TIMESTAMPS where type like ‘%_CURRENT_VIEW_SNAPSHOT’;
select * from AD_TIMESTAMPS where attribute like ‘PROD%tabak%’;

–returns null

[applprod@tabak bin]$ perl
Enter the APPS username: apps

Enter the APPS user password:
        Using CONTEXT_FILE : /fin_app/PROD/inst/apps/PROD_tabak/appl/admin/PROD_tabak.xml
        Using      CTXORIG : /fin_app/PROD/apps/apps_st/comn/clone/bin/../context/apps/CTXORIG.xml
APPL_TOP name of the source system (old APPL_TOP name) : finora
APPL_TOP name of the target system (new APPL_TOP name) : tabak

Configuring snapshot information for the original (clone source) node…
Executing command:
sqlplus /nolog @/fin_app/PROD/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adadmrat.sql APPS appspw PROD PROD tabak finora /fin_app/PROD/inst/apps/PROD_tabak/temp/adadmat_sql.spool

SQL*Plus: Release – Production on Thu Nov 17 21:25:00 2011

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


Current data



8 rows selected.

Updating tables…

ERROR at line 1:
ORA-00001: unique constraint (APPLSYS.AD_APPL_TOPS_U2) violated
ORA-06512: at line 16

Disconnected from Oracle Database 11g Enterprise Edition Release – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Error configuring snapshot information for the source node…cannot proceed with adding the node.


Please read before reading the steps below,

After finishing configuring the clone instance by running I had
to run the script according to note 464018.1.
While running I faced the following error
ERROR at line 1:
ORA-00001: unique constraint (APPLSYS.AD_APPL_TOPS_U2) violated
ORA-06512: at line 16

Ifollowed note 394615.1 to solve it and after I did the steps in the
note I run again and I faced error related to
AD_TIMESTAMPS_U1 I checked on metalink but I could not find anything
then I search on google and found post by dave
from his post I took a backup the ad_timestamps and then truncate it
after that I run and it completed successfully.
Then I
updated the xml file to have only the forms and web servers running on
this new node following the same note 464018.1 I run autoconfig the
start the service on both nodes a now able to access both nodes.

I want to do now is to configure web cache as load balancer also I want
to implement Step Implement Forms Listener Servlet Support
from note (Advanced Configurations and Topologies for Enterprise
Deployments of E-Business Suite 11i) Note:217368.1 in order to have
Forms Server Load Balancing, so when one form server go down in one node
users will be connect to the other forms node.Because the current
configuration if I am connect to webnode1 and forms on that node is down
I will not be able to connect to forms and I will receive an error but
if load balancing is implemented it will take me to the other working
forms server node.


About this entry