Re: Custom TOP Creation Error

Posted by Eren on Oct 01, 2014; 11:01am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Custom-TOP-Creation-Error-tp49p61.html

This is all log file always i am getting this error while inserting FND_APPLICATION_TL(unique constraint);

************* Start of AD Splicer session *************
AD Splicer version: 12.2.0
AD Splicer started at: Wed Oct 01 2014 10:57:31

APPL_TOP is set to /u01/install/APPS/fs2/EBSapps/appl

Change DB = YES.

NLS_LANG value from the environment is    : AMERICAN_AMERICA.WE8ISO8859P9
NLS_LANG value for this AD utility run is : AMERICAN_AMERICA.WE8ISO8859P9


Backing up restart files, if any......Done.


Your previous AD Splicer session did not run to completion.
Do you wish to continue with your previous AD Splicer session [Yes] ? No

You chose to disregard your previous AD Splicer session
and to restart AD Splicer from the beginning.

Enter Yes to confirm that you wish to overwrite your previous
AD Splicer session and begin a new AD Splicer session.

Enter No to continue with your previous AD Splicer session. [No] : Yes


Please enter the name of the Oracle E-Business Suite System that this
APPL_TOP belongs to.

The Applications System name must be unique across all Oracle
Applications Systems at your site, must be from 1 to 30 characters
long, may only contain alphanumeric and underscore characters,

Sample Applications System names are: "prod", "test", "demo" and
"Development_2".

Applications System Name [ORATEST] : ORATEST *


NOTE: If you do not currently have certain types of files installed
in this APPL_TOP, you may not be able to perform certain tasks.

Example 1: If you don't have files used for installing or upgrading
the database installed in this area, you cannot install or upgrade
the database from this APPL_TOP.

Example 2: If you don't have forms files installed in this area, you cannot
generate them or run them from this APPL_TOP.

Example 3: If you don't have concurrent program files installed in this area,
you cannot relink concurrent programs or generate reports from this APPL_TOP.


Do you currently have or want to install files  used for installing or upgrading
the database in this APPL_TOP [YES] ? YES *


Do you currently have or want to install Java and HTML files for HTML-based
functionality in this APPL_TOP [YES] ? YES *


Do you currently have or want to install Oracle E-Business Suite forms files
in this APPL_TOP [YES] ? YES *


Do you currently have or want to install concurrent program files

Please enter the name Oracle E-Business Suite will use to identify this APPL_TOP.

The APPL_TOP name you select must be unique within an Oracle E-Business Suite
System, must be from 1 to 30 characters long, may only contain
alphanumeric and underscore characters, and must start with a letter.

Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".

APPL_TOP Name [daroratestappsrv1] : daroratestappsrv1 *



You are about to install or upgrade Oracle E-Business Suite product tables
in your ORACLE database 'ORATEST'
using ORACLE executables in '/u01/install/APPS/fs2/EBSapps/10.1.2'.

Is this the correct database [Yes] ? Yes

AD Splicer needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.

Enter the password for your 'SYSTEM' ORACLE schema: *****


Connecting to SYSTEM......Connected successfully.

The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS

Enter the ORACLE password of Application Object Library [APPS] : *****

AD Splicer is verifying your username/password.
Connecting to APPS......Connected successfully

The status of various features in this run of AD Splicer is:

                                           <-Feature version in->
Feature                          Active?   APPLTOP    Data model    Flags
------------------------------   -------   --------   -----------   -----------
CHECKFILE                        Yes       1          1             Y N N Y N Y
PREREQ                           Yes       6          6             Y N N Y N Y
CONCURRENT_SESSIONS              No        2          2             Y Y N Y Y N
PATCH_TIMING                     Yes       2          2             Y N N Y N Y
PATCH_HIST_IN_DB                 Yes       6          6             Y N N Y N Y
SCHEMA_SWAP                      Yes       1          1             Y N N Y Y Y
JAVA_WORKER                      Yes       1          1             Y N N Y N Y
CODELEVEL                        Yes       1          1             Y N N Y N Y



