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 : Transforming EBS Financials with Fusion Accounting Hub

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

In R12.2 , there is one important enhancement which transform EBS Financials with Fusion Accounting Hub.

The Oracle Fusion Accounting Hub provides integration for the Oracle General Ledger .

This new enhamcement in term of integration provides you with the opportunity to leverage the Oracle Fusion Accounting Hub with minimal implementation effort and without disruption to your current financial management processes.

You can continue to use Oracle E-Business applications without disruption and you can also continue to account for transactions in Oracle General Ledger without changing their accounting treatments.

Integration between the Oracle Fusion Accounting Hub and Oracle General Ledger includes the ability to transfer full or incremental period balances to the Fusion General Ledger.

You can convert charts of account values and accounting period information to align with Fusion ledger configurations. You can also drill from the summary information posted in the Fusion Accounting Hub back to the Oracle E-Business Suite (EBS).

Integration with the Fusion Accounting Hub enables users to leverage new fusion general ledger capabilities, such as embedded ESSBASE (Extended Spreadsheet DataBASE) integration with real-time analytics, on-line slice-and-dice account analysis, making it easier to run boardroom financial reports, helping generate the boardroom financial reports with great ease.

Posted in Hyperion, R12 | No Comments »

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 »

API than can be used to load Journals into Subledger Accounting (SLA)

Posted on August 6th, 2011 by Sanjit Anand ||Email This Post Email This Post

Oracle provides the ability to enter manual sub-ledger journals via a button on the SLA Journal Inquiry pages.

A manual subledger journal entry is not associated with a transaction or document of a subledger application. If you are considering using the manual SLA journal feature to represent accounting in legacy systems, you can take the advantage of API which allows you to import such transactions into SLA rather than into the GL directly (via the GL interface).

You can use the API XLA_JOURNAL_ENTRIES_PUB_PKG and any of these functions:

  • Create_Journal_Entry_Header: This is used creates a new subledger journal entry header
  • Update_Journal_Entry_Header: This is used to modifies an existing manual subledger journal entry header, if journal entry is not Final and GL_DATE used must belong to a valid accounting period.
  • Delete_Journal_Entry:This deletes all information of a subledger journal entry including journal entry header and journal entry line
  • Create_Journal_Entry_Line:This is used to Create the JE line
  • Update_Journal_Entry_Line :This is used to Delete the JE line
  • Delete_Journal_Entry_Line :This is used to Delete the JE line
  • Complete_Journal_Entry: This is used to completes a subledger journal entry
  • Reverse_Journal_Entry : This is used to reverse the entry.

These API’s you can find more on Oracle Financial Services Accounting Hub Implementation Guide Release 12 Part No. B14420-01

You don’t need to have an FSAH License to be able to use those APIs.

Posted in R12, Subledger Accounting | 1 Comment »

EBusiness Suite : Oracle Channel Revenue Management

Posted on April 9th, 2011 by Sanjit Anand ||Email This Post Email This Post

Do you know, In Release 12.1 Trade Management is now a suite of four products as below in a new product family called Oracle Channel Revenue Management that manages financially oriented channel processes.

  1. Accounts Receivable Deduction Settlement
  2. Advanced Rebates and Point of Sale Management
  3. Price Protection [This is new product in R12.1]
  4. Supplier Ship and Debit [This is new product in R12.1]

Adding these Products in Line of your Business will help you to :

  • Decrease in Deductions DSO and improved visibility into all processes
  • Improved Margins through process automation and accuracy with an integrated solution
  • Increased productivity through automation of traditional spreadsheet managed processes
  • Reduced revenue leakage

Typically these products are best suited for industry like High Tech, Life Sciences/HealthCare, Wholesale/Retail, that application are best suited if you are considering for “Invoice to Settlement” Business flow.

Lets have a brief introduction for these family products.


This provides a central repository of all claims and deductions to claim analysts, giving them easy access to the information they need to resolve claims quickly, and to give management full visibility into outstanding claims and deductions. It integrates resolution of deductions and claims with receivable systems and accounts payable and validates that the correct general ledger accounts are assigned. Properly approved claims automatically spawn payments and credits in Oracle Payables and Oracle Receivables.

Some of key functionality for this products are :

  • Dispute/deduction handling
  • Rebates Settlement
  • Promotional Payments View
  • Complete AR processing that means you get high visibility into aging buckets and total amounts outstanding
  • Lockbox integration additional you have customer reason code mapping
  • Auto-write offs
  • Mass Settlements

