Case Study: Setup R12 E-Business Tax (EBTax) for Canada: Includes 2010 HST Changes (Doc ID 577996.1)

Last updated on NOVEMBER 15, 2023

Applies to:

Purpose

In Release 12, Oracle introduced E-Business Tax as the new tax calculation engine for the Order to Cash and Procure to Pay business flows. Each of these modules proprietary tax engines from earlier releases were discontinued in favor of this new solution. (Latin Tax Engine, Golden Tax Adaptor and the India Globalization still exist)

This Technical Brief documents how a simplified implementation might be performed for a customer using E-business Tax for Canada in Release 12.  This is a living document and we encourage readers to post input, ask questions or share best practices on our community thread for Canada Tax Setup. 

This Note includes changes reflective of HST adoption by British Columbia (BC) and Ontario (ON) scheduled to take effect July 1, 2010.  Also added to this note are the Nova Scotia HST rate increases (added June 21, 2010)

This Technical Brief combines, extends and superseeds the following:
1)  Oracle E-Business Tax Configuration Library (CLIC) Note 463001.1
2)  Oracle E-Business Tax Implementation Guide  Chapter 4: Canadian Sales Tax
3)  Technical Brief titled: Integrating Oracle E-Business Tax With Oracle Receivables and Oracle  Payables For Country Canada Release 12  (this document is no longer available for viewing on My Oracle Support)

Scope

This note was written in a case study format using Canada as the example.  It assumes that you have an existing implementation and that you are adding a new country, Canada, to your configuration.

Section 3 begins the case study with some mandatory setup steps.  You should refer to the Financials Implementation Guide along with your module specific implementation documentation as appropriate for your implementation.  The steps documented in this section do cover mandatory setups for modules impacted by E-Business Tax.  Each section also attempts to document the tax implications of options you might select when performing the step.

Section 4  begins the tax specific setups.  In this section we walk you through the basic setup of your tax system.  This section focuses on what E-Business tax calls the "Regime to Rate" flow where you identify the taxes that should be assessed.  Also covered are the default settings used by the rule engine to determine if a tax should be charged and if yes, how to calculate and record the tax. 

Section 5 covers some of the more common business requirements applicable to this case study.  In this section we explain in non-specific terms the general requirement that needs to be satisfied and provide references whenever possible to the origin of the requirement.  We then provide a link to a note that provides in-depth examples, screenshots and video of how to configure a system to satisfy the requirement.   Please note that these reference documents are not all specific to this case study but rather are intended to convey examples of how the requirement might be satisfied.

Additional sections and content will be added to focus on Testing the solution and reporting.  The intent of this Case Study is to help a new or existing user of E-Business Tax to understand concepts and setup that may otherwise be dispersed across numerous implementation and user manuals.  It also attempts to show how you can comply with some general business requirements, thereby allowing you to focus on the less common requirements unique to your specific organization.  We hope that this enables you to streamline your project to reduce the time/cost of the effort and raise the value realized by your business from E-Business Tax.

Details

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.