Are you aware, AIA Foundation Pack Reference Process Models combine Business and Technical View of Business Processes for Greater
IT and Business Alignment.

AIA creates and delivers the following types of models in html format:

• Reference Process Models (RPMs): Horizontal, functionally scoped business process models that depict all of the aspects of the
  processes supporting a particular function (Marketing, Sales, and Order Fulfillment, for example).
• Industry Reference Process Models: Industry-specific business process models that combine industry processes with relevant
  horizontal processes and variations of horizontal processes.
• Composite Business Flows: End-to-end processes that are comprised of parts of several functional business processes (Order
  to Cash, Procure to Pay, and Design to Release, for example).

Oracle Business Process Publisher is delivered along with each AIA product for customers to be able to view the read-only published set of
models.

The published models include hyperlinks to entries in OER where technical details are described for the AIA integration artifacts

• Navigation from RPMs to OER
• Enhanced Controlled Object Library
• Functional Allocation Diagrams
• L2 models annotated with EBS name
• L3 models annotated with EBS operation

What you expect from a Financial / Analytical MDM Products.

In simple way, it should Provides:

• Consistency of measures across all systems and all business units
• Streamlined consolidation and quick financial close
• Support for operational flexibility
• Rapid financial rationalization
• Ability to view structure changes during modeling
• Provide a historical perspective

Oracle Hyperion DRM

Oracle's Hyperion Data Relationship Management (previously known as Hyperion Master Data Management) provides enterprises a solution to build consistency within master data assets despite endless changes within the underlying transactional and analytical systems.

Specifically, Hyperion DRM provides the industry's first data model-agnostic master data management solution built to enable financial and analytical master data management in dynamic, fast-changing business environments

• Financial MDM
  Create an enterprise view of financial chart of accounts, cost centers and legal entities with a view to govern on-going financial management and consolidation based on consistent definitions of financial and reporting structures across general ledger systems, financial consolidation, planning and budgeting systems.
• Analytical MDM
  Create an enterprise view of analytical dimensions, reporting structures, performance measures and their related attributes and hierarchies using Hyperion DRM's data model-agnostic foundation. Construct departmental perspectives that bear referential integrity and consistency with master data constructs based on validations and business rules that enforce enterprise governance policies. Synchronize master data with downstream systems including BI/EPM systems, data warehouses and data marts to gain trustworthy insight.

Key Features

• Enterprise master data lifecycle & change management
• Cross-functional views reconciled to master record
• Automatic attribute management with business rules
• Drag-and-drop hierarchy management
• Referential integrity with synchronized records
• API for integrating changes with operational systems
• Comprehensive import, blend, and export functions
• Flexible versioning and modeling capabilities

Key benefits

• Save time and resources spent reconciling reports and measures across business units
• Reduce or eliminate errors in data flow between operational and analytical systems
• Maintain data integrity across divisions and systems
• Empower users to easily make data changes
• Minimize manual IT data maintenance tasks
• Perform reliable what-if scenarios and impact analyses
• Ensure consistent corporate definitions and metrics across the business

Oracle Application Testing Suite is an integrated, comprehensive Web application testing solution that provides all the tools you need to ensure the scalability and reliability of your business-critical applications.Typical component of this applications are:

• Oracle OpenScript is an updated scripting platform for creating automated extensible test scripts in Java.
• Oracle Functional Testing for Web Applications for automated functional and regression testing
• Job Scheduler for scheduling functional and regression testing
• Oracle Load Testing for Web Applications for load, scalability and stress testing. Oracle Load Testing for Web Applications also includes tools for server side monitoring and reporting.
• Oracle Test Manager for Web Applications for organizing and managing your overall testing process.

OATS Architectural can be best Understood as:

What comes in Oracle Application Testing Suite

OATS is a comprehensive, integrated testing solution that ensures the quality, scalability, and availability of your Web applications and Web Services.

There are three separately licensed products in the Oracle Application Testing Suite:

