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

Design Thinking in IT Development life cycle

Posted on December 12th, 2019 by Sanjit Anand ||Email This Post Email This Post

Here is question from a reader

Does integrate design thinking help into day to day operations of IT and Service Management ? Is there any frameworks or matured models of Design thinking embedded into development cycle?

Design thinking at its very core is about understanding your customer’s needs better than they can ever articulate it themselves. This results in discovering latent customer needs or sometime deep insights that can be used to reframe the problem of opportunity.

You can focus our Design Thinking efforts a couple of ways. here are few few thoughts:

  1. Use Design Thinking activities to get clarity around business need and drive innovative solutions. This often relates to Epics and helps prepare Features so that teams (especially developers and designers) can refine business priorities into their backlogs
  2. You can do Design Thinking work in the context of our Program Increments by fleshing out Feature level needs and having our UX designers engage on PI priorities
  3. We will run Design Sprints for new business solutions to support our (occasional) hypothesis driven development  

Posted in Tool | No Comments »

Oracle Adapters for Oracle Applications

Posted on July 7th, 2014 by Sanjit Anand ||Email This Post Email This Post

The Adapter for Oracle Applications provides comprehensive, bi-directional, multi-modal, synchronous and asynchronous connectivity to the Oracle Applications. The Oracle Applications Adapter provides the necessary infrastructure to integrate Oracle Applications with the rest of your extended enterprise.

Oracle E-Business Suite Adapter(Fig 1) is based on a set of standards such as J2EE Connector Architecture (J2CA), Extensible Markup Language (XML), Web Service Invocation Framework (WSIF), Web Service Inspection Language (WSIL), and Web Service Definition Language (WSDL). The support for standards facilitates interoperability and eliminates vendor lock-in.

Oracle Adapters for Oracle Applications

Please note that Adapter for Oracle Applications is also informally known as Oracle E-Business Suite Adapter.

Oracle E-Business Suite Adapter provides the following features:

  • It leverages the Integration Repository to provide the information from the source of truth on integration.
  • It supports the widest range of integration interface types. They are
    • PL/SQL APIs :Through database level APIs, tables,and views, users can produce or consume either synchronously or asynchronously to Oracle Applications
    • Business Events,
    • Open Interface Tables :Interface tables enable you to insert or update data into Oracle Applications
    • Concurrent Programs :Concurrent programs enable you to move data from interface tables to base tables or execute any application logic.
    • XML Gateway Interfaces :Oracle Applications provides several pre-seeded business object documents (BODs) that follow the Open Applications
      Group (OAG) standard. These out-of-the-box implementations of OAG BODs are tightly integrated with Oracle Applications ’s internal workflows and APIs
    • e-Commerce Gateway Interface :Oracle e-Commerce Gateway provides a common, standards-based approach for Electronic Data Interchange (EDI) integration between Oracle Applications and third party applications.
    • Interface Views :Interface views help you to retrieve data from Oracle Applications using the application tables
  • It generates adapter metadata as WSDL files with JCA extension.
  • It works under the securely configured connection between Oracle E-Business Suite and Oracle Fusion Middleware using just the FND User name and password for authentication.
  • It leverages and supports Oracle User Management function security feature to allow only authorized users to access and execute APIs that they are exposed as Web services to update Oracle E-Business Suit applications.
  • It implicitly takes care of applications context without bothering about the complexities of initiating the same explicitly.
  • It supports multiple languages and multiple organization access control (MOAC) setup.
  • It uses a JDeveloper based design-time tool for dynamically browsing the Oracle E-Business Suite application interfaces and configuring the adapter metadata. The design-time tasks are wizard driven, user-friendly, and intuitive providing superior user experiences.
  • It provides the global transaction control support implementing two-phase commit by leveraging the underlying JCA standards compliant framework.
  • It supports multiple versions of Oracle E-Business Suite from the same instance of Adapter at design time as well as run time.
  • It provides flexfield support for PL/SQL APIs and Open Interface Tables so that flexfield information can be displayed at design time and run time.

Usage Note

Support for various versions of Oracle E-Business Suite has the following conditions:

  • Adapter for Oracle Applications supports only those versions of Oracle E-Business Suite Release 11i which work with OWF.G.Rollup 7 applied.
  • Adapter for Oracle Applications version onwards supports Oracle E-Business Suite Release 12.0.
  • To enable the native Oracle E-Business Suite connectivity using J2EE data sources feature, the minimum requirement for Oracle E-Business Suite Release 11i is 11i.ATG_PF.H.Delta.6 (RUP6) and for Oracle E-Business Suite Release 12 is Release 12.0.4.

Posted in Tool | No Comments »

What if the EBS remained online during patching -> R12.2 The Downtime Solution – Online Patching

Posted on October 5th, 2013 by Sanjit Anand ||Email This Post Email This Post

Oracle E-Business Suite Release 12.2 introduces Online Patching (OLP) using the new adop (AD Online Patching) utility. This replaces adpatch , that means adpatch is no longer supported in R12.2 for direct use.