Reading product information from file...

Reading language and territory information from file...

Reading language information from applUS.txt ...

AD Splicer warning:
 Product Data File
 /u01/install/APPS/fs2/EBSapps/appl/admin/cleprod.txt
 does not exist for product "cle".
This product is registered in the database but the
above file does not exist in APPL_TOP.  The product
will be ignored without error.

AD Splicer warning:
 Product Data File
 /u01/install/APPS/fs2/EBSapps/appl/admin/xxdrdprod.txt
 does not exist for product "xxdrd".
This product is registered in the database but the
above file does not exist in APPL_TOP.  The product
will be ignored without error.


Reading database to see what industry is currently installed.

Reading FND_LANGUAGES to see what is currently installed.
Currently, the following languages are installed:

Code   Language                                Status
----   --------------------------------------- ---------
US     American English                        Base
TR     Turkish                                 Install

Reading language information from applTR.txt ...

Your base language will be AMERICAN.

Your other languages to install are: TURKISH

Setting up module information.
Reading database for information about the modules.
Saving module information.
Reading database for information about the products.
Reading database for information about how products depend on each other.
Reading topfile.txt ...

Saving product information.
*** Edition Enabled User ***


Please enter the directory where your AD Splicer control file is located.

The default directory is [/u01/install/APPS/fs2/EBSapps/appl/admin] : /u01/install/APPS/fs2/EBSapps/appl/admin

Please enter the name of your AD Splicer control file [newprods.txt] : newprods.txt


Processing file /u01/install/APPS/fs2/EBSapps/appl/admin/newprods.txt...
  Loading information for product 'xxpc'...

Warning: Because the database is in new tablespace mode, AD Splicer is ignoring the tablespace settings in your control file!

Successfully read file /u01/install/APPS/fs2/EBSapps/appl/admin/newprods.txt.


Verifying localizations...

Validating inter-product dependency information...

Re-organizing product information lists...


Adding new languages into FND_LANGUAGES...

**** Running Seed Table Prepare for FND_LANGUAGES ****

**** Running Seed Table Prepare for FND_LANGUAGES_TL ****

begin fnd_languages_pkg.add_language; end;


Connecting to SYSTEM......Connected successfully.

Creating ORACLE usernames for products...

AD Splicer is creating or updating the ORACLE username XXPC
with password ***** for EMEA Add-on Localizations tables.

alter user XXPC quota unlimited on APPS_TS_QUEUES
(grants all apps packages)

Granting privileges for tablespaces to APPS schema(s)...


alter user APPS quota unlimited on APPS_TS_TX_DATA

alter user APPS quota unlimited on APPS_TS_TX_IDX

Connecting to APPS......Connected successfully.

Registering ORACLE usernames/passwords.

Not updating column ORACLE_ID in table AD_MERGED_TABLES
because the table does not exist.

Not updating column ORACLE_ID in table ALR_ACTION_SET_CHECKS
because the table does not exist.

Not updating column ORACLE_ID in table ALR_ALERT_INSTALLATIONS
because the table does not exist.

Not updating column ORACLE_ID in table ALR_ORACLE_MAIL_ACCOUNTS
because the table does not exist.

Not updating column ORACLE_ID in table ALR_RESPONSE_ACTION_HISTORY
because the table does not exist.

Not updating column ORACLE_ID in table FND_AUDIT_SCHEMAS
because the table does not exist.

Not updating column TYPE_ID in table FND_CONCURRENT_COMPLEX_LINES
because the table does not exist.

Not updating column TYPE_ID in table FND_CONCURRENT_QUEUE_CONTENT
because the table does not exist.

Not updating column ORACLE_ID in table FND_CONCURRENT_REQUESTS
because the table does not exist.

Not updating column ORACLE_ID in table FND_DATA_GROUP_UNITS
because the table does not exist.

Not updating column ORACLE_ID in table FND_DOC_SEQUENCE_ACCESS
because the table does not exist.

Not updating column ORACLE_ID in table FND_REGRESSION_SUITES
because the table does not exist.

