Skip to main content

PRODUCT DIRECTORY STRUCTURE in Oracle Apps






Oracle Applications installs in a machine it creates a base directory with the name ORACLE. This is the base directory for accessing the application.

Oracle Applications supplied in three flavors

1. Production Oracle Applications: used for implementing in any organization.

2. Vision Oracle Applications: used for Demonstration or Training purpose.



3. Test Oracle Applications: used for R&D purpose

Product Directory Structure of Oracle Applications

VISDB: Consists of Oracle 8i / Oracle 9i / Oracle 10g Database executable files.

VISORA: Captures 8.0.6 / 9iAS / 10giAS middleware Database executable files.

VISCOMM: Captures Control Script files, which are used to Start or Stop the
Application Services.

VISDATA: Captures all .DBF files.

VISAPPL: Captures all Module Specific Directories and Some Special Directories.




GL_TOP: (APPL_TOP/GL/11.5.0) is one of the Module Directory of Oracle Applications.It consists of a release directory (i.e. 11.5.0) under which Forms, Reports, BIN, LIB, SQL,etc.,

GL_TOP/11.5.0/Forms/US has formed directory to store all.FMX (Compiled) Form files of a specific module.

GL_TOP/11.5.0/Reports/US is a reports directory to capture all the.RDF (Compiled) Report files of a specific module directory.

The US is a language specific directory.

GL_TOP/11.5.0/BIN will capture the C, C++, PRO*C, SQL *LOADER etc., files.

GL_TOP/11.5.0/LIB will capture all.OBJ files of C, C++ or JAVA CLASS files.

GL_TOP/11.5.0/Message will capture all.MSB message body files.

GL_TOP/11.5.0/LOG will capture all.LOG files.

GL_TOP/11.5.0/OUT will capture all.OUT files.

GL_TOP/11.5.0/SQL will capture all .SQL script files.

GL_TOP/11.5.0/HTML will capture all .HTML, .HTM web files.

GL_TOP/11.5.0/FND is a Special Directory known as Application Object Library (AOL) directory. It is used to capture all Modules Application Executable Files.

GL_TOP/11.5.0/AU is an Application Utility (AU) Directory. It consists of an application release b‐Directory, which consists of Forms and Resource directories. It is used to store all.FMB and.PLL and PL/SQL Library files.

GL_TOP/11.5.0/AU/11.5.0/Forms/US will capture.FMB Form files of all Modules.

GL_TOP/11.5.0//AU/11.5.0/Resource is used to store.PLL and.PL/SQL Library files of Oracle Applications.



DATA MODEL
When we install Oracle Database by default system will create SYS and SYSTEM schemas. These consist of all Data Dictionary Tables. Like this, if we install Oracle Applications System will automatically create schemas of all Modules (i.e. GL, AR, AP, etc.) with the respective module name as User and Password. Along with these schemas some special Schemas i.e. APPS, APPLSYS, APPLSYSPUB will be created for the special purpose.


APPLSYS Schema: This is a special Schema consists of the files starts with FND, ALR, WF, and AD.

APPLSYSPUB Schema: This schema is a collection of public synonyms of all FNDTables, which are used for User verification. This is the Gate Way User ID of OracleApplications.

Note:
1. When we are changing the APPS Schema password, first we have to change in the backend for both APPS and APPLSYS Schemas.
2. Password for both APPS and APPLSYS should be same.
3. Change the password of both the Schemas in Front‐End and Back‐End.
4. Drop the Concurrent Manager Services and re‐create the Concurrent Manager
Service with the Password as APPS Password.


Labels:

Comments

Post a Comment

Popular posts from this blog

Error: - APP-PER-50022: Oracle Human Resource Could Not Retrieve a Value For The User Type Profile Option. Please ensure it is set property for your responsibility

Error: - APP-PER-50022: Oracle Human Resource Could Not Retrieve a Value For The User Type Profile Option. Please ensure it is set the property for your responsibility. Solution-:      (1)  Go to System administrator > Profile > System       (2) Now Search “ HR: User Type ” Profile option at Responsibility level with Respective Responsibility. And Click On FIND Button. Now Select HR: User Type Value “HR with Payroll User” (you can choose another option as well accordingly). And SAVE. Now check your responsibility, error removed. Go ahead with your next step and enjoy Oracle Apps. For More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide.
3 comments
Read more

Error "You have exceeded the transaction quantity". Precision Restriction for Quantity Field Up To 6 Decimal Places Performing Lot Receipts (Doc ID 464983.1)

Error "You have exceeded the transaction quantity".  Applies to:  Information in this document applies to any platform. FORM:RCVRCERC.FMB - Enter Receipts GUI FORM:RCVTXERT.FMB - Enter Receiving Transactions GUI FORM:RCVTXERE.FMB - Enter Returns GUI FORM:RCVTXECO.FMB - Enter Corrections GUI "You have exceeded the transaction quantity" Symptoms: "You have exceeded the transaction quantity" Note: Internal error message may indicate this message: INV_QUANTITY_TOO_BIG Steps: Go to Receiving Screen Enter the qty like 7200.00000489 (6 digits restriction makes it 7200.000005) Go to Lot/Serial form Enter lot number and qty as 7200.00001 (which was rounded to 5 digits) The message "you have exceeded the transaction quantity " Cause Can Be-: a) Restriction of precision support up to 6 decimal places was added for the quantity field  b) Comparing the transaction qty entered in receiving forms and the lot quantity entered in lot-entry form after rounding to...
Post a Comment
Read more

Script to insert on hand quantity in to MTL_TRANSACTIONS_INTERFACE

Script to insert on hand  quantity   into MTL_TRANSACTIONS_INTERFACE To insert on hand  quantity    into  MTL_TRANSACTIONS_INTERFACE INSERT INTO MTL_TRANSACTIONS_INTERFACE                             (     TRANSACTION_INTERFACE_ID,                    SOURCE_CODE,                             SOURCE_LINE_ID,                             SOURCE_HEADER_ID,                             PROCESS_FLAG,                             VALIDATION_REQUIRED,                             TRANSACTI...
Post a Comment
Read more