In 12.2 all patching operations are online, that means:

  • EBS will remain available to users during patching operations
  • Online users share resources for example Users can enter expense reports while Payables is being patched
  • Revenue generating activities were to stay online like Web Orders,Booking Orders,Service Requests
  • Downtime required by any patch was predictable
  • Patching CANNOT affect the running application
    • Data model changes (tables, indexes…)
    • Code changes ( pl/sql, views, c code, java code…)

This is DBA stuff, but in intrest of subject you can simply understand the Online Patching cycle consists of the following phases:

  • Prepare a virtual copy (patch edition) of the running application (run edition).
  • Apply patches to the patch edition of the application.
  • Finalize the system in readiness for the cutover phase.
  • Cutover to the patch edition and make it the new run edition.
  • Cleanup obsolete definitions or data to recover space.

The way it works is any patch application occurs on the Patch copy while users are accessing the Run Copy and performing routine transactions.

At one of the many phases of the adop utility called cutover, the application gets restarted and it changes the File System Role for Patch.

The Patch Copy becomes the run copy and the run copy becomes the patch copy . This is where you will require a few minutes of downtime, but is significantly less than the full downtime required to apply a patch or patches.

Business Benefits of Online Patching

  • Removes barriers to uptake
  • Much easier to negotiate downtime with lines of business
  • Much easier to identify downtime windows as they are so brief
  • Applications stays online during patch application

Therefore, Oracle E-Business Suite Release 12.2 Online Patching provides a smooth, predictable patching process that dramatically reduces maintenance downtimes while ensuring business continuity

You can refer to Metalink support note #1583902.1 on Online Patching FAQ

Posted in Tool | No Comments »

Newbie: I am very new to Workflows ..

Posted on May 10th, 2013 by Sanjit Anand ||Email This Post Email This Post

Reader Question: I am very new to Workflows (but have a Java/PL SQL background). Would you like some recommendations on Workflow books, Online Tutorials, best resources at Oracle site.

You can start reviewing the Oracle Work Administrators Guide, as first step.

I would suggest you to refer below Guides from Oracle E-Business Suite Online Documentation Library :

  • Oracle Workflow Administrator’s Guide
  • Oracle Workflow Developer’s Guide
  • Oracle Workflow User’s Guide

Then you can get workflow builder .

A good reference is: How To Download and Install the Latest Oracle Workflow Builder (Client Tool) and XML Gateway Message (Doc ID 261028.1)

Remember , Oracle Workflow Builder is the development tool that is designated to work only with Oracle Workflow.

Majority of time you have to work on customization therefore , recomendated to know the best practice.

You can refer to the Oracle Workflow Developer’s Guide and also understand the following topics in this regard:

  • Allowing Access to an Object
  • Preserve Customizations

Workflow version 2.6.x has been around for a long time , is the current version for EBS releases.

If you are working in R12 , and waht to know the changes in R12 for Workflow, you should refer the RCD on new changes in R12 for workflows.

Please download and review the below pdf documents which answers your questions (select the ‘Apps Technology Family RCD):

  • Oracle Application Object Library Release Notes, Release 12.1.1 (Doc ID 566521.1)
  • Release Content Documents for E-Business Suite Release 12 and 12.0.x Release Update Packs (Doc ID 404152.1)

You can refer these documents on for further reading:



Posted in Tool | No Comments »

Oracle Product Overview – VII : ( Data Quality)

Posted on January 19th, 2013 by Sanjit Anand ||Email This Post Email This Post

Data quality covers all processes and technologies to make sure all relevant information is complete and correct. For this, it is necessary to have a range of
controls from the point of data capture all the way to signing off the annual report.

Data quality management needs to be:

  • Preventive, having processes and systems that do not allow any data capture mistakes;
  • Detective, to check if this is the case, as one may not have control over all necessary data; and
  • Corrective, to make sure problems with data quality are solved.

Typically Requirement for any data quality software consist of these core functional requirements as:

  • Data profiling: assessing the data to understand its overall degree of accuracy
  • Data standardization : utilizing a business rules engine to ensure that data conforms to pre-defined quality rules
  • Generalized “cleansing“: The modification of data values to meet domain restrictions, integrity constraints or other business rules that define when the quality of data is sufficient for an organization.
  • Matching and Linking – Comparing data to align similar but slightly different records
  • Monitoring: Deploying controls to ensure that data continues to conform to business rules that define data quality for the organization.
  • Enrichment: Enhancing the value of internally held data by appending related attributes from external sources

1 Oracle Enterprise Data Quality

Helps organizations achieve maximum value from their business-critical applications by delivering fit-for-purpose data.

Enable individuals and collaborative teams to quickly and easily identify and resolve any problems in underlying data.

With Oracle Enterprise Data Quality products, customers can identify new opportunities, improve operational efficiency, and more effectively comply with industry or governmental regulation.

More details can be obtained from datasheet.

1 Oracle Hyperion Data Relationship Management enables your organization to proactively manage changes in master data across operational, analytical and enterprise performance management silos. Business users may make changes in their departmental perspectives while ensuring conformance to enterprise standards.

