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

R12.2 :Online Patching requirements violations

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

As you know, one of the most significant new features of Oracle E-Business Suite Release 12.2 is Online Patching, which greatly reduces the periods of downtime needed when applying patches.

The two main requirements of online patching can be stated in two simple rules:

  • An online patch must not break the running application
  • The running application must not break the online patch

Therefore , its important to ensure custom code complies with the new standards that ensure the relevant database objects and code can successfully be patched online. These three utilities exist in R12.2 which helps you to cross check Online Patching requirements violations.

  • Online Patching Enablement Readiness Report, which checks the system's preparedness for Online Patching enablement.
  • Online Patching Database Compliance Checker (ADZDDBCC.sql), which reports database objects standards violations.
  • Global Standards Compliance Checker (, which scans the file system for source files that violate the standards.

The Online Patching Readiness Report can be run at any time before or after the upgrade to Release 12.2. This is particularly useful in checking for future violations

You can refer to the Release 12.2 Upgrade Guide and the Release 12.2 Developer's Guide for more information about these utilities

Posted in R12 | No Comments »

EBS R12.2 : Are you Considering Upgrading to Latest Technologies

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

1Which Release Should You Target?

Look for support Update and see where you are and which path is best for you.

Oracle support

Here is Support updates as of Sep 2013 of Four Versions

  • 11i: Extended Support stretched 25 months, through December 2015 as a “Sustaining Support Exception” [ as Indicated 1 above ]
  • 12.0.x: Extended Support ends January 2015
  • 12.1.x: Premier Support stretched 31 months, through December 2016; Sustaining Support stretched 12 months, through December 2019[ as Indicated 2,3 above ]
  • 12.2.x: Premier Support ends September 2018; Extended Support ends September 2021

1 Possible Paths

  • Fresh Install or Reimplementation, either you do with:
    • 12.1.3
    • 12.2 and apply 12.2.2
  • Upgrade : Direct upgrade path from EBS, 12.0.4 and 12.0.6 to 12.2
    • 11i (11.5.1 or better with baseline patch set)
      • Upgrade to 12.1.3
      • Upgrade to 12.2 and apply 12.2.2 RUP
    • 12.0.x
      • Upgrade to 12.1.3
      • Upgrade to 12.2 and apply 12.2.2 RUP
    • 12.1.3
      • Upgrade to 12.2 and apply 12.2.2 RUP

Patch Requirements for Extended Support of Oracle E-Business Suite Release 11.5.10 [ID 883202.1]

Posted in R12 | 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 |Print This Post Print This Post |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 »

Oracle E-Business Suite 12.2

Posted on September 27th, 2013 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Oracle has released E-Business Suite Release 12.2 on 19-Sept.

Key Highlights for R12.2

  • Significant enhancements across an integrated suite of business applications and new Online Patching capabilities .
    • Some of the Key Benefits of Online Patching are:
      • Easier to negotiate downtime with lines of business as minimal downtime is required (minutes vs. hours)
      • Easier to identify potential brief downtime windows, allowing for greater opportunities for patching during the work day
      • Applications stay online during patch application
      • Critical business operations are not impacted
    • This helps Oracle EBS 12.2 enables organizations to reduce planned maintenance times, make better decisions, reduce costs and increase performance.
    • Procurement and supply chain management professionals may benefit from Online Patching – a function aimed at support organizations with high-availability requirements. It is intended to reduce patching and maintenance downtimes.

  • In addition, Oracle E-Business Suite 12.2 leverages Oracle’s integrated technology stack, Oracle Fusion Middleware, to help drive efficiencies and improve the availability, performance and scalability of applications.

On technical side, Release 12.2 will replace Oracle Containers for Java (OC4J) 10g with WebLogic Server 11g and Database Tier will run RDBMS 11gR2 (or 11gR3 when available and certified) to support Online Patching

New Terminology you might came across in R12.2 is

  • AD Online Patching (ADOP)
  • Edition-Based Redefinition (EBR)

You can check it out the Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Documents [ID 1302189.1]

Ref : Oracle press release

Posted in News | No Comments »

Introduction : Oracle Supply Chain Event Management

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

Supply Chain Event Management (SCEM) is defined as an application supporting control processes for managing events within and between companies in real-time.

This integrated software functionality supports five major business processes including the ability to monitor what is happening within the supply chain, notify the right person in case of a delay or critical event, simulate activities, control your processes and measure your supply chain activities so that you can adapt your business process and make it more effective and efficient. In the graphic you see which core services exist in a SCEM system.

Through these services it is possible to receives updates to events and provides proactive alerts and responses to events throughout the supply chain.

You can take advantage of SCEM to support business in

  • Monitoring and Tracking our Supply
  • Sharing supply data globally
  • Notifying the right persons at the right time when an exception occurs.
  • Enabling event reporting

1Capabilities of SCEM Application

Helps monitor and track end-to-end business transactions in the Supply Chain by providing a unified view of the business transactions spread across heterogeneous systems.

  • Ability to monitor various notable events of a logical end to end transaction in multi-tiered supply chain including activities carried out by the supplier, carriers, to provide visibility beyond your department, beyond your company, to detect an exception and potentially automatically trigger a remedial action.
  • Ability to correlate various notable events in multi-tiered supply chain and raise alert for action if delay or non-occurrence of one notable event impacts future activities of the same or other multiple transactions.
  • Ability to view real-time auto-refreshed BAM dashboard showing progress and exceptions in color coded display of logical end to end transactions covering all notable events from begin to end throughout the supply chain.
  • Ability to trigger email notification based on actionable exception to the transaction occurring in-house processing or during the vendor side processing.
  • Allows real time detection and monitoring of business situations and exceptions from huge volumes of event data coming out of numerous sensors and systems, making it ideal for operation managers to quickly respond and take corrective actions.
  • Ability to subscribe to an external event streams such as traffic alerts, Sensors, RSS feeds, RFID feeds , synthesize and correlate that massive date with state of the transaction in the system to arrive at potential exception or an action.
  • Ability to identify trends and raise an actionable alert.
  • Ability to filter out routinely progressing events automatically, and focus only on exceptions thereby improving efficiency of Logistics staff.
  • Provides flexibility in modifying Alerts on a live production system without re-generation or re-deployment of the artifacts. Ability to declaratively change the recipient of the alerts/ notification

1Oracle BAM Dashboard tracks end-to-end Field Service process too:

  • My Oracle Support for issue capture
  • E-Business Suite for Field Service & Spares
  • Global Trade Management for export compliance
  • DHL to track part shipping logistics

1 SCEM architecture

Oracle Supply Chain Event Management (SCEM) architecture components are as follows

  • External Event Sources like B2B messages, Enterprise Event Sources like EBS, Fusion and other Enterprise Applications act as input sources.
  • Events relevant to the business process are defined in the Situation template, which are then processed in the mid tier by Oracle Event Processor (OEP).
  • Event Routers pick up the relevant events and get the payload associated with the events from the input systems and form the Logical Transaction Object which is cached using Coherence.
  • The Situation Processor, or the CEP component, applies the business rules to the stream of events and evaluates them e.g pattern matching, aggregation etc., and arrives at the situation to be monitored which has critical business impact.
  • The output (response) of the Situation Processor is sent to the Visualization layers such as BAM dashboards or mobile devices along with alerts and notifications

The current SCEM implementation uses the following Oracle components and technologies from Oracle Fusion Middleware (FWM):

  1. E-Business Suite R12.1.3+ (Business event source)
  2. Oracle Fusion Middleware 11g, ( PS5
    • Oracle Service-Oriented Architecture (SOA) 11g [SOA composites]
    • Oracle Event Processor (OEP) 11g [Processing events/logic]
    • Oracle Business Activity Monitor (BAM) [Optional: Presentation layer]
    • Oracle Coherence [Caching infrastructure]
    • Oracle TopLink [Persistence Modeling]
  3. Client technologies
    • Oracle JDeveloper 11g (PS5) [SCEM Designer - Design Time, customizations]
    • Eclipse IDE (Galileo) [Customizations - optional]

For more information on Oracle Supply Chain Event Management, check the details

Posted in Oracle Manufacturing | No Comments »

Understanding Time Zone Features in Oracle E-Business Suite 12

Posted on October 6th, 2012 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

One unique aspect of a global implementation is that multiple locations may use the same system at the same time.

What if , You need to implement Timezones for each Legal entity like US, UK, Singapore and China in your Global single Instance.

Business transactions need to be accounted for in the correct period, in particular for financial transactions such as invoicing, collections,
etc. In addition, global instances with locations in vastly different geographical regions need the ability to close each location at period end in their own time zone.Therefore , you need to have understanding for Time Zone Features in EBS R12.

Date Fields in Oracle E-Business Suite can be classified under these broad categories

Transaction Date

This is Typically Date/Time which are associated as a part of transaction creation or maintenance.

Typical example in EBS context are Transaction date, Order Date, Shipment Date, service order effective date etc.

Accounting Date This is Typically GL Date. This date determines which Accounting period the transaction Accounting period the should be booked in.
Server (database) Date

This is dates that are primarily used in Data base operations.

Such dates are typically user to capture as Creation Date,Last updated Date

Standard Oracle provides three Time Zone features that can be used:

Server Time Zone

This determines the date and time on which Database dates are determined

In absence of Legal Entity Time Zone or User Preferred Time zone set up, this is the default time zone on which all date fields are determined

Legal entity Time Zone This determines the Accounting Date for certain in-scope transactions related to Accounting
User Preferred Time Zone This determines the time zone displayed for in-scope Transaction Dates
you can check out these two easy refrence note for more insights.
  • Doc ID 402650.1 -UPTZ User-Preferred Time Zone Support in Oracle E-Business Suite Release 12
  • Doc ID 726851.1 -LETZ (Legal Entity Timezone)

Posted in AOL, Oracle Application | No Comments »

Oracle Big Data Appliance

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

Oracle offers a broad portfolio of products to help enterprises acquire, manage, and integrate big data with existing information, with the goal of achieving a complete view of business in the fastest, most reliable, and cost effective way .

Oracle's Big Data Appliance, and Oracle Big Data Connectors is one such solution and portfolio of products bundled together to provide an integrated solution. The good about Oracle Big Data Appliance comes with fact that the process of Acquire, Organize and Analyze work quite closely with their proven Oracle RDBMS technology and thus gives Enterprises flexibility to cover SQL and NoSQL (Key-Value store databases for unstructured, semi-structured data) within the horizon of their analytical needs.

The Oracle Big Data Appliance is an engineered system of hardware and software designed to help enterprises derive maximum value from their big data strategies. It combines optimized hardware with a comprehensive software stack featuring specialized solutions developed by Oracle to deliver a complete, easy-to-deploy offering for acquiring, organizing and analyzing big data, with enterprise-class performance, availability, supportability, and security.

The Oracle Big Data Appliance integrated software includes :

  • Full distribution of Cloudera's Distribution including Apache Hadoop (CDH)
  • Cloudera Manager to administer all aspects of Cloudera CDH
  • Open source distribution of the statistical package R for analysis of unfiltered data on Oracle Big Data Appliance
  • Oracle NoSQL Database Community Edition3
  • And Oracle Enterprise Linux operating system and Oracle Java VM

The Oracle Big Data Appliance offers the following benefits:

  • Rapid provisioning of a highly-available and scalable system for managing massive amounts of data
  • A high-performance platform for acquiring, organizing, and analyzing big data in Hadoop and using R on raw-data sources
  • Control of IT costs by pre-integrating all hardware and software components into a single big data solution that complements enterprise data warehouses

Oracle Big Data Connectors is an optimized software suite to help enterprises integrate data stored in Hadoop or Oracle NoSQL Databases with Oracle Database 11g. It enables very fast data movements between these two environments using Oracle Loader for Hadoop and Oracle Direct Connector for Hadoop Distributed File System (HDFS), while Oracle Data Integrator Application Adapter for Hadoop and Oracle R Connector for Hadoop provide non-Hadoop experts with easier access to HDFS data and MapReduce functionality.

Oracle Exalytics In-Memory Machine is purpose-built to deliver the fastest performance for business intelligence (BI) and planning applications. It is designed to provide real-time, speed-of-thought visual analysis, and enable new types of analytic applications so organizations can make decisions faster in the context of rapidly shifting business conditions, while broadening user adoption of BI though introduction of interactive visualization capabilities. Organizations can extend BI initiatives beyond reporting and dashboards to modeling, planning, forecasting, and predictive analytics.

These offerings, along with Oracle Exadata Database Machine and Oracle Database 11g, create a complete set of technologies for leveraging and integrating big data, and help enterprises quickly and efficiently turn information into insight.

More Information

Data sheets, white papers and other interesting information can be found here:

Posted in Emerging Technologies | No Comments »

What is Oracle Endeca Information Discovery?

Posted on February 6th, 2013 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Oracle with Endeca plans to create a comprehensive technology platform to process, store, manage, search and analyze structured and unstructured information together enabling businesses to make stronger and more profitable decisions.

Therefore, Oracle Endeca Information Discovery (Formerly Endeca Latitude) is an enterprise data discovery platform for rapid, intuitive exploration and analysis of data from any combination of structured and unstructured sources.

Oracle Endeca Information Discovery enables organizations to extend their existing business analytics investments to unstructured sources – including social media, websites, content systems, email, and
database text - providing unprecedented visibility into data and business processes, saving time and cost, and leading to better business decisions.

1 With Oracle Endeca Information Discovery, users can:

  • Easily combine structured and unstructured data and metadata to understand key metrics in their relevant context and evaluate new business situations.
  • Ask unanticipated questions of any data through intuitive, flexible, and highly interactive online discovery applications.
  • Mash up and recombine data and visualizations to compose discovery applications.
  • Leverage all of the rich metadata of existing Business Intelligence data models and semantic layers as a basis upon which to build discovery applications.
  • Unburden IT from the constant chasing of new requirements and non-traditional data sources for incorporation into the data warehouse, enabling them to deliver fast access to relevant data and selfservice to business users while maintaining security, governance, and quality.

1The Architecture for Oracle Endeca Information Discovery

Let’s start by briefly reviewing the Endeca Information Discovery architecture. The architecture consists of 3 main components:

  • Oracle Endeca Server. This hybrid, search/analytical database provides unprecedented flexibility in combining diverse and changing data as well as extreme performance in analyzing that data. Oracle Endeca Server has the performance characteristics of in-memory architecture however is not memory bound. Oracle Endeca Server is also used extensively as an interactive search engine on many major e-commerce and media websites.
  • Studio is a Discovery application composition environment for the Oracle Endeca Server. Studio provides drag and drop authoring to create highly interactive, visually-rich, enterprise- class information discovery applications.
  • Integration Suite. Oracle Endeca Information Discovery includes a set of tools used for loading and optionally enriching diverse information—including structured and unstructured content—into Oracle Endeca Server.

This can be best understood as fig 1 below:

Endeca Information Discovery architecture


Apart from this there are Extensible Value-Added Modules are

  • Oracle Endeca Content Management System Connectors- This add-on module allows for integration of content stored in various enterprise content management systems.This is currently supported systems include: EMC Documentum, EMC Documentum eRoom, FileNet P8, FileNet Document & Image Services, Interwoven TeamSite, Lotus Notes/Domino, Microsoft SharePoint, and OpenText LiveLink.
  • Oracle Endeca Text Enrichment. This add-on module includes text analysis capabilities for extraction of people, places, organizations, quotes, and themes as well as core summarization capabilities for automatic creation of abstracts or topical summaries.
  • Oracle Endeca Text Enrichment with Sentiment Analysis. This add-on module includes all of the Text Enrichment capabilities as well as advanced text analysis for extraction of aggregate sentiment related to each extracted concept. Sentiment is extracted with a score indicating the positive and negative nature of a document or an entity in the document. These scores can be used within the faceted search experience by varying ranges of
    positivity and negativity.

1 What type of analysis is Oracle Endeca Information Discovery designed for?

Oracle Endeca Information Discovery is in supporting a users’ need to better understand the data. In expanding analysis inputs beyond structured content to unstructured sources, users can better understand the color and qualitative insights which support quantitative results.

Oracle Endeca Information Discovery enables this type of analysis through Oracle Endeca Server, a hybrid search/analytical database that is specifically optimized for discovery, not reporting or online transaction processing.

Highly scalable, column-oriented, and in-memory - without being memory bound - Oracle Endeca Server supports navigation, search, and analysis of any kind of information including structured, semi-structured, and unstructured content.

This also provide a broad suite of packaged analytic applications to extend corporate business processes to include unstructured data

  • Integrate unstructured data into ERP, Supply Chain, Human Capital, CRM and EPM applications
  • Integrate unstructured data into specialized edge applications – PLM, MDM, Web Commerce, Analytic applications
  • Extend industry specific business processes and vertical applications to include unstructured data

1 Search capabilities of Oracle Endeca Information Discovery provide

Oracle Endeca Information Discovery provides two different, and complementary, types of search:

  1. Value – or dimension – search provides type-ahead autocompletion that enables users to find attribute values and help disambiguate queries by identifying which attributes contain the search terms.
  2. Record search provides advanced full text search across any single or combination of fields, leveraging a variety of configurable term matching and relevancy ranking algorithms to retrieve results for display and analysis.

1 Know the facts and dependecy with other Prducts

  1. Oracle Endeca Information Discovery part of Not of Oracle BI Foundation Suite, this is a separate licensed product.
  2. If you don’t run Oracle BI. You can still benefit from Oracle Endeca Information Discovery, beacuse the diversity of supported data sources is a strength of this product.
  3. Oracle Endeca Server exposes web services for querying existing BI tools.
  4. Oracle Endeca Information Discovery enhances existing business intelligence applications by extending analysis to unstructured sources and supporting exploratory data analysis.
  5. Oracle Endeca Information Discovery is certified on Exalytics.
  6. Oracle Endeca Information Discovery’s primary benefit with respect to Big Data (Read the previous post on Big data) is in solving the problem of Big Variety – relevant data sources for business analysis have never been more diverse, and an increasing share of this information is unstructured.
  7. Oracle Endeca Information Discovery and Hadoop are highly complementary technologies

1 Resources for Oracle Endeca Information Discovery (OEID)

Posted in Centrestage, Emerging Technologies | No Comments »

Where can I find the Oracle E-Business Suite Release 12.2 Documentation Library

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

Oracle E-Business Suite Release 12.2 Documentation Library? Click here..

ebs 12


  • EBS 12.1.x Info Center (Doc 806593.1)
  • EBS 12.2.x Info Center (Doc 1581299.1)


Posted in R12 | No Comments »

Oracle Hyperion Tax Provision (HTP)

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

Oracle Hyperion Tax Provision is a comprehensive, easy-to-use global tax provision solution that is purpose built for the automation of the accounting for income tax process. The Software is designed by tax users for tax users, and leverages the existing finance data and processes without impacting finance’s current financial close procedures.

The solution addresses both IFRS and US GAAP requirements, and includes tax maintenance wizards that are designed to be easily maintained by the tax department. Since Oracle Hyperion Tax Provision is architected on top of the Oracle Hyperion Financial Management (HFM) platform, both finance and tax can realize significant efficiencies in training both the casual and power users involved in the tax reporting process (e.g. regional controllers around the world and power users in the tax department).

Tax Provision calculates your company’s global tax provision, effective tax rate, and deferred tax for tax provisioning purposes. The application is designed to comply with the standards for accounting for income taxes under US GAAP ASC740 and IFRS IAS12.

Those who are not accounting background , can understand

A Tax Provision is…

  • a quarterly and annual disclosure (10Q & 10K)
  • a key part of the Financial Close
  • required for US GAAP & IFRS

Donot get confused with As Tax Provision is NOT…

  • a tax return
  • a requirement for the IRS (US), HMR&C (UK),
  • or other revenue agencies…

To summarize, The new Module encompasses all stages of the corporate tax provision process:

  • A tax provision calculation engine that addresses US GAAP, IFRS, and statutory tax reporting
  • A web-based tax package and integrated workflow for global data collection
  • Integrated with Oracle Hyperion Financial Managment, the solution that is based on the same technology trusted by thousands of corporate finance organizations.
  • An easy-to-use wizard for automation of tax differences
  • A comprehensive suite of tax reports for the consolidated tax provision - including the tax disclosure
  • Reconciliation of the tax accounts to the accounting data, and generation of the tax journal entry
  • A return-to-accrual process that integrates and enhances the tax compliance process
  • Configurable supplemental schedules to address unique data collection and calculation requirements

Why this software care about Tax?

  1. The Tax Provision is very material number
  2. It is a key part of the Financial Close (e.g. same value proposition)
  3. Replacing Excel
  4. The tax department is a new audience
  5. The Hyperion solution can have a material impact

Hyperion Tax Provision provides the tax department with the same strong data collection and management tools that the finance department is accustomed to. By providing the tax department with the same platform as is used by the finance department, the coordination between the two departments improves the financial close process, since the financial close cannot be complete without the tax close.You can get further details at Oracle site .

Installing Hyperion Tax Provision
The Hyperion Tax Provision requires, at minimum, Hyperion Financial Management Release with Patch Set Update:

Posted in Emerging Technologies, Hyperion | No Comments »

Customizations & Custom Application in Oracle E-Business Suite Release 12.2

Posted on October 1st, 2013 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

In EBS R12.2 installation now includes two editions (versions) of the application code and seed data.

The file system contains two complete copies of the Oracle E-Business Suite and technology files. In the database, we use the Edition-based Redefinition feature to create a new database edition for each online patching cycle.

The "Run Edition " is the code and data used by the running application. The Run Edition includes a complete application-tier file system along with all objects and data visible in the default edition of the database. As a developer, you will connect to the Run Edition whenever you are engaged in normal development activity on the system.

The "Patch Edition " is an alternate copy of Oracle E-Business Suite code and seed data that is updated by Online Patching. The Patch Edition includes a complete copy of the application-tier file system and editioned database code objects. The Patch Edition is only usable when an Online Patching session is in progress. End users cannot access the Oracle E-Business Suite Patch Edition, but as a developer you may need to connect to the Patch Edition of a system when applying patches or debugging problems with Online Patch execution.



Oracle Documentation strongly recomends, When installing or upgrading to Release 12.2, do not run adsplice until you have applied the 12.2.2 Release Update Pack. The execustion of adsplice before your instance is at the 12.2.2 code level may cause file synchronization issues.


  1. Download Patch 3636980 "Support Diagnostics (IZU) patch for AD Splice"
  2. Peform Pre-requisite steps
    • Manually copy the three .txt files from the 3636980\izu\admin directory to your own temporary directory.
    • Rename izuprod.txt to <CUSTOM MODULE>prod.txt. In this example, we will be using "xxshprod.txt".
    • Rename izterr.txt to <CUSTOM MODULE>terr.txt. In this example, we will be using "xxshterr.txt".
    • Open newprods.txt in a text editor.
    • Change all references of "izu" to <custom module> and all references of "IZU" to <CUSTOM MODULE>
    • In this example, we will be changing references of "izu" to be "xxsh" and "IZU" to be "XXSH".
    • Change all references of "izu" to <custom module> and all references of "IZU" to <CUSTOM MODULE> (keeping the case sensitivity).
    • Change all references to prodid 278 to your own unique number.
  3. Run adsplice -adsplice must be run from the admin directory under APPL_TOP, and is invoked by running the adsplice command.

In Oracle E-Business Suite Release 12.2, adsplice performs the following steps:

  • Makes the new user edition-enabled.
  • Enables Edition-Based Redefinition (EBR) for the custom objects.

All these changes will be synchronized between the “PATCH” and “RUN” file systems once the next Online Patching cycle is initiated .

If you upgraded your environment from an earlier release to Release 12.2, then you should run adsplice for your custom application again after the upgrade, using the same application ID and application name as when you originally added your custom application.

Running the Release 12.2 version of adsplice after the upgrade helps ensure that the custom top folder for your application will be included when the two file systems are synchronized during online patching.

special attention needed if you have Java specfic customization, in that case you need few more patched to apply.

Next you have to Verify Creation of Custom Product in the Database

Posted in Release12 | No Comments »

Introduction :Oracle Hyperion Tax Provision

Posted on September 23rd, 2013 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Until now, there was no easy way to integrate the tax provision with the financial consolidation. But, this all changes with the introduction of Hyperion Tax Provision. Hyperion Tax Provision represents the first in a series of products to better integrate tax reporting into the broader financial reporting process.

An integrated system for the Tax & Finance close means that you are leveraging your exiting investment & reducing risk - Hyperion Tax Provision leverages your existing investment in HFM and the Financial Close Suite by using the same tools for data collection, consolidation, and reporting to bring you an integrated Tax Provision solution.

arrow Hyperion Tax Provision is a comprehensive solution for the global consolidated tax provision.

This includes:

  • Data Collection:
    • Automated – any data that can be sourced from HFM, the general ledger, or sub-ledgers can be automatically available to the tax provision
    • Manual - The solutions includes a suite of web forms to collect tax provision details (incl. Current Tax, Temporary Difference Rollforward, tax losses & credits,etc)
  • Tax Provision Calculation:
    • Addressing both IFRS and US GAAP
    • Federal, State/Provincial, & International
  • Tax Reporting
    • Suite of out-of-box tax reports (incl. Current Tax, Deferred Tax, Effective Tax Rate Reconciliation, etc)
    • This also includes the same great reporting tools used by finance (such as Smart View & Financial Reporting)

arrowHFM & HTP Solutions - Architecture

Here is HFM & HTP solutioning Architecture .

HTP Solution

arrowMajor Key Benefits for HFM Customers

  • Increased Automation & Efficiencies:
    • Leverage the same data assurance process
    • Use the same chart of accounts & legal entity hierarchie
    • As much as 70% of the Tax Provision can be automated
  • Stronger Internal Controls
    • Closer alignment with the finance data & process
  • End to end auditable process
    • Improved Analysis & Reporting: resulting in better risk analysis and tax planning
    • Excel, Web Reports and Drill-through to G/L

In Nutshell the use of HFM for tax provision ensures that the Tax & Accounting Close are coordinated & efficient.

Bringing finance and tax together results in unparalleled Transparency & Reporting. The same reporting tools that you already use for financial reporting are now available for analysis of the Tax Provision.

Posted in Hyperion | No Comments »

What Is Oracle Instantis?

Posted on September 21st, 2013 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Oracle’s Instantis EnterpriseTrack is the leading, cloud-optimized enterprise project portfolio management (PPM) software used by IT and project
management offices (PMOs) to improve strategy execution and financial performance through better work and resource management. It provides an
end-to-end solution for managing, tracking, and reporting on enterprise strategies, processes, projects, programs, portfolios, products, resources, costs,
and benefits. Unlike competitive alternatives, Instantis EnterpriseTrack is easy to deploy quickly, easy to use and administer, and easy to afford.

Even before Gartner had a magic quadrant for cloud-based PPM products, Instantis was ranked the highest with a “strong positive” in 2011.

To follow, in both 2012 and 2013 Oracle Instantis has appeared in the leadership quadrant so consistently strong rankings for years now.This is the most recent quadrant from Gartner put out in May of this year.

The ORACLE-INSTANTIS-ENTERPRISETRACK system empowers IT and PPM/PMO leaders with the ability to:

  • Plan and execute multiple project portfolio types centrally
  • Manage demand and resource utilization across IT and other project portfolio types; and
  • Monitor, report and analyze project portfolio activity, status, and results metrics

More details can be obtained at here

Posted in News | No Comments »

Page 1 of 6712345678910111213...Last »

« Previous Entries