This application is have Integration with Accounts Receivables, Accounts Payable, Order Management, General Ledger, Channel Rebate and POS Management ,Tax Engine and Oracle Collection.

Those who have high transactional volume of invoicing and disputes and currently using Oracle Financials and Order Management take take advantage of this products. This also help in order to meet your compliance regulations


Oracle Channel Rebate and Point-of-Sale Management provides functionality above and beyond that provided by Oracle Advanced Pricing for pricing scenarios including net accruals, retroactive pricing, complex volume pricing agreements, supplier ship and debit and the ability to update the correct general ledger accounts for all pricing situations including discounts. This is the only system in Oracle today that provides the correct accounting procedures for price reductions given on invoices. It also controls pricing in multi-tiered distribution.

This system addresses four critical areas related to the effective processing, POS data load, data validation & cleansing, dispute handling and Claims settlement.


Oracle Price Protection is a new module in Release 12.1 that provides distributors the ability to adjust and control their inventory valuations, purchasing costs and sales pricing based on pricing changes received from vendors. Price Protection automates the price protection processes when a vendor changes the price of a product and adjusts the GL records systematically.

More specifically, this product:

  • Generates and tracks price-protection claims for both on-hand product inventory and customer product inventory
  • Updates inbound prices lists and purchasing systems with new prices
  • Updates costing and financial systems to reflect new prices and its execution can be done by
    • Providing consolidated view of inventory across WMS and TM (Channel inventory)
    • Calculating accruals and generate debit claims for vendors
    • Calculating accruals and issue credits for customers
    • Integrating with Oracle Costing to adjust Cost of Goods and Services (COGS)
    • Integrating with Oracle Purchasing to adjust inbound price list and purchase orders
    • Integrating with Oracle Pricing to update inbound price list with new price
    • Integrating with Oracle Financials to handle deferred revenue recognition

Price Protection leverages Oracle Fusion Middleware and has service-oriented architecture to allow for rapid deployment into heterogeneous environments. Price Protection is designed to work out-of-the-box with Oracle E-Business Suite

This product is Integrates with Procurement, Warehouse / Inventory, Costing, General Ledger, Accounts Payable, Accounts Receivable.

This new products is targeted for Wholesalers/distributors specially for High Tech customers. This application is having dependency and perquisite of first two application discussed above.


Oracle Supplier Ship and Debit is a new module in Release 12.1 and a new flow introduced that enables Distributors to more quickly and intelligently respond to market conditions by automating special price requests to Vendors, in order to close more sales and increase profitability. Distributors are able to reduce the cost of managing the special pricing process as the execution and the more tedious claiming process are completely automated thereby providing greater visibility.

Oracle Supplier Ship & Debit

This products sound similar to Wholesalers/distributors specially for High Tech customers. This application is having dependency and perquisite of first two application discussed above.Supplier Ship & Debit application have Dependencies and perquisite with AR Deduction Settlement and Channel Rebate & Point of Sale Management application.

Posted in Oracle Receivable, R12 | No Comments »

‘Alternative Payee Name’ Options for Accounts Payable

Posted on February 27th, 2011 by Sanjit Anand ||Email This Post Email This Post

Thanks to reader Ganesh, you pointing this functionality availability in EBS.Last time I observed this lacking functionality while one client migrated from SAP to oracle.

Good news for those having Oracle R12.1.1 , they can utilize this new functionality where a new attribute in the supplier form enabled them link the payee of supplier A to the payee for supplier B(alternate payee). Then after Payable department can enter an invoice you go to the Remit-To columns and set them to the alternate payee.

You need to update the supplier and create a relationship with the alternate supplier in the suppliers form. When new invoices are entered these remit to supplier fields at the invoice header default if just one relationship exists or can be selected from LOV if multiple exist. It appears that if there were multiple relationships this can be changed after validation but prior to accounting.

Check it out for more details at metalink #949183.1

Reference Post

Posted in Oracle Payable, R12 | No Comments »

Oracle Supplier Hub Insights

Posted on December 29th, 2010 by Sanjit Anand ||Email This Post Email This Post

Oracle Supplier Data Hub is part of a full suite of Master Data Management (MDM) tools unifies and shares critical information about an organization’s supply base. It does this by enabling customers to centralize all supplier information from heterogeneous systems and thus creates a single view of supplier information that can be leveraged across all functional departments.