• Oracle Test Manager for documenting and managing the overall test process including test requirements, test cases and issues.
• Oracle Functional Testing for automating functional and regression testing of Web applications,packaged applications and Web Services.
• Oracle Load Testing for automated load testing of Web applications, packaged applications and Web Services.

The concept of Business Events in the context of EBS plays a critcal role in enabling event-driven integration with other systems outside the application.

In addition to that, the Business Events in E-Business Suite in particular allow for an exceptionally effective way of decoupling the standard product functionality, available out of the box, from client customizations that seek to adapt the standard product to meet customer-specific business needs. In other words, Oracle Applications developers should consider using Business Events whenever possible when configuring and customizing the standard products.

What are Business Events

“A business event is an occurrence in an internet or intranet application or program that might be significant to other objects in a system or to external agents.”

For example, the creation of a purchase order is an example of a business event in a purchasing application

Oracle Business Events =>Architecture

The Oracle Workflow Business Event System is an application service that leverages the Oracle Advanced Queuing (AQ) infrastructure to communicate business events between systems.

The Business Event System consists of the Event Manager and workflow process event activities

• Is available with both standalone and E-Business Suite Workflow
• Provides event driven processing
• Allows Application modules and external systems to raise events
• Facilitates Oracle Application modules and external system to subscribe to these events
• Subscriptions can be synchronous or asynchronous

Do you know,

• 11i10 E-Business Suite is preconfigured with 915 Business Events
  • Each Business Event represents a ready to use Integration or extension point
  • 915 Outbound Integration/extension points
  • 915 Inbound Integration/extension points
• Integration points centered around the major E-Business Suite flows like p2p, o2c etc

Component Architecture

Typically Business events Component can be best understood as:

Transactional Diagram of business Events can be best understood as:

Below is Architectural Diagram for Inbound Business Events , typical flow consist of

• Event Name
• Payload
• Event Parameter
• Unique Event Key (auto generated)

 

Below is Architectural Diagram for Outbound Business Events , typical flow consist of

• Creates deferred subscription to the selected
• Deferred subscription transfers the event to the customer queue (WF_BPEL_Q)
• Unique consumer is created automatically

Event Manager for Oracle Applications

The Oracle Workflow Event Manager lets you register interesting business events that may occur in your applications, the systems among which events will be communicated, named communication agents within those systems, and subscriptions indicating that an event is significant to a particular system. The Event Manager also performs subscribtion processing when events occur.

Subscriptions for Business Events

• Events that trigger custom code
• Events that send information to Workflow
• Events that send information to other queues or systems

where you can Uses of Business Events

• System integration messaging hubs
• Distributed applications messaging
• Message-based system integration
• Business-event based workflow processes
• Non-invasive customization of packaged applications

PLSQL vs Java Business Event System

Oracle Workflow provides Business Event System implementation within the database (PLSQL) and in the middle tier (Java).

The implementation is exactly the same in terms of the event subscription processing in both these layers but the only difference is how the Developer wants to leverage Business Event System's capabilities for event processing requirements.

With the availability of Business Event System implementation in PLSQL and Java, different subscription processing scenarios can be achieved.

How to Proceed if Business events are required to use

• Design your Business Event/s
• Define your event

Setting Up the Business Event System [Adopted workflow user documentation]

To set up the Business Event System and enable message propagation, perform the following steps:

1. If you want to communicate business events between the local system and external systems, create database links to those external systems.
2. If you want to use custom queues for propagating events, set up your queues.
3. Check the Business Event System setup parameters.
4. Schedule listeners for local inbound agents.
5. Schedule propagation for local outbound agents.
6. If you are using the version of Oracle Workflow embedded in Oracle Applications, synchronize event and subscription license statuses with product license statuses.
7. Ensure that the WF_CONTROL queue is periodically cleaned up to remove inactive subscribers.

For Creating a event in R11i or R12 you can refer to Oracle documentation .