Oracle Apps 11i + R12 Concepts

The Oracle Applications technology layer lies between the Oracle Applicationstechnology stack and the Oracle Applications product-specific modules. It providesfeatures common to all Oracle Applications products.

The Applications DBA (AD) product provides a set of tools for administration of the OracleApplications file system and database. AD tools are used for installing, upgrading,maintaining, and patching the Oracle Applications system.

AK (Common Utilities) is an active data dictionary that enables you to define Oracle Applications components for the HTML-based Applications, and generate many of the characteristicsof Oracle Applications at runtime.The Oracle Common Modules can be used to develop inquiry applications for theHTML-based Applications, without the need for any programming. They allow storageof language-translated labels for all the attributes on a transaction page, thus assistingwith the provision of support for multiple languages.

AU(Application utilities) hosts a collection of files copied from other products. This allows generating on-site classes of files such as Forms and reports. Generating forms or reports may requireaccess to shared PL/SQL libraries, so these files are copied to AU_TOP as well.

Oracle Application Object Library (FND)
The Oracle Application Object Library is a key component of the Applications
technology layer. It consists of a collection of reusable code, programs, and database objects that provides common functionality across all products.

Responsibility
A responsibility is a level of authority in Oracle Applications that lets Applications users access only those functions and data appropriate to their roles in the organization.

Oracle Workflow (OWF)
Oracle Workflow delivers a complete workflow management system that supports business process based integration. Its technology enables modeling, automation, and continuous improvement of business processes, routing information of any type according to user-defined business rules. Oracle Workflow also provides an infrastructure for the enterprise-wide communication of data related to defined business events.

Read again...WF support Business process based integration, automation, routing of information as per user-defined rules and enterprise-wide data communication.

Directory structure in Oracle Applications R12

DB SERVER:
apps_st --(Data_top) (This has all the dbf’s)
tech_st -- 10.2.0 Home (Oracle Binaries)


APPS SERVER

Apps_st -- Appl_top(Oracle apps Product tops) && Common_top (Log, out, HTML files)

Tech_st -- 10.1.2 10.1.3 (Ora_home for tech stack)

The apps/apps_st/comn (COMMON_TOP) directory contains files used by manydifferent Oracle Applications products, and which may also be used with third-partyproducts.The admin directory, under the COMMON_TOP directory, is the default location forthe concurrent manager log and output directories.COMMON_TOP/html: The OA_HTML environment setting points to the html directory. The Oracle Applications HTML-based sign-on screen and Oracle HTML-based Applications HTMLfiles are installed here. The html directory also contains other files used by theHTML-based products, such as Java Server Page (JSP) files, Java scripts, XML files, andstyle sheets. Typically, the path will look like:/appmgr/apps/apps_st/comn/webapps/oacore/html. Two newsubdirectories are META-INF and WEB-INF, introduced to meet J2EE specifications.
The java directoryRelease 12 introduces some significant changes to the locations in which the varioustypes of Java files are stored. Rapid Install installs all Oracle Applications class files inthe COMMON_TOP/classes directory, pointed to by the $JAVA_TOP environmentvariable. Zip and jar files are installed in the $COMMON_TOP/lib directory, pointed toby the $AF_JLIB environment variable (introduced with Release 12). The top-level Javadirectory, $COMMON_TOP/java, is pointed to by the $JAVA_BASE environmentvariable.
# APPLTMP is the directory in which Oracle Applications# temporary files are created.#
APPLTMP="/apps/xxx/xxxcomn/temp"export APPLTMP
## APPLPTMP is the directory in which PL/SQL output files are created.#
APPLPTMP="/apps/xxx/xxxdb/9.2.0/temp/xxx_essdbpu41"export APPLPTMP
APPLCSF is the top-level directory in which the Concurrent Manager# puts log and output files.
FNDNAM is the name of your AOL schema.
GWYUID is the schema name and password for your public schema.
# National Language Support environment variables#
NLS_LANG="American_America.UTF8"export NLS_LANG
NLS_DATE_FORMAT="DD-MON-RR"export NLS_DATE_FORMAT
NLS_NUMERIC_CHARACTERS=".,"export NLS_NUMERIC_CHARACTERS
NLS_SORT="binary"export NLS_SORT
# Add perl from the iAS location to the PATH and set PFER5LIB for Perl
Get customer-defined environment variable settings#. /apps/xxx/xxxappl/admin/adovars.env
The main applications environment file, called .env on UNIX,and .cmdon Windows.
The consolidated environment file, called APPS.env on UNIX,and APPS.cmd on Windows.
CONTEXT_NAME is the Applications context, Its default value is _.
APPSORA.env or APPS.env are both consolidated env files which calls the 8.0.6 env, CONTEXT_NAME.env files together with the custom environment env files.
There is also the file $APPL_TOP/admin/applsum.txt, applptch.txt which is more of a summary of the same information
To get the complete patch details for patches applied in Dec 2000$ cd $AD_TOP/patch/115/sql$ sqlplus /SQL> @adphrept.sql 3 ALL ALL 12/01/00 12/31/00 ALL ALL ALL ALL ALL N N N N N
$AD_TOP/sql/adcompsc.pls apps apps PA (This will compile all the objects in Apps starting with PA% alter java class “/584c2e1f_FunctionManager1” compile;
If you have invalid SYSTEM or SYS objects you can use $ORACLE_HOME/rdbms/admin/utlrp.sql to compile just these invalid objects
$ adpatch apply=no
$ adpatch preinstall=y
$ adpatch options=nogenrep,nogenrpll

Following are some examples of commands in a ‘g’ driver. Once again, remember that
· The .fmb files are stored in $AU_TOP, and when generated the executable (.fmx) is stored under the product.
· The .pll is stored under $AU_TOP, and when generated the executable (.plx) is also stored under $AU_TOP
CONCURRENT MANAGER
If the ICM should go down, you can restart it with 'startmgr'. You do not need to kill the other managers first
FND_COCNURRENT_PROCESSES and FND_CONCURRENT_QUEUES, FND_CONCURRENT_REQUESTS FND_CONCURRENT_PROGRAMS update fnd_concurrent_requestsset status_code='X', phase_code='C'where status_code='T';If a priority is not set for a request, it will have the same priority as all other requests, or it will be set to the value specified in the user's profile option Concurrent:Priority.
The fnd (Application Object Library) directoryThis directory and its subdirectories contain the scripts and programs that are used asthe foundation for all Applications products to build data dictionaries, forms and Cobject libraries.
Most temporary files are written to the location specified by the APPLTMPenvironment setting, which is set by Rapid Install.Applications also produces temporary PL/SQL output files used in concurrentprocessing. These files are written to a location on the database server node specified bythe APPLPTMP environment setting. The APPLPTMP directory must be the samedirectory as specified by the utl_file_dir parameter in your database initialization file.
The adovars.env fileThe adovars.env file, located in $APPL_TOP/admin, specifies the location of variousfiles such as Java files, HTML files, and JRE (Java Runtime Environment) files. It iscalled from the main applications environment file, .env.