Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

AIA :Reference Process Models

Posted on February 24th, 2012 by Sanjit Anand ||Email This Post Email This Post

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

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

Posted in Emerging Technologies | No Comments »

What is Oracle Hyperion’s Data Relationship Management (DRM) Tool?

Posted on February 14th, 2012 by Sanjit Anand ||Email This Post Email This Post

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

Posted in Hyperion | No Comments »

Oracle Application Testing Suite

Posted on February 11th, 2012 by Sanjit Anand ||Email This Post Email This Post

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.

Posted in Tool | No Comments »

Introduction to Oracle Procurement Contracts

Posted on February 11th, 2012 by Sanjit Anand ||Email This Post Email This Post

Oracle Procurement Contracts – creates and enforces better purchasing contracts throughout the enterprise while functioning as a key component of Oracle Advanced Procurement, the integrated suite that dramatically cuts all supply management costs

Procurement contracts play a critical role in all businesses. Companies rely on procurement contracts to define:

  • Specific products or services that they buy.
  • Contract terms governing their price, shipment, payment, quality, and other mutual obligations of the involved parties.

As we Know , Oracle Procurement supports the basic business processes of the procurement contract life cycle, whereas Oracle Procurement Contracts enhances the ability of buying organizations to manage these stages by adding sophisticated contract management and compliance features to Oracle Purchasing, Oracle Sourcing, and Oracle iSupplier Portal.

The Process Flow

The following overview diagram illustrates the Oracle Procurement Contracts features that support the various stages of the procurement contract life cycle

Oracle Procurement Contract

Key Features

Oracle Procurement Contracts supports all the stages of a complete contract life cycle. The key stages of the contract life cycle are:



  • Establish Contract Standards : You establish company-wide standards to manage your contracts by incorporating best practices that ensure all contracts are authored and executed based on approved legal and business policies and procedures.
  • Author Contracts : When you author contract terms, you leverage standard clauses, templates, and business rules set up in the library to define contractual obligations driven by legal and business requirements.
  • Negotiate Contracts : In this phase i.e during negotiation,
    • you create sourcing documents, such as RFIs or RFQs, with draft contract terms.
    • Suppliers review, respond, and may suggest changes to the contractual terms.
    • After all parties have reached agreement, and all sourcing documents have been submitted, an award is made.
    • You track and archive all interactions with the prospective sellers for retrieval in case of disputes.
  • Approve and Sign Contracts :Next step is Approval .
    • For the contract approval and signature process, you specify and communicate the guidelines to the concerned individuals in your organization, and you authorize who can sign the contracts in your organization
  • Execute and Monitor Contracts :As you execute the contracts, you capture transactional data to enforce the agreed upon contract terms.
    • The contracts are monitored to ensure that the contractual obligations, as defined in the contract terms, are fulfilled. Alerting and escalation mechanisms are defined and adhered to.
  • Administer Changes :You define a formal contract change request process for your organization and the supplier community.
    • Take a note , Amendments to contract terms are routed to designated individuals for approval. You keep track of the changes for audit trail purposes.
  • Renegotiate and Close Out Contracts :After all contractual obligations have been fulfilled or the contract has expired,
    • you can renegotiate the contract to obtain optimal market pricing, or you can decide to close out the contract.
  • Search Contracts : The Enterprise Contracts Search feature enables you to search for keywords and text in structured data (such as contract terms) and unstructured data (such as text contained in attached documents).
    • The search is performed for Oracle Purchasing, Oracle Sourcing, and Repository Contracts.

To support the Contract Lifecycle, Procurement Contracts has following key components:

  • Contract Terms Library
  • Contract Terms maintenance and approval
  • Deliverables
  • Contract Expert
  • Contracts Repository

Is Procurement Contract a separate module

Yes, This is seprate Module and Implementaion required some additional products

For all the features to function properly, Oracle Procurement Contracts requires installation and implementation of the following modules:

  • Oracle Purchasing: PO Module provides the backbone to author, approve, amend, communicate, and print contracts.
  • Oracle Contracts: This module provides contract terms library, contract document attachment, and contract terms authoring capabilities.
  • Oracle General Ledger: Basic setup for accounting come from here and enables set up of ledgers and books.
  • Oracle Human Resources: HRMS provides organization setup information.
  • Oracle Workflow: This Module Provides notifications related to approvals of clauses, templates, and contracts.
  • Oracle XML Publisher: Provides information on setting up and using RTF and PDF templates that are used to preview and print contracts and contract templates.

The following conditional dependencies provide additional functionality but are not required for Oracle Procurement Contracts to function:

  • Oracle Sourcing: Provides complete contract terms negotiation capabilities.
  • Oracle iSupplier Portal: Allows suppliers to view contract terms and request changes.
  • Oracle E-Record: Provides electronic signature capabilities to Oracle Procurement Contracts.

In Summary:
Procurement Contracts is a powerful tool that allows you to automate your Contract Management process and seamlessly integrate it with your Procurement process.


Standardise your process

  • Enforce policies
  • Eliminate sub-optimal contracts
  • Reduce exposure to unnecessary risk

Streamline your processes

  • Simplify contract creation
  • Streamline approvals
  • Streamline management of contracts

Allow your users to Comply with Flexibility

  • Visibility into contracts for key stakeholders
  • Enforce contract pricing and terms
  • Track internal and external compliance


  • All your information is in a single repository
  • Management reporting
  • Operational reporting

Posted in Oracle Purchasing | No Comments »

Business Events in Oracle Applications

Posted on February 2nd, 2012 by Sanjit Anand ||Email This Post Email This Post

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.

dgreybarrow 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

Business events

dgreybarrow 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

Business events1

dgreybarrow 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

dgreybarrowComponent Architecture

Typically Business events Component can be best understood as:

Business eventscomponents

Transactional Diagram of business Events can be best understood as:

Business events2

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

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

Business events3


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

Business events4

dgreybarrow 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.

dgreybarrow Subscriptions for Business Events

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

dgreybarrow 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

dgreybarrow 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.

dgreybarrow How to Proceed if Business events are required to use

  • Design your Business Event/s
  • Define your event

dgreybarrow 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 .

Posted in Oracle Application | No Comments »