Not updating column ORACLE_ID in table FND_REGRESSION_TESTS
because the table does not exist.

DELETE FROM fnd_oracle_userid WHERE oracle_id = 50202

UPDATE FND_ORACLE_USERID SET INSTALL_GROUP_NUM = 0 WHERE ORACLE_ID = 1 AND
 (INSTALL_GROUP_NUM IS NULL or install_group_num != 0)

UPDATE fnd_oracle_userid SET oracle_username='APPS',
 encrypted_oracle_password='ZG2C2B2DBB5849AB7C356862F0F728826AB61B76D7265B6
27CE17D8B737994FE7A0E7ED5450DB140D975A2AF0837A9335EBF' WHERE oracle_id =
 900

**
**Inserting application information for new products..

**** Running Seed Table Prepare for FND_APPLICATION ****

**** Running Seed Table Prepare for FND_APPLICATION_TL ****

INSERT INTO FND_APPLICATION
 (APPLICATION_ID,APPLICATION_SHORT_NAME,LAST_UPDATE_DATE,LAST_UPDATED_BY,CR
EATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,BASEPATH) VALUES
 (50202,'XXPC',to_date('01/01/1980','DD/MM/YYYY'),1,to_date('01/01/1980','D
D/MM/YYYY'),1,0,'XXPC_TOP')

INSERT INTO  FND_OAM_CONTEXT_CUSTOM
 (OA_VAR,CTX_TYPE,OA_TYPE,NAME,DEFAULT_VALUE,TITLE,DESCRIPTION) VALUES
 ('c_xxpc','A','PROD_TOP','c_xxpc','/u01/install/APPS/fs2/EBSapps/appl/xxpc
/12.0.0','custom prod top xxpc','this is spliced custom prod top')
  Temporarily resetting CLASSPATH to:
  "/u01/install/APPS/fs2/EBSapps/appl/ad/12.0.0/java/adjava.zip:/u01/install/APPS/fs2/EBSapps/comn/util/jdk32/lib/dt.jar:/u01/install/APPS/fs2/EBSapps/comn/util/jdk32/lib/tools.jar:/u01/install/APPS/fs2/EBSapps/comn/util/jdk32/jre/lib/rt.jar:/u01/install/APPS/fs2/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/ebs3rdpartyManifest.jar:/u01/install/APPS/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-fmw/WEB-INF/lib/ebsFMWManifest.jar:/u01/install/APPS/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/install/APPS/fs2/FMW_Home/oracle_common/modules/oracle.uix_11.1.1/uix2.jar:/u01/install/APPS/fs2/EBSapps/comn/java/classes:/u01/install/APPS/fs2/EBSapps/10.1.2/forms/java:/u01/install/APPS/fs2/EBSapps/10.1.2/forms/java/frmall.jar:/u01/install/APPS/fs2/EBSapps/10.1.2/jlib/ewt3.jar:/u01/install/APPS/fs2/EBSapps/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar"

  Calling /u01/install/APPS/fs2/EBSapps/comn/util/jdk32/jre/bin/java ...

INSERT INTO FND_APPLICATION_TL (APPLICATION_ID, LANGUAGE, APPLICATION_NAME,
 LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,
 LAST_UPDATE_LOGIN, DESCRIPTION, SOURCE_LANG) SELECT 50202, 'US', 'EMEA
 Add-on Localizations', to_date('01/01/1980','DD/MM/YYYY'), 1,
 to_date('01/01/1980','DD/MM/YYYY'), 1, 0, 'EMEA Add-on Localizations',
 'US' FROM DUAL WHERE NOT EXISTS (SELECT 'X' FROM FND_APPLICATION_TL WHERE
 APPLICATION_ID = 50202 AND LANGUAGE IN ('US', 'AMERICAN'))

An 'ORA-00001: unique constraint is violated
when AD Splicer tried to insert into table FND_APPLICATION_TL

You should check the file
/u01/install/APPS/fs2/EBSapps/appl/admin/ORATEST/log/xxpc.log

for errors.