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:
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; |