This appendix covers the following topics:
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.
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:
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 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.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 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; |