Custom Top Automation Script
We had requirement to create a new custom top in a new instance. CUSTOM Top includes reports and shell scripts to be migrated into the new instance. Also we need to move the specific users with their responsibilities who will be accessing the CUSTOM Top.
Below program layout gives the flow of the shell script which needs to be executed in the destination instance.
Program Layout.
1. Get the apps credentials for logging into the database.
2. Create required directories for the custom TOP
3. Copy the relevant files into the custom TOP with necessary permissions.
4. Load the Application using FNLOAD program.
FNDLOAD $APPS_NAME/$APPS_PASSWORD 0 Y UPLOAD $FND_TOP/patch/115/import/afscapp.lct <<application_ldt_file>>
5. Load the Concurrent programs using FNLOAD program
FNDLOAD $APPS_NAME/$APPS_PASSWORD 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct <<concurrent_Program_ldt_file>>
6. Load the custom profiles if any...
FNDLOAD $APPS_NAME/$APPS_PASSWORD 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct <<profile_ldt_file>>
7. Load the custom request group
FNDLOAD $APPS_NAME/$APPS_PASSWORD 0 Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct <<custom_request_group_ldt_file>>
8. Load the custom Menu
FNDLOAD $APPS_NAME/$APPS_PASSWORD 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct <<Custom_menu_ldt_file>>
9. Load the custom responsibility
FNDLOAD $APPS_NAME/$APPS_PASSWORD 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct <<Custom_responsibility_ldt_file>>
10. Load the custom user
FNDLOAD $APPS_NAME/$APPS_PASSWORD 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct <<custom_user>>
11. Create Symoblic links for the shell programs if any
ln -s $FND_TOP/bin/fndcpesr <<shell_program>>
12. If there are any BI Reports then load the BI Definitions
FNDLOAD $APPS_NAME/$APPS_PASSWORD 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct
13. Load the templates for the corresponding BI Reports
java oracle.apps.xdo.oa.util.XDOLoader \
UPLOAD \
-DB_USERNAME $APPS_NAME \
-DB_PASSWORD $APPS_PASSWORD \
-JDBC_CONNECTION $HOST_NAME:$DB_PORT:$DB_SID \
-LOB_TYPE TEMPLATE \
-APPS_SHORT_NAME <<APPL_SHORT_NAME>> \
-LOB_CODE <<LOB_CODE>> \
-LANGUAGE en \
-TERRITORY 00 \
-XDO_FILE_TYPE RTF \
-FILE_NAME <<FILE_PATH>> \
-NLS_LANG AMERICAN \
-CUSTOM_MODE FORCE
15. Install PLSQL packages if any
sqlplus $APPS_NAME/$APPS_PASSWORD @<<SQL_FILE_NAME>>
We had requirement to create a new custom top in a new instance. CUSTOM Top includes reports and shell scripts to be migrated into the new instance. Also we need to move the specific users with their responsibilities who will be accessing the CUSTOM Top.
Below program layout gives the flow of the shell script which needs to be executed in the destination instance.
Program Layout.
1. Get the apps credentials for logging into the database.
2. Create required directories for the custom TOP
3. Copy the relevant files into the custom TOP with necessary permissions.
4. Load the Application using FNLOAD program.
FNDLOAD $APPS_NAME/$APPS_PASSWORD 0 Y UPLOAD $FND_TOP/patch/115/import/afscapp.lct <<application_ldt_file>>
5. Load the Concurrent programs using FNLOAD program
FNDLOAD $APPS_NAME/$APPS_PASSWORD 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct <<concurrent_Program_ldt_file>>
6. Load the custom profiles if any...
FNDLOAD $APPS_NAME/$APPS_PASSWORD 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct <<profile_ldt_file>>
7. Load the custom request group
FNDLOAD $APPS_NAME/$APPS_PASSWORD 0 Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct <<custom_request_group_ldt_file>>
8. Load the custom Menu
FNDLOAD $APPS_NAME/$APPS_PASSWORD 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct <<Custom_menu_ldt_file>>
9. Load the custom responsibility
FNDLOAD $APPS_NAME/$APPS_PASSWORD 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct <<Custom_responsibility_ldt_file>>
10. Load the custom user
FNDLOAD $APPS_NAME/$APPS_PASSWORD 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct <<custom_user>>
11. Create Symoblic links for the shell programs if any
ln -s $FND_TOP/bin/fndcpesr <<shell_program>>
12. If there are any BI Reports then load the BI Definitions
FNDLOAD $APPS_NAME/$APPS_PASSWORD 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct
13. Load the templates for the corresponding BI Reports
java oracle.apps.xdo.oa.util.XDOLoader \
UPLOAD \
-DB_USERNAME $APPS_NAME \
-DB_PASSWORD $APPS_PASSWORD \
-JDBC_CONNECTION $HOST_NAME:$DB_PORT:$DB_SID \
-LOB_TYPE TEMPLATE \
-APPS_SHORT_NAME <<APPL_SHORT_NAME>> \
-LOB_CODE <<LOB_CODE>> \
-LANGUAGE en \
-TERRITORY 00 \
-XDO_FILE_TYPE RTF \
-FILE_NAME <<FILE_PATH>> \
-NLS_LANG AMERICAN \
-CUSTOM_MODE FORCE
15. Install PLSQL packages if any
sqlplus $APPS_NAME/$APPS_PASSWORD @<<SQL_FILE_NAME>>
No comments:
Post a Comment