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 12.2.

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.

Example Issues Discovered During Validation
Issue Recommendation for Release 12.2
The file $APPL_TOP/admin/xxcustprod.txt does not exist. Create or replace file $APPL_TOP/admin/xxcustprod.txt. The contents should be: 
xxcust 50001
END_OF_PRODUCT_ABBREVIATIONS -999
50001 xxcust XXCUST APP
No No No No
Yes Yes
50001 XXCUST DEFAULT
0
1.0.0 1.0.0
none
none
none
none
END_OF_PRODUCTS
Release 12.0.0
12.0.0
R120 R120_ additional-this-mpl
# list of products and versions
XXCUST 12.0.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 12.0.A


#
# Release abbreviation
# 10.7 - R1107, 11.0 = R11.0.28, 11.5 = R115
R120
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
#
# You may specify info for other languages here, but usually you will
# not need to do this.
#
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 using the 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,
'12.0.0', 'I', 'C', <tablespace>, <index tablespace>, <temporary tablespace>, 100, 0, 'I' , NULL );

Please replace <tablespace>, <index tablespace> , and <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 sessionto 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 clusterto 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_USERIDwith the following 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 );
The entry for the product xxcust in $APPL_TOP/admin/topfile.txtdoes 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 the appropriate value.
The environment variable XXCUST_TOP not defined Run AutoConfig to generate the environment variable. XXCUST_TOP.
The directory $APPL_TOP/xxcust/12.0.0 does not exist. Create directory $APPL_TOP/xxcust/12.0.0.
The directory $APPL_TOP/xxcust/12.0.0/log does not exist. Create directory $APPL_TOP/xxcust/12.0.0/log.
The directory $APPL_TOP/xxcust/12.0.0/out does not exist. Create directory $APPL_TOP/xxcust/12.0.0/out.
The directory $APPL_TOP/xxcust/12.0.0/mesg does not exist. Create directory $APPL_TOP/xxcust/12.0.0/mesg.
The directory $APPL_TOP/xxcust/12.0.0/sql does not exist. Create directory$APPL_TOP/xxcust/12.0.0/sql.
The directory $APPL_TOP/xxcust/12.0.0/admin does not exist. Create directory$APPL_TOP/xxcust/12.0.0/admin.
The directory $APPL_TOP/xxcust/12.0.0/admin/driver does not exist. Create directory $APPL_TOP/xxcust/12.0.0/admin/driver.
The directory $APPL_TOP/xxcust/12.0.0/admin/sql does not exist. Create directory $APPL_TOP/xxcust/12.0.0/admin/sql.
The file $APPL_TOP/xxcust/12.0.0/admin/driver/xxcustfile.drv does not exist. Create file $APPL_TOP/xxcust/12.0.0/admin/driver/xxcustfile.drv with the following contents: 
#
# Dummy xxcustfile.drv
#
#

xxcustlogdirectory
xxcustoutdirectory
xxcustmesgdirectory
xxcustsqlXXCUSTNLINS.sql
xxcustadmin/sqlXXCUSTNLADD.sql

#
# End of dummy xxcustfile.drv
#
The file $APPL_TOP/xxcust/12.0.0/sql/XXCUSTNLINS.sql does not exist. Create file $APPL_TOP/xxcust/12.0.0/sql/XXCUSTNLINS.sql with the following contents: 
rem
rem Dummy XXCUSTNLINS.sql
rem
rem

Exit;
The file $APPL_TOP/xxcust/12.0.0/admin/sql/XXCUSTNLADD.sql does not exist. Create file $APPL_TOP/xxcust/12.0.0/admin/sql/XXCUSTNLADD.sql with the following contents: 
rem
rem Dummy XXCUSTNLADD.sql
rem
rem

Exit;