Validation of Custom Applications: Examples

This appendix covers the following topics:

Validation of Custom Applications: Examples

The following table lists examples of issues that might be discovered in validating a custom application. Recommended solutions are also provided. These examples apply only to Oracle E-Business Suite Release 11i.

Because the list of issues and its corresponding recommendations will vary for one instance to another, please run requests to validate existing custom applications to generate release-specific and instance-specific recommendations. See: Managing Custom Applications.

The example custom application 'xxcust' used in this table corresponds to a case-sensitive custom application shortname.

The example custom application ID '50001' used in this table corresponds to the custom application ID.

Issue Recommendation for Release 11i
The file $APPL_TOP/admin/xxcustprod.txt does not exist. Create or replace file $APPL_TOP/admin/xxcustprod.txt. The contents should be : 
%%% Single-product product data file format 11.5.A
xxcust 50001
END_OF_PRODUCT_ABBREVIATIONS -999
50001 xxcust XXCUST APP
No No No No
Yes Yes
50001 XXCUST XXCUST
0
1.0.0 1.0.0
none
none
none
none
END_OF_PRODUCTS
Release 11.5.0
11.5.0
R115 R115_ additional-this-mpl
XXCUST 11.5.0
END_OF_RELEASE 0.0.0
The file $APPL_TOP/admin/xxcustterr.txt does not exist. Create or replace file $APPL_TOP/admin/xxcustterr.txt with file : 
%%% Single-product territory data file format 11.5.A
R115
0 usaeng US AMERICAN EN US American_English
appltape.txt appltape.txt WE8ISO8859P1
Yes Standard Data_Group
none
none
none
none
none
c xxcust xxcust
END_OF_PRODUCT_NAMES
END_OF_LANGUAGE_INFO
The entry for xxcust is missing in FND_APPLICATION_TL Update FND_APPLICATION_TL with the following sql: 
INSERT INTO FND_APPLICATION_TL (APPLICATION_ID, LANGUAGE, APPLICATION_NAME,
CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
DESCRIPTION,SOURCE_LANG)
VALUES (50001, 'US', 'xxcust', 1000, sysdate, 1000, sysdate, 1000, 'xxcust', 'US');
The entry for product xxcust is missing from FND_PRODUCT_INSTALLATIONS Insert the information about product xxcust in FND_PRODUCT_INSTALLATIONS with following SQL: 
INSERT INTO FND_PRODUCT_INSTALLATIONS(APPLICATION_ID, 
ORACLE_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,
LAST_UPDATE_LOGIN,PRODUCT_VERSION,
STATUS,INDUSTRY,TABLESPACE,INDEX_TABLESPACE,TEMPORARY_TABLESPACE,SIZING_FACTOR,
INSTALL_GROUP_NUM,DB_STATUS,PATCH_LEVEL )
VALUES ( 50001, 50001, sysdate, 1000, sysdate, 1000, 1000, 
'11.5.0', 'I', 'C', <tablespace>, <index tablespace> ,<temporary tablespace>, 100, 0, 'I' , NULL );

Please replace <tablespace>, <index tablespace> ,<temporary tablespace> with appropriate values.
The database is missing user xxcust Create database user xxcust
Give appropriate grants to the user by running the necessary SQL statements:

  • grant create session, alter session to xxcust

  • grant create type to xxcust

  • grant create database link to xxcust

  • grant create any outline, alter any outline, drop any outline to xxcust

  • grant analyze any to xxcust

  • grant create sequence, create table to xxcust

  • grant create cluster to xxcust

  • grant CREATE TRIGGER to xxcust

  • grant create materialized view, query rewrite to xxcust

  • grant unlimited quota on all tablespaces with which user xxcust is associated.


Please use APPS_TS_TX_DATA as the main tablespace for user xxcust
Please use APPS_TS_TX_IDX as the index tablespace for user xxcust
The entry for product xxcust is missing from FND_ORACLE_USERID Insert entry for the product xxcust in FND_ORACLE_USERID with the SQL: 
INSERT INTO FND_ORACLE_USERID (ORACLE_ID,ORACLE_USERNAME,LAST_UPDATE_DATE,
LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,DESCRIPTION,
ENABLED_FLAG,READ_ONLY_FLAG,ENCRYPTED_ORACLE_PASSWORD,
CONCURRENT_BATCH_QUEUE_ID,INSTALL_GROUP_NUM) 
VALUES (50001, 'XXCUST', sysdate, 
1000, sysdate, 1000, 1000, 'XXCUST Account' , 'N', 'A', NULL, NULL, 0 );
Entry for the product xxcust in $APPL_TOP/admin/topfile.txt does not exist Edit $APPL_TOP/admin/topfile.txt to insert the given below entry at the end: 
xxcust <XXCUST_TOP>

Please replace <XXCUST_TOP> with appropriate value.
Environment variable XXCUST_TOP not defined Run AutoConfig to generate the environment variable XXCUST_TOP
Directory $APPL_TOP/xxcust/11.5.0 does not exist. Create directory $APPL_TOP/xxcust/11.5.0
Directory $APPL_TOP/xxcust/11.5.0/log does not exist. Create directory $APPL_TOP/xxcust/11.5.0/log
Directory $APPL_TOP/xxcust/11.5.0/out does not exist. Create directory $APPL_TOP/xxcust/11.5.0/out
Directory $APPL_TOP/xxcust/11.5.0/mesg does not exist. Create directory $APPL_TOP/xxcust/11.5.0/mesg
Directory $APPL_TOP/xxcust/11.5.0/sql does not exist. Create directory $APPL_TOP/xxcust/11.5.0/sql
Directory $APPL_TOP/xxcust/11.5.0/admin does not exist. Create directory $APPL_TOP/xxcust/11.5.0/admin
Directory $APPL_TOP/xxcust/11.5.0/admin/driver does not exist. Create directory $APPL_TOP/xxcust/11.5.0/admin/driver
Directory $APPL_TOP/xxcust/11.5.0/admin/sql does not exist. Create directory $APPL_TOP/xxcust/11.5.0/admin/sql
File $APPL_TOP/xxcust/11.5.0/admin/driver/xxcustfile.drv does not exist. Create file $APPL_TOP/xxcust/11.5.0/admin/driver/xxcustfile.drv with following contents: 
# Dummy xxcustfile.drv
File $APPL_TOP/xxcust/11.5.0/sql/XXCUSTNLINS.sql does not exist. Create file $APPL_TOP/xxcust/11.5.0/sql/XXCUSTNLINS.sql with following contents: 
commit;exit;
File $APPL_TOP/xxcust/11.5.0/admin/sql/XXCUSTNLADD.sql does not exist. Create file $APPL_TOP/xxcust/11.5.0/admin/sql/XXCUSTNLADD.sql with following contents: 
commit;exit;