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

Vertex and Oracle Cloud

Posted on October 13th, 2017 by Sanjit Anand ||Email This Post Email This Post

Oracle ERP Cloud Transaction Tax Automation is consist of Comprehensive Tax Partner Offerings

  • Robust infrastructure for tax partner solutions
    • Tax Content and Tax Reporting services providing fast ROI option for mid-market companies adopting Oracle ERP Cloud
    • Integrated Cloud-to-Cloud tax calculation services for enterprise grade companies
  • Infrastructure has been optimized for ERP Cloud customers using end-to-end Vertex transaction tax offerings, lending value in fulfilling the compliance function

Let see some key features and automation Flow.

Tax Content Offering

The Vertex tax content service covers geographies, tax jurisdictions, and tax rates.

This service supports address validation for master location data, and provides tax jurisdictions and tax rates data for US locations all updated on a monthly basis to comply with
statute changes.

In addition, users may opt for taxability rules content, which adds product and service taxability taxability rates and customer-specific product and service tax rules also updated on a monthly basis.

Tax Calculation Offering

  • “Cloud-to-Cloud” integration of ERP Cloud and Vertex O Series Cloud for transaction tax calculation
  • No software integration components deployed on Cloud
  • Seamless data flow between Oracle ERP Cloud and Vertex O Series

Tax Reporting Offering

  • Vertex Indirect Tax Returns – Signature-ready returns for U.S. sales and use taxes are produced for filing
  • Vertex Returns Outsourcing Service – Vertex can manage the entire tax compliance function from tax returns generation to payment remittances

    Here is how end-to-endTransaction Tax Solution usually Flow


Fig1 :Vertex End-to-End Tax Solution Automation


The Vertex solution architecture enables “cloud-to-cloud,” touchless integration of Oracle ERP Cloud and Vertex Cloud.

Enjoy efficient, user-friendly uptake and integration, with no need to host any software or integration components on premise.

There is no need to apply patches, service releases, or monthly data updates Vertex takes care of these for you.

Leverage the benefits of powerful tax automation as below:

  • Real-time transactions and batch processes for tax functionality
  • Tax-sensitized receivables and payables invoices
  • A streamlined process with accurate tax outcomes
  • Secure, cloud-hosted journal retention for tax return compliance

Posted in Oracle E-Business Tax | No Comments »

Release 12.2.5 AR Enhacement : Apply Receipts Automatically based on Match Score and Knapsack Method

Posted on July 23rd, 2016 by Sanjit Anand ||Email This Post Email This Post

This is one of R12.2.5 Enhancement in EBS AR.

The Automatic Cash Application improves accuracy and on-time application of cash receipts with the introduction of two new methods for automatically applying cash receipts.

  • The first method generates match scores using the Levenshtein distance algorithm and automatically applies the receipt based on a score threshold.
  • The second methods applies receipts by knap sacking the receipt amount and the open transactions of the customer.

Both methods provide suggested matches when a receipt cannot be applied automatically

Background information on the Levenshtein distance algorithm [ From Wikipedia, the free encyclopedia ]

In information theory and computer science, the Levenshtein distance is a metric for measuring the amount of difference between two sequences (i.e., the so called edit distance).

The Levenshtein distance between two strings is given by the minimum number of operations needed to transform one string into the other, where an operation is an insertion, deletion, or substitution of a single character. A generalization of the Levenshtein distance (Damerau–Levenshtein distance) allows the transposition of two characters as an operation. Some Translation Environment Tools, such as translation memory leveraging applications, use the Levenhstein algorithm to measure the edit distance between two fuzzy matching content segments.

The metric is named after Vladimir Levenshtein, who considered this distance in 1965.It is often used in applications that need to determine how similar, or different, two strings are, such as spell checkers.
For example, the Levenshtein distance between “kitten” and “sitting” is 3, since the following three edits change one into the other, and there is no way to do it with fewer than three edits:

  1. kitten -> sitten (substitution of ‘s’ for ‘k’)
  2. sitten -> sittin (substitution of ‘i’ for ‘e’)
  3. sittin -> sitting (insert ‘g’ at the end).

Posted in Oracle Application, Oracle Receivable, Release12 | No Comments »

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 »

Payment Acknowledgement Import : R12.2 out-of-box Feature

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

Payment acknowledgement processing is widely used in various countries in US and EMEA region where Bank provide the acknowledgement/Confirmation.

If you have some customization in existing EBS , and planning to use R12.2 in near term, you can take advantage of out-of-box feature .

This new functionality that has been added to Oracle Payments that allow you to import payment acknowledgement reports containing payment status for bank received payment files.

A “Payment Acknowledgement” for supplier payments in Oracle Payments/Payables is a file that confirms for the payor that their electronic payment (sent to a payee’s bank) was successfully transmitted and received (“acknowledged”) by the bank. Therefore, this type of Payment Acknowledgement processing starts after successful transmission of the payment file to the supplier’s bank. Once the bank receives the payment file, the process generates the acknowledgement file.

With this Import you can :

  • Map bank acknowledgment codes with system defined acknowledgment codes
  • Import acknowledgment data
  • Import multiple acknowledgments per payment
  • Review acknowledgment details including bank reported errors and status

Remember , Payment acknowledgment is supported only at payment level.

Posted in Oracle Payable, Oracle Payment Module | 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 »

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 »

Golden Tax Adaptor for Mainland China : Invoices for VAT in China

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

Do you know, laws in the People’s Republic of China require the use of a government certified tax software called ‘Golden Tax’ for VAT calculation, statutory tax reporting and generating and printing VAT invoices.

Golden Tax is an integrated nationwide value-added tax (VAT) monitoring system in China.

Golden Tax Adaptor enables Oracle’s customers in China to interface their invoices, credit memos and debit memos from Oracle Receivables/Oracle Fusion Receivables to the Aisino Golden tax software in order to calculate VAT, generate and print VAT invoices and report tax to the Chinese Tax authorities.

The user can use discrepancy and mapping reports to audit and reconcile the discrepancies in data between Receivables invoices and Aisino generated VAT invoices.

In China, VAT invoices are generated only for VAT, and not other types of tax that may appear on receivables transaction lines. Tax types identify the applicable VAT tax for each line of a VAT invoice for a given legal reporting unit.

You can use these tax types or create your own, according to your tax requirements. Different tax types are:

  • VAT: VAT for goods or services
  • VAT-GOODS: VAT for goods only
  • VAT-SERVICES: VAT for services only

This support for additional VAT invoice types – Special VAT invoices, common VAT invoices and special VAT Invoices of Waste and Outdated Materials .

The key steps in the Golden Tax process are:

  • Create or import transactions in Receivables.
  • Transfer receivables transactions to the Golden Tax Adaptor as Golden Tax transactions.
  • Modify the Golden Tax transactions to conform to the requirements of VAT invoices for China.
  • Generate a flat file of VAT invoice data for import into the Aisino Golden Tax System.

After the Aisino Golden Tax System generates VAT invoices from the Golden Tax Adaptor data:

  • Import VAT invoice data from the Aisino Golden Tax System.
  • Review and compare the imported VAT invoice data with the flat file exported to the Aisino Golden Tax System.
  • Correct any discrepancies between the two data files.

Further Reading. Goldan Tax

Posted in Localizations, Oracle E-Business Tax | No Comments »

« Previous Entries