Online Oracle Apps DBA Training Course Part 2

Online Oracle Apps DBA Training

This is in continuation of the Online Oracle Apps DBA Training Course  Series

Online Oracle Apps DBA Training Course Part 1

Here  is  Online Oracle Apps DBA Training  Course Part 2 . I will be discussing Oracle Applications Technology LayerThe Oracle Applications technology layer lies between the Oracle Applications technology stack and the Oracle Applications product-specific modules. It provides features common to all Oracle Applications products.

Products in the Oracle Applications technology layer include:

Oracle Applications DBA (AD)
Oracle Applications Object Library (FND)
Oracle Applications Utilities (AU)
Oracle Common Modules (AK)
Oracle Workflow (WF)
Oracle Applications Framework (FWK)
Oracle XML Publisher (XDO)


Oracle Applications DBA (AD)

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

Various AD utilities are given below

AD Administration(adadmin) It helps in performing general maintenance tasks for Oracle Applications.
AD Merge Patch(admrgch) Merges multiple patches into a single, integrated patch
AutoConfig( Manages configuration changes in an Oracle Applications system
AutoPatch /adop(AD Onling Patching)


Applies patches and adds new languages and products to an Oracle. Adop is being used for R12.2 versions
Rapid clone[] Used to copy (clone) an Oracle Applications system.
Rapid Install Sets up a fully configured Oracle Applications system, including the latest certified technology stack and all patches, mini-packs, and other updates.


Oracle Applications Utilities (AU)

The Applications Utilities (AU) component is used to maintain the Oracle Applications system.

AU 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 require access to shared PL/SQL libraries, so these files are copied to AU_TOP as well.  We will take a look the structure of AU in latter part of the training


Oracle Application Object Library (FND)

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

Oracle Application Object Library offers many features to make system administration easier, such as security setup and maintenance, and management of concurrent processing and Printer setup.

AOL Feature for End user

Standard User Interface


Oracle Application Object Library supports the integration of Oracle Applications by providing standardized functionality and capabilities across all products so that the look and feel remains the same from product to product
Shared Flexfields value sets


Flexfields allow the entry of certain important information to be standardized across all products.
Standard Report Submission (SRS)


The procedure to submit a background report to the concurrent manager using SRS is the same, regardless of the product that owns the report. SRS takes advantage of shared flexfield value sets.


Applications Online Help


The presentation of Applications Online Help is also standardized across all products.

AOL Features for Developers

Every product requires some customization to extend the functionality to make it easier for Buisness.Oracle Application Object Library also provides capabilities for developers to extend the operation of Oracle Applications by allowing the creation of custom programs that interact with the base modules.


GUI and coding standards The same coding and Graphical User Interface (GUI) standards used by Oracle Applications developers are available for custom development.
Custom Menu and responsibilities Custom menus and responsibilities required for the business function can be seamlessly integrated with Oracle Applications.
Standard Report Submission Custom reports developed to extend functionality and required business function can be integrated into Standard Report Submission so that they can be submitted and monitored using the same procedures as other Oracle Applications reports  and developers can set up certain menus and responsibilities to access custom reports or standard objects.
Flexfields Flexfields used on custom forms can take advantage of existing flexfield capabilities such as value sets, validation, and security rules.
FNFLOAD AOL provides a generic loader FNDLOAD which can be used to load data from test to Production


AOL Features for System Administrators

Oracle Application Object Library provides many features to simplify administration of Oracle Applications, enabling the system administrator to carry out routine tasks quickly and easily.

Setup new users It allows to register new Oracle Applications users, and giving them access to only those Forms, functions, and reports they need to do their job.
Manage security Deciding which users have access to each product, and within a product, which Forms, functions, and reports a user can access
Auditing Monitoring what users do, and when, via comprehensive auditing capabilities
System and user profile Setting user and system profiles to modify the look and behavior of Oracle
Manage concurrent Processing Monitoring and controlling concurrent processing using interfaces such as Oracle Applications Manager (OAM).

Oracle Application Object Library Security

1) Authentication :Oracle Application Object Library controls access to the data in Oracle Applications via user sign-ons and responsibilities. Each user must have a valid user name and password to gain access to Oracle Applications. This is called Authentication process. We can seamlessly integrate various SSO tools to deliver the authentication process.