dgreybarrow Oracle Supplier Hub feature :

Oracle Supplier Hub can be broadly categorize into five major coverage area as per fig 1.

Oracle Supplier Hub

  1. Consolidate – Data Import Management, Source System , Cross Reference
  2. Cleanse – Matching, D & B Data Enrichment
    • Various Functionality Coverage are
      • Supplier Registration DQM and D&B
      • Supplier attribute classification
      • Merge, validate duplicates. Similar supplier names are checked.
    • Integrated with D&B out of box. Import data in real-time or batch mode
  3. Master – Supplier Classification & Relationship
  4. Share – Publication and Synchronization, Web Services, Security. This is also called as called OSN Integration.
  5. Govern -Classification Management, Hierarchy Management and Task Management

Typically data administrator functionalities are available from Supplier Data Librarian Super User application responsibility where the data librarian functionalities are available from Supplier Data Librarian application responsibility.

Take a note profile option POS:SM: Supplier Data Hub Configuration with a value Standalone at site level if you are deploying Supplier Hub as a centralized standalone MDM solution OR configure the profile option with a value Integrated EBS if you are deploying Supplier Hub as an Add-on for E-Business Suite to an existing EBS R12.1 application Installation after you purchase the application licenses.

dgreybarrow From R12.1.2 to R12.1.3

Oracle Supplier Hub was first added in EBS in R12.1.2. With recent version 12.1.3, there is slight enhancements as below:

  • Tasks and Notes , Contact points and Party Relationship
  • Bulk Import & Spreadsheet Import
  • Smart Search , Enable party as supplier , Supplier Creation De-duplication
  • Supplier Data Publications and supplier Profile Report

dgreybarrow Supplier Hub and TCA

Oracle Supplier Hub is built on top of Oracle Trading Community Architecture (TCA) of Oracle E-Business suite and leverage TCA implementations features like Data Quality, Batch Management, Source System Management, Adapters, Classifications, Relationships/Hierarchies, Tasks/Notes (available via Customer Data Hub (CDH)).

If you refer back to TCA and CDH documentations for the various profile options and implementations that are applicable at the party level for the functionalities exposed from Supplier Hub navigations.

You can take advantage of TCA DQM APIs to identify the potential duplicate Supplier parties in Supplier Master.

Customers can implement and use Supplier Lifecycle Management (SLM) to streamline the supplier relationship management processes through the trading lifecycle.

dgreybarrow License Requirement

Supplier HUB Data requires a separate license. Those who already using isupplier can requires a separate license

It is a new module introduced in Oracle Applications release 12.1.2, and it allows integration with other systems besides Oracle Applications.

Option 1: Oracle Supplier Life cycle Management can be deployed on an existing E-Business suite R12.1 application instance.
Oracle Supplier Hub Add-on for E-Business Suite which has the same features that of Oracle Supplier Hub can be deployed on an existing E-Business suite R12.1 application instance.

Option 2: Customers who want to deploy a standalone Supplier master data management system can implement Oracle Supplier Hub using Oracle E-Business suite R12.1 platform. They can implement Oracle Supplier Life cycle Management along with Oracle Supplier Hub or as a standalone E-Business Suite application like any other E-Business Suite application in a new instance.

Posted in Oracle Purchasing, R12 | No Comments »

E-Business Suite Release 12.1.3 Now Available

Posted on August 26th, 2010 by Sanjit Anand ||Email This Post Email This Post

Announced early this week Oracle E-Business Suite 12.1.3 is now available for download.

R12.1.3 is a purly a maintenance patch (RUP) and can only be installed on top of an existing EBS 12.1 environment. which combines error corrections, statutory/regulatory updates, and functionality enhancements into a consolidated, suite-wide patch set.

On the Finance, Procurement and HRMS there is the usual small changes here and there, additional changes for different countries. Compare to 12.1.1 and 12.1.2 had a lot more functionality that we would be interested in all.


  • Oracle E-Business Suite Release 12.1.3 Release Update Pack (Patch 9239090)
  • Oracle E-Business Suite Release 12.1.3 Readme (Note 1080973.1)
  • Oracle E-Business Suite Release 12.1.3: Release Content Documents (Note 561580.1)

Of interest to reader will keep updated with some new features in upcoming post.

Posted in News, R12 | No Comments »

« Previous Entries