While setting up
custom application top, one question usually is what should be the
directory structure for the top. In order for Oracle to read your files
correctly for execution, you need to follow the exact directory
structure which is used by Oracle for its own standard tops. Below
listed are the important directories from the same.
L1 APPL_TOP
L2 xxxx
L3 forms
L4 US (individual directories for each language. It holds .fmb files)
L4 BG
L4 etc..
L3 reports
L4 US (individual directories for each language. It holds .rdf files)
L4 BG
L4 etc
L3 bin (for storing shell scripts)
L3 resources (for storing plsql libraries)
L3 sql (for storing .sql files which are anonymous pl-sql blocks)
L3 admin
L4 import (for storing workflow files, rtf templates etc)
L4 sql (the files which needs to be compiled by DBAs upon deployment)
Other important pointers.
1. Executable files are usually stored on application servers except forms executable files which usually resides on database server.
2. all the files residing in admin/sql have no significance from operational processing, because these files are already compiled by DBAs when the codes are moved to an instance.
3. The shell scripts within the bin directory should have read and execute previlege for apps user, otherwise the concurrent programs will fail.
4. For various languages, Oracle has provided facility to put reports in different folders (eg. reports/US, reports/BG etc, but say if you are running a report from Bulgarian language login and if the report is not present in BG then it will pick up the default language report, which is usually reports/US). Ideally reports should be placed in different language folders only if they are different for different language, if they are same as English report then no point in keeping a separate file in language specific folder because it will increase maintenance efforts unnecessorily.
5. Exact top path can be found by looking at the .profile file which sets the parameters at the startup.
L1 APPL_TOP
L2 xxxx
L3 forms
L4 US (individual directories for each language. It holds .fmb files)
L4 BG
L4 etc..
L3 reports
L4 US (individual directories for each language. It holds .rdf files)
L4 BG
L4 etc
L3 bin (for storing shell scripts)
L3 resources (for storing plsql libraries)
L3 sql (for storing .sql files which are anonymous pl-sql blocks)
L3 admin
L4 import (for storing workflow files, rtf templates etc)
L4 sql (the files which needs to be compiled by DBAs upon deployment)
Other important pointers.
1. Executable files are usually stored on application servers except forms executable files which usually resides on database server.
2. all the files residing in admin/sql have no significance from operational processing, because these files are already compiled by DBAs when the codes are moved to an instance.
3. The shell scripts within the bin directory should have read and execute previlege for apps user, otherwise the concurrent programs will fail.
4. For various languages, Oracle has provided facility to put reports in different folders (eg. reports/US, reports/BG etc, but say if you are running a report from Bulgarian language login and if the report is not present in BG then it will pick up the default language report, which is usually reports/US). Ideally reports should be placed in different language folders only if they are different for different language, if they are same as English report then no point in keeping a separate file in language specific folder because it will increase maintenance efforts unnecessorily.
5. Exact top path can be found by looking at the .profile file which sets the parameters at the startup.
No comments:
Post a Comment