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

Oracle E-Business Suite 12.2 : NEW FEATURES

Posted on October 22nd, 2013 by Sanjit Anand ||Email This Post Email This Post

The general availability of the next release of Oracle Applications E-business Suite, Release 12.2, is on the horizon.Here is a quick summary of the some key changes and new features across different EBS modules that will be part of this release:

Top Enhancement across Product Families in R12.2


  1. Oracle E-Business Suite General Ledger Integration with the Fusion Accounting Hub
  2. Data Relationship Management (DRM) Integration with E-Business Suite
  3. Alternate Account UI
  4. Allocate Financial Data From One Or More Ledgers To A Different Target Ledger
  5. Journal Batch Copy
  6. New Web-based Account Analysis & Drilldown
  7. Flaggable As Non-Reversable Journal Sources


  1. Review and Manage Accounting Exceptions during Period Close
  2. Automate Auto Lockbox Processing
  3. Assign Customers to Unidentified Receipts using API
  4. Golden Tax Adapter Enhancement for Mainland China


  1. Standard Program to Update Employee Supplier bank account details from Payroll
  2. Global Per Diem and Mileage Rates
  3. Mileage Accumulation
  4. Automatic Matching of Advance Payments
  5. Flexible Application of Cash Advances
  6. Payment Holds and Automatic Notifications
  7. New Audit Expense Report
  8. Auto-Itemization of Expenses from Visa/AMEX
  9. Parallel Approvals
  10. New Header-level Document Attachments
  11. Support for new iOS/Android Mobile Expenses


  1. Updated Carbon Disclosure Project Report
  2. Enhanced Performance Dashboards
  3. Enhanced Key Performance Indicators


  1. Customer Tax Information Import
  2. New Condition Set Operator for Tax Rules


  1. Payment Acknowledgement Import


  1. No enhancements


  1. Enhanced Multi-Reporting Currency Functionality
  2. Improved Reporting and Analysis with Supporting References


  1. Enh. Mass Additions I/F for Legacy Conversions
  2. Automated Depr. Rollback for Selected Assets


  1. OM integration with Oracle Approvals Management (AME)
  2. Tax Calculation on Freight Charges
  3. Credit Tolerance for Honouring Manually Released Credit Checks Holds
  4. Support for Service as Promotional Goods
  5. Scheduling Enhancements
  6. Credit Card Authorisation Reversal
  7. Support for Assemble-To-Order (ATO) Items in Pick-To-Order (PTO
  8. Models and Kits
  9. Order Information Portal (OIP) Enhancements
  10. Support for Credit Hold Based on Bill To Customer
  11. Selling Services Enhancements
  12. User Defined Attributes (UDA)
  13. Support for Advanced Catch Weight
  14. Additional Business Events
  15. Order Management Productivity Enhancements


  1. Repository Contracts Enhancements
  2. UDA support for Deliverables
  3. MS Word 2010 Certification


  1. Service Item Support in Promotional Modifiers
  2. Support of Non-Continuous Price Breaks


  1. Integration to 3PLs or 3rd Party Distributed Warehouse Management System


  1. Workflow Synchronization
  2. Update Records with Future Person Changes
  3. Enhanced Key Performance Indicators


  1. Support for Parallel Approvals in SSHR
  2. Organization Chart
  3. Current Effective Date Appears on Initial Page
  4. Launch Actions from Side Navigator in Organization Chart or Talent Profile
  5. Control the Display of Effective Date, Review, and Confirmation Pages
  6. Use Quick Termination and Changing Hours Processes


  1. New Projects layouts for Actual Costing
  2. Attachments in Timecards
  3. Checkbox to Confirm Time Entry Accuracy


  1. Enhanced Retro Pay set as Default


  1. Multi Location Vacancy


  1. Use Star Ratings to Rate Performance and Proficiency Levels


  1. No enhancements


  1. No enhancements


  1. Apply Multiple Templates to a Sourcing or Purchasing Document
  2. API’s for Importing Templates, Rules, Questions and Constants
  3. New Clause Descriptor Field
  4. Clause Mandatory Attribute at Rule Level
  5. Clause Selection Placement by Contract Expert
  6. Deletion of Provisional Sections from Solicitation to Award
  7. Instruction Text
  8. Multi-Row Variables
  9. Display Clause Number and Sort by Clause Number
  10. Repository Contracts Configurability Enhancements
  11. UDA support for Deliverables
  12. MS Word 2010 Certification
  13. Contract Expert Performance Improvements


  1. Add Requisition lines to a Draft Negotiation (RFx & Auction)
  2. Response Withdrawal
  3. Track Amendment Acknowledgement
  4. Staggered Awards
  5. Import of Price Breaks
  6. Negative Cost Factors
  7. Sourcing API’s
  8. Online Discussion Attachments
  9. Terms and Conditions Controls
  10. Lot Price Summation


  1. Reclassify Historical Data
  2. Asynchronous Approval Flow
  3. Enhanced Training Data Upload
  4. Enhanced Tracking Capabilities
  5. Improvements in Analyzing Batches and Excel to Export
  6. Increased Flexibility in Resetting Data


  1. Standard Invoicing for Adjusted Transactions


  1. Labor Costing Enhancements
  2. Costing with HR Rates with Support for Multiple Rates per Employee
  3. New OTL Timecard Layout to Support Rate by Criteria
  4. Labor Costing using Payroll Actual
  5. Labor Costing Accruals
  6. Total Time Reporting for Exempt Employees


  1. Planning with HR Rates
  2. Updated Rates when Generating Forecast from the Workplan
  3. Planning without Resource Classes
  4. Planning by Cost Breakdown Structure


  1. No enhancements

You can refer to Metalink document id: 1302189.1

Posted in R12 | 1 Comment »

R12.2 :Online Patching requirements violations

Posted on October 12th, 2013 by Sanjit Anand ||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 ||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 »

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

Posted on October 11th, 2013 by Sanjit Anand ||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 »

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 »

Oracle Hyperion Tax Provision (HTP)

Posted on October 4th, 2013 by Sanjit Anand ||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 »

Ten Oracle cloud services announced at OpenWorld 2013

Posted on October 3rd, 2013 by Sanjit Anand ||Email This Post Email This Post

Do you know, this year at OOW13, Oracle announced 10 new Oracle Cloud services, including

  1. Compute Cloud: Enables customers to leverage elastic compute capabilities to run any workload in the cloud.
  2. Object Storage Cloud: Provides users with a highly-available, redundant and secure object store for persisting large amounts of unstructured data.
  3. Database Cloud: Provides full control of a dedicated database instance and supports any Oracle Database application, giving users flexibility and choice over the level of managed services provided by Oracle.
  4. Java Cloud: Provides Oracle WebLogic Server clusters for deployment of Java applications and gives full administrative control over the service with automated backup, recovery, patching and high-availability capabilities.
  5. Business Intelligence Cloud: Enables users to analyse data with visual, interactive dashboards for the web and mobile devices.
  6. Documents Cloud: Provides a flexible, self-service file-sharing and collaboration solution with mobile and desktop sync, robust security and integration with on-premises and cloud applications.
  7. Mobile Cloud: Simplifies enterprise mobile connectivity, enabling enterprises to build any application, for any device connected to any data source with enterprise-grade security.
  8. Database Backup Cloud: Enables businesses to back up Oracle Databases to the Oracle Cloud. Also allows replication of backups from the Oracle Database Backup Logging Recovery Appliance to Oracle Cloud.
  9. Billing and Revenue Management Cloud: Enables enterprises with robust and highly scalable subscription billing to capture recurring revenues from new services.
  10. Cloud Marketplace: Provides a global marketplace where partners can publish applications and customers can browse through and discover new solutions to address their business needs

Posted in Oracle Cloud * | No Comments »

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

Posted on October 1st, 2013 by Sanjit Anand ||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 »