2) Authorization : 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. For example, responsibilities may be used to allow access to a specific product, ledger, operating unit, or to a restricted list of windows, functions, reports, and groups of products, or data groups.  This is called authorization

3) When you install Oracle Applications, a standard Applications user called SYSADMIN is created for you. Several default responsibilities are also created. Since the SYSADMIN sign-on is automatically assigned to the System Administrator responsibility, you can use SYSADMIN to create new user sign-ons and assign them to responsibilities. You can also create any custom responsibilities you need.

Various other users are created which help in many other tasks

Oracle Workflow (OWF)

Oracle Workflow delivers a complete workflow management system that supports business process based integration. It allows for the communication of data between the products

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

Oracle Workflow lets you model and maintain your business processes using a graphical workflow builder. You can model and automate sophisticated business processes, defining processes that can loop, branch into parallel flows and rendezvous, decompose into sub-flows, branch on task results, time out, and more.

Workflow Components

1) Oracle Workflow Builder provides a graphical drag and drop process designer. You can create and evolve business processes to incorporate existing business practices between your organization and customers or suppliers, without modifying existing business processes and without changing applications code.

2)  The Workflow Engine, embedded in the Oracle database, implements process definitions at runtime. The Workflow Engine monitors workflow states and coordinates the routing of activities for a process. Changes in workflow state, such as the completion of workflow activities, are signaled to the engine via a PL/SQL or Java API.

3) The Oracle Workflow Business Event System provides a workflow-enabled solution for your enterprise application integration requirements. The Business Event System is an application service delivered with Oracle Workflow that uses Oracle Advanced Queuing technology to communicate business events between systems.

The Business Event System uses Oracle Advanced Queuing to propagate messages between communication points on systems, called agents, using a specified protocol.

Oracle Common Modules (AK)

AK is an active data dictionary that enables you to define Oracle Applications

components for the HTML-based Applications, and generate many of the characteristics of Oracle Applications at runtime.

The Oracle Common Modules can be used to develop inquiry applications for the HTML-based Applications, without the need for any programming. They allow storage of language-translated labels for all the attributes on a transaction page, thus assisting with the provision of support for multiple languages.

For example, the AK Runtime Dictionary may be used to define an attribute or reusable component such as the customer name attribute, which can be reused any time a customer name field is displayed on an HTML page.


Oracle XML Publisher (XDO)

Oracle XML Publisher is a Java-based product based on the  Extensible Stylesheet Language (XSL). Specifically, XML Publisher utilizes the XSL-FO standard to transform XML data into a formatting object (FO). A formatting object contains both data and formatting information, and can be further transformed to an output format such as Portable Document Format (PDF).

XML Publisher uses data definitions and templates to produce output reports in the desired format. A data definition is a data source (or a combination of data sources) that either is XML or can produce XML. Examples include output from concurrent programs and Web services. A template is a report definition, which sets out how a report should look. The template layout can be user-specified. Supported templates currently include RTF, PDF Forms, and XSL.

The core components of XML Publisher are a Java-based set of publishing tools accessible via Java APIs from Oracle Applications or from any Java-based application.
FO Processor – The formatting object that results from the application of the XSL-FO template to the XML data is used by the FO Processor to generate the required output document. Currently the FO Processor only supports PDF as an output format; other formats such as HTML and RTF will be supported in future releases of XML Publisher.
PDF Document Merger – The PDF Document Merger accepts XML data and a PDF document as input, and uses a mapping between the XML and the fields in the document to merge the data into the PDF document.
PDF Form Processor – The PDF Form Processor is used to add attributes such as watermarks to a merged document.
RTF Template Parser – Report templates can be created in the Rich Text Format(RTF) document format, and converted to an XSL-FO format that can be applied to XML data.

I hope you will like the content for this part of Online Oracle Apps DBA Training.  Please do provide feedback