Whether processing financial information such as cost centers, accounts, and legal entities or analytical information such as members, dimensions, hierarchies, and their attributes, Oracle Hyperion Data Relationship Management delivers timely, accurate and consistent master data to drive ongoing operational
execution, business intelligence and performance management.

Posted in Tool | No Comments »

Oracle Product Overview -VI : ( Knowledge Management)

Posted on January 17th, 2013 by Sanjit Anand ||Email This Post Email This Post

Oracle’s products for knowledge management help users find useful knowledge contained in corporate information stores.

1 Oracle Knowledge for Contact Center

Oracle knowledge management capabilities are fully integrated with Siebel Contact Center for a one-stop solution that helps service organizations realize unprecedented levels of agent efficiency, accuracy, and consistency in every service interaction.

One-click intelligence built into the Siebel Contact Center interface offers agents immediate access to a full range of intent-based knowledge management capabilities

Data sheet for further reading.

1Oracle Knowledge for Web Self Service

Builds tools around social networking to enable customers and your organization to glean the best content from the user community on an ongoing basis.

Transform your customers’ self-service experience—increase online resolution rates, reduce calls into the contact center, and substantially reduce support costs

Oracle Knowledge for Web Self Service enables your organization to

  • Empower consumers to comment on the self-service experience in online surveys that capture content ratings and feedback
  • Connect customers with a wide range of opinions and ideas within interactive peer to peer discussion forums
  • Leverage community conversations in the knowledge
  • creation workflow to efficiently turn social discussions into reusable answers
  • Offer subscription services to deliver smart feeds of content that keep customers apprised of vital information
  • Tap into the next generation of service and leverage the power to build social reputations and new communities of experts

Data sheet for further reading.

Posted in Tool | No Comments »

Oracle Product Overview -V : ( Data Security)

Posted on January 17th, 2013 by Sanjit Anand ||Email This Post Email This Post

Oracle Advance Security

Helps customers address regulatory compliance requirements by protecting sensitive data on the network, on storage media and within the database from unauthorized disclosure.

Transparent Data Encryption provides the industry’s most advanced database encryption solution for protecting sensitive information without requiring changes to applications

Oracle Information Rights Management

A complete and effective information security solution must manage who has access to your data, regardless of where it is ultimately copied or forwarded.

Enables your business by extending security, control, and tracking beyond the organization’s network to remote user desktops, laptops, mobile wireless devices, and more.

Posted in Tool | No Comments »

Oracle Product Overview – IV : ( Data Discovery)

Posted on January 16th, 2013 by Sanjit Anand ||Email This Post Email This Post

Oracle Endeca Information Discovery

An enterprise data discovery platform for advanced, yet intuitive, exploration and analysis of complex and varied data.

Information is loaded from disparate source systems and stored in a faceted data model that dynamically supports changing data.

This integrated and enriched data is made available for search, discovery and analysis via interactive and configurable applications.

Enables an iterative “model-as-you-go” approach that simultaneously frees IT from the burdens of traditional data modeling and supports the broad exploration and analysis needs of business users

Posted in Tool | No Comments »

Oracle Product Overview – III : ( Data Integration)

Posted on January 15th, 2013 by Sanjit Anand ||Email This Post Email This Post

Oracle Data Integrator –

  • To be used for Bulk data
  • Helps lower total cost of ownership among data-centric architectures.
  • An easy-to-use interface combined with a rich extensibility framework helps improve productivity and lower development costs.
  • Fully integrated with Oracle Fusion Middleware, Oracle Database, and Exadata to put data at the center of your enterprise.
  • In addition, ODI is open and standards-based to work with 3rd party applications as well as Oracle’s applications.

Oracle Golden Gate

  • A high-performance software application for real-time transactional change data capture, transformation, and delivery, offering log-based bidirectional data replication.
  • The application enables to ensure that your critical systems are operational 24/7, and the associated data is distributed across the enterprise to optimize decision-making.

Posted in Tool | No Comments »

Oracle Product Overview – II : ( MDM)

Posted on January 13th, 2013 by Sanjit Anand ||Email This Post Email This Post

Oracle MDM Suite – These are the set of applications (MDM Hubs) designed to consolidate, cleanse, enrich, and synchronize these key business data objects across the enterprise and across time.

It includes pre-defined comprehensive data models with powerful applications to load, cleanse, govern and share the master data with all business processes, operational applications and business intelligence systems.

This includes following components –

  • Oracle Customer Hub (Siebel UCM) – Enables an enterprise to manage customer data over the full customer lifecycle.
  • Oracle Product Hub – Provids customers to centralize all product information from heterogeneous systems, creating a single product repository that can be leveraged across all functional departments. Details can be obtained at previous post
  • Oracle Site Hub – Delivers a competitive advantage in site-driven business decisions
  • Oracle Supplier Hub – Provides all the tools needed to onboard, evaluate, and manage suppliers across your trading lifecycle
  • Oracle Data Relationship Management – A powerful financial reference data master, with best in class hierarchy management capabilities, and a business user friendly enterprise dimension mastering tool with deep integration into Enterprise Performance Management (Hyperion)

Posted in Emerging Technologies, Tool | No Comments »

« Previous Entries