Monday 25 March 2013

Oracle APPS File Architecture

Each product (GL, Purchasing, Inventory, etc.) in an installation of Oracle Applications has an associated operating system directory.  All files required to install, upgrade, or run the product are stored in this directory (or related subdirectories).  Each product also has one or more database user accounts which own tables used by the product.  Application Object Library calls this collection of objects an application.

A set of customizations for one or more products is installed as an application.  Thus it has a product directory and an Oracle user account.

Directory Structure:

The directory structure for an installed product is as follows:

                                                                                        $APPL_TOP
                                                                                                                |
                                                                                                <product short name>
                                                                                                                |
                                                                                                <product version>
                                             ___________________________    |___________________________
                                             |             |            |             |             |             |             |             |             |           
                                                admin   bin   conversions  forms    log       out      reports       sql          wf        
                                                                             |                                                                              |
     _________________________                                                       ______
     |           |            |             |          |                                                   |           |
aropen    coa   customers   fa   pricelist                                             wft    sql

The directory structure for the custom development objects is as follows:

                                                                                        $APPL_TOP
                                                                                                                |
                                                                              (CUSTOM NAME)                     $(CUSTOM NAME)_TOP
                                                                                                                |
                                                                                                         1.XX
                                             ___________________________    |___________________________
                                             |             |            |             |             |             |             |             |             |           
                                                admin   bin   conversions  forms    log       out      reports       sql          wf        
                                                                             |                                                                              |
     _________________________                                                       ______
     |           |            |             |          |                                                   |           |
aropen    coa   customers   fa   pricelist                                             wft    sql

The product short name is a two to eight character abbreviation of the product (i.e. GL, PO, INV, etc.).  The short name for Rapid Oracle Implementation custom applications will be ‘(CUSTOM NAME)’.

The product version subdirectory level allows multiple versions of a product to be available within a single Applications installation.  The naming convention is <major version>.<minor version>.<patch level> (i.e. 4.1.0). The standard is to begin with 1.0.0 for a new product regardless of the general release number or Oracle Applications.

No comments:

Post a Comment