Custom TOP Creation Error

[Eren]

Hi Erman,

We are trying to create custom top on 12.2
I created one custom top and now its workıng,but shortly after ı tried a new one,
Bu ı am getting error in adplice.log file;

Done running adaaddlb.pls for XXPC


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.


AND end of the log file,
Calling /u01/install/APPS/fs2/EBSapps/comn/util/jdk32/jre/bin/java ...
ERROR: Failed to add xxpc in oa_customized block in context file

[ErmanArslansOracleBlog]

This is adsplice right?

I think this custom top was already added .. Maybe It was added incompletely in one of your tries.

Anyways,

Open you context file ($CONTEXT_FILE) and remove the entries, and retry..

<oa_customized>

  </oa_customized>


Let me know the final state

[Eren]

thıs ıs my context fıle last block;

<oa_customized>
      <c_cle oa_var="c_cle" scope="CUSTOM" oa_type="PROD_TOP" oa_enabled="FALSE">/u01/install/APPS/fs2/EBSapps/appl/cle/12.0.0</c_cle>
      <c_xxdrd oa_var="c_xxdrd" scope="CUSTOM" oa_type="PROD_TOP" oa_enabled="FALSE">/u01/install/APPS/fs2/EBSapps/appl/xxdrd/12.0.0</c_xxdrd>
      <c_xxpc oa_var="c_xxpc" scope="CUSTOM" oa_type="PROD_TOP" oa_enabled="FALSE">/u01/install/APPS/fs2/EBSapps/appl/xxpc/12.0.0</c_xxpc>
      <c_xxrc oa_var="c_xxrc" scope="CUSTOM" oa_type="PROD_TOP" oa_enabled="FALSE">/u01/install/APPS/fs2/EBSapps/appl/xxrc/12.0.0</c_xxrc>
      <c_xxcc oa_var="c_xxcc" scope="CUSTOM" oa_type="PROD_TOP" oa_enabled="FALSE">/u01/install/APPS/fs2/EBSapps/appl/xxcc/12.0.0</c_xxcc>
   </oa_customized>

should i comment or delete xxpc line

[ErmanArslansOracleBlog]

Delete the line;

<c_xxpc oa_var="c_xxpc" scope="CUSTOM" oa_type="PROD_TOP" oa_enabled="FALSE">/u01/install/APPS/fs2/EBSapps/appl/xxpc/12.0.0</c_xxpc>

[Eren]

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.

[ErmanArslansOracleBlog]

I guess you already defined this application..
What do you have in fnd_applications_tl table? You should see a row already defined for you application.
This is EBS 12.2 right?

If so;

what is the output of the following query?

select application_id,şanguage,application_name,zd_edition_name FROM "APPLSYS"."FND_APPLICATION_TL" where application_id='50202'

[Eren]

==>>XXDRD TOP IS WORKING;

-select application_id from apps.fnd_application where application_short_name like '%XXDRD%';

13020

-SELECT application_id,language,application_name,zd_edition_name FROM "APPLSYS"."FND_APPLICATION_TL" WHERE application_id = '13020'

13020 TR EMEA Add-on Localizations V_20140708_1103
13020 US EMEA Add-on Localizations V_20140708_1103



==>>XXPC TOP is already in fnd_application but .....

-select application_id from apps.fnd_application where application_short_name like '%XXPC%';

13021

-SELECT application_id,language,application_name,zd_edition_name FROM "APPLSYS"."FND_APPLICATION_TL" WHERE application_id = '13021'

EMPTY RESULT

[ErmanArslansOracleBlog]

Okay,

Please follow : http://ermanarslan.blogspot.com.tr/2014/05/ebs-122-add-custom-top.html

You need edit the files that adsplice takes its inputs from ,
Modify the lines where you declare application_id etc.., and execute adsplice after that.

You need to modify that files before executing adsplice. For each product..

[Eren]

Hi Erman,

TY for your assistance

There is file xxpcterr.txt.
When i change the parameter "EMEA Addon Localizations" to "TOP name".
Problem resolved.