Oracle Applications DBA Concepts

The blog is about daily activities of Oracle Apps DBA and Fusion Middleware Administrators. I use this blog to share my knowledge in Oracle Applications administration, Fusion Middleware administration, troubleshooting tips.

Pages

Sunday, August 06, 2017

Edition Based Redefinition (EBR) is a new feature introduced from Oracle Software Version 11g R2.Edition-based redefinition allows multiple versions of PL/SQL objects, views and synonyms in a single schema.This feature facilitates Online patching of database objects in R12.2 online Patching.

Editionable and Non-editionable Objects

Below schema object types are editionable in the database:

SYNONYM

VIEW

SQL translation profile

All PL/SQL object types:

FUNCTION

LIBRARY

PACKAGE and PACKAGE BODY

PROCEDURE

TRIGGER

TYPE and TYPE BODY

If a schema object type is editionable in the database, then it can be editionable in schemas.All other schema object types are noneditionable in the database and in every schema, and objects of that type are always noneditioned. Tables are always noneditioned objects.

To view the editions related information in the database, use the below datadictionary tables.

DBA_EDITIONS: SELECT * FROM dba_editions;

DBA_OBJECTS_AE: DBA_OBJECTS_AE view shows all objects, of all editions.

MMON (Manageability Monitor)MMON (Manageability Monitor) is a background process introduced in Oracle 10g. It gathers memory statistics (snapshots) and stores this information in the AWR (automatic workload repository). MMON is also responsible for issuing alerts for metrics that exceed their thresholds.

Steps to compile forms in Oracle Applications Release 12.1.x and 12.2.xLogin to Application Tier node as applmgr userChange to $AU_TOP/forms/USExecute the Below command to generate form files.frmcmp_batch userid=apps/<password> module=formname.fmboutput_file=$PROD_TOP/forms/US/<name>.fmx module_type=form batch=no compile_all=specialAfter execution of the above command, verify there are no compilation errors in output displayed and the fmx is created succesfully.

Steps to compile forms in Oracle Applications Release 11iLogin to Application Tier node as applmgr userChange to $AU_TOP/forms/USExecute the Below command to generate form files.f60gen module=$AU_TOP/forms/US/<custom_form>.fmb userid=apps/<passwd> output_file=$PRODUCT_TOP/forms/<customformname>.fmx module_type=form compile_all=yesTips:Use command "f60gen help=y" or "frmcmp_batch.sh help=y" to find the optional parameters.Using Compile_all= yes changes cached version in the source file in addition to compiling pl/sql in the utput fmx file.

Tuesday, July 25, 2017

FNDLOAD (Generic Loader) is a concurrent Program which is used to move metadata between database and text file representations.The loader reads a configuration file to determine what data to access.

FNDLOAD can download data from an application entity into a portable, editable text file. This file can then be uploaded into any other database to copy the data. Conversion between database store and file format is specified by a configuration file that is read by the loader. FNDLOAD downloads data from a database according to a configuration (.lct) file, and converts the data into a data file (.ldt file). FNDLOAD can then upload this data to another database using a configuration file.

The loader operates in one of two modes: download or upload. In the download mode, data is downloaded from the database to a text file; in the upload mode, data is uploaded from a text file to the database.