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

Why you need Third Party Integration for Tax System

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

Third-party tax solutions provide a more complex set of features for sales and use tax calculations than ERP's like Oracle (EBS, Peoplesoft), SAP based tables. The need for Third Party integration is always demanding if Companies are operating in Noth America.

The need for Third Party Integration for Tax System is ..

  • To get out of the box tax content
  • To avoid continuously monitoring tax law changes
  • Automated tax content updates
  • Better audit support
  • Single solution for Oracle and non Oracle systems
  • Meet local reporting needs
  • Access to tax research of the provider
  • Get out of the box return / support for major countries

While Using so , you can get these benefits

  1. Reduced overall cost of tax compliance
  2. Improved efficiency of transactions
  3. Greater Business Insight
  4. Improved footprint of taxable transactions
  5. Reduced risk associated with manual intervention

Next most vital steps in a successful sales tax system implementation is choosing the right software solution. Every business is unique and has an array of different requirements. Once the requirements have been identified and the type of solution is identified for a tax system implementation, the next step is to research the providers that offer that type of solution.Every software package offers a different set of possibilities. It’s important that the project team is aware of all the benefits and functionality of the different software packages before making the final selection.

Few Third Party Options for Tax Integration Technologies

  • ADP owns Taxware and offers the Sales/Use Tax (SUT) and Taxware Enterprise (TWE) applications.
  • Avalara is privately owned and offers the AvaTax Connect as a web-hosted solution for small-to-medium businesses.
  • Thomson Reuters owns Sabrix, which has been re-branded and integrated as part of OneSource.
  • Vertex remains privately owned and offers the Q-Series and O-Series applications.
  • Wolters Kluwer owns CCH, which offers the Sales Tax Office (STO) solution, and they recently acquired SpeedTax.

I look forward to learing about your implementation experiences!

Posted in Oracle E-Business Tax | No Comments »

Solutions for Oracle Release 12 and E-Business Tax

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

With Release 12, Oracle introduced a new tax framework called E-Business Tax .

The new tax module includes the capability of integrating with 3rd party tax applications, such as Vertex O Series, for an even greater level of tax compliance and efficiency. Vertex is the only tax solution provider selected as Oracle's testing partner for E-Business Tax.

Vertex Sales Tax O Series Link for Oracle Integrates with the following Oracle modules:[ Adopted from Vertex Documentation]

  • Order Management
    • Estimation of Sales Tax on Standard Sales Orders (real time calculation)
  • Accounts Receivables
    • Calculation of Sales Tax on Standard AR Invoices
    • Credit memos/Debit memos & Adjustments
    • Recurring invoices
    • Manual invoices
  • iReceivables (credit memo requests)
  • Service & Project Billing (via AutoInvoice to AR)
  • CRM (iStore and Quoting via Order Capture)

Vertex Consumer Use Tax O Series Link for Oracle Integrates with the following Oracle modules:

  • Payables
    • Verify vendors charged sales tax or self-accrue use tax
  • Purchasing
    • Estimate sales tax on POs, and update committed spend in Projects
  • Inventory
    • Self-accrue use tax on material transaction movements

Vertex Oracle1

 

Features and Functionality of the Vertex Tax Links for Oracle:

  • Provides real-time response and batch-mode processing options
  • Provides a Client Extension for customer specific tax element sourcing rules
  • Enhances address validation functionality in Oracle E-Business Suite
  • Includes configuration forms to control tax settings at an Oracle operating unit level, as well as specific jurisdiction levels
  • Updates the Vertex Journal to record use tax, and synchronizes Oracle and Vertex

The final result is an integrated solution allowing to focus on adding value to their business through increased flexibility to manage day-to-day as well as more strategic tax related business issues.

Posted in Oracle E-Business Tax | No Comments »

Vertex O Series Integration with Oracle Applications & SAP

Posted on September 28th, 2012 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Vertex O Series identifying the dynamics that are occurring in your company and those that match up with the capabilities of the Vertex O Series system is the key to planning the most efficient and effective strategy for implementing an automated tax compliance solution

Consider the following factors and trends that may be taking place within your company:

  • Management of consumer use tax is becoming a high priority within the tax department.
  • Company growth has resulted in expanded international operations and value added tax is no longer manageable as a manual effort.
  • Evaluations of the current ERP implementations are occurring and upgrades to newer versions are in the planning stages.
  • Merging operations of acquisitions to a centrally managed structure is on the planning horizon.
  • A new business initiative such as a new on-line storefront or purchasing system will be implemented with web technologies.
  • Transactional tax management for multiple divisions will be centralized in a single corporate tax department.
  • The IT department has begun a strategy of adopting Web Services technologies for interoperability among applications.
  • The IT department has initiated a strategy to reduce maintenance costs across the organization by limiting application support on client stations.

dgreybarrow VERTEX O SERIES FOR ORACLE EBUSINESS SUIT

For companies with Oracle E-Business Suite Applications both 11i and R12 .

Vertex offers Vertex Tax Links for Oracle, an interface developed using Oracle standards and guidelines that ensures every financial process with a tax consequence administered through Oracle and Vertex O Series will be accurately calculated and reported.

As Oracleis preferred tax solution vendor, Vertex O Series for Oracle goes far beyond the capabilities of native Oracle and simplifies tax management by delivering advanced transaction tax capabilities. Below is Tax links for EBS Integration Possiblity.

Vertex Oracle1

 

dgreybarrowVERTEX O SERIES FOR JD Edwards EnterpriseOne

The integration requires changes to some of EnterpriseOne's business functions; therefore a design and deployment strategy for the integration will need to be developed for each O Series opportunity.

The integration currently interfaces to the following modules:

  • Sales Order Management
  • Contract Billing
  • Service Billing
  • Accounts Receivable
  • Procurement
  • Accounts Payables

dgreybarrowVERTEX O SERIES FOR PeopleSoft Enterprise

PeopleSoft supports the integration with Vertex O Series as a web-services integration.

PeopleSoft applications communicate with these web services through the PeopleSoft Integration Broker. The Integration Broker uses the URL of the web service to conduct transactions with these tax solutions.

A streamlined connection method is available for Vertex O Series.

PeopleSoft Billing, PeopleSoft Order Management, and PeopleSoft Purchasing interact with Vertex O Series for the following:

  • Geocode lookup (Tax Area Identification)
  • Online tax calculation in PeopleSoft Order Management, PeopleSoft Billing, and PeopleSoft Purchasing
  • Order completion processing (batch processing in PeopleSoft Order Management).
  • Invoicing (batch processing in PeopleSoft Billing).
  • Procurement card processing (batch processing in PeopleSoft Purchasing).

dgreybarrowSAP INTERFACE COMPONENT FOR VERTEX O SERIES

Companies that utilize SAP as their enterprise software will realize the benefits of the ongoing Vertex/SAP partnership and joint development effort resulting in the SAP Interface Component (SIC).

SIC provides an interface for Vertex O Series with the following five SAP modules:

  • Sales and Distribution (SD), including Order Entry (O/E), Invoicing, and Quotations
  • Financials (FI), including Accounts Receivable (A/R), General Ledger (G/L), and Accounts Payable (A/P)
  • Materials Management (MM) including Purchasing
  • Supplier Relationship Management (SRM) including Enterprise Buyer Professional (EBP)
  • Customer Relationship Management (CRM) including Telesales and Internet Sales, SAP Leasing Module

SAP Vertex Data Flow

Hopefully this post will be helpful for tax automation.

Posted in Oracle E-Business Tax | No Comments »

Sales Tax Nexus

Posted on March 12th, 2012 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Nexus is a constantly evolving concept, as states (over time) write new rules or reinterpret existing law.

The word nexus refers to a connection between a person and a taxing jurisdiction that is deemed sufficient to allow the jurisdiction to impose a tax.

First of all, sales tax nexus is the basis for all sales tax discussions.

Without sales tax nexus, a business has no further concern from a sales tax perspective. In this context, in its simplest definition, nexus is a physical connection between a state and a business that enables a state to subject that business to its sales tax laws. The connection has to be “substantial” and that’s where the problem arises. “Substantial” is generally left to interpretation and is rarely clearly defined.

If you are part of Tax implementaion, don;t get surprise with this term if you came across while discussing with Tax department.

You can get more insights here

[Adopted from Internet]

Posted in Oracle E-Business Tax | No Comments »

Oracle Tax Content Library

Posted on July 28th, 2011 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Recenetly Oracle has come up with Tax Content Library via a patch 8618701:R12.ZX.A. It provides tax content for

  • EU Countries: Austria, Denmark, Germany, Ireland, Poland, Spain, Belgium, France, Hungary Luxembourg, Portugal, Sweden, Czech Republic, Finland, Italy, Netherlands, Slovakia, United Kingdom
  • Non EU Countries: Norway, Switzerland, Turkey
  • Reduced Configuration: Australia, New Zealand, Taiwan, Singapore

The data is correct as of 1-Oct-2007

This does not provide updates / changes to Tax Laws e.g. Irish, UK VAT Rate changes of 2008 / 2010 not included

Still local reporting still needs to be configured and significant setups still need to be done

Posted in Oracle E-Business Tax | No Comments »

eBTax – Still Have Compliance Limitations

Posted on January 28th, 2011 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Do You know, though R12 Oracle eBTax is New module , but this provides Half of the Tax Compliance Solution , as this lack these features as compare to Tax complete solution like Vertex:

1.Tax rates

2.Situs/Place of Supply rules (e.g., modified origin)

A tax can only be based on either the ship-to or the ship-from

In Texas, the district taxes are likely to be calculated and remitted to the wrong district

3.Tier tax & max tax rules

 

  • A tax can only have a reduced basis
  • In Florida, Tennessee, Arkansas and North Carolina caps cannot be calculated
  • All taxes are calculated by the total line with no consideration to units

 

4.Product/services taxability rules

5.Returns or remittance capability

In addition, the functionality provided in EBTax may work for companies with very limited tax exposure or “nexus.”

Other functional limitation's are

  • eBTax does not provide master geography data for Address Validation (unless using a rate file)
  • From an AP standpoint, EBS R12 does not have functionality to verify vendor charged tax against system calculated tax - it will only allocate the vendor
    charged tax over the lines and compare to a tolerance that is set
  • eBTax does not provide flexibility around tax actions for vendor undercharge, overcharge, etc.
  • eBTax does not work with disparate systems - Oracle R12 only
  • Building, maintaining and testing rules can be time consuming (must write rules 3 times state, county & city)
  • Only receive jurisdictional level tax when address validated at that level
  • No reports out of eBTax to provide configuration (e.g., listing of all condition sets, rules, etc.)
  • eBTax has limited fields available for use in tax decisions
  • Performance issues encountered when the number of condition sets per rule reach the thousands (which can happen using GL accounts as a taxability driver on the procurement side)

Lets hope Oracle can add some of the missing link in future releases.

Posted in Oracle E-Business Tax | No Comments »

Modules and Financial Events for Tax Transactions

Posted on January 26th, 2011 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

In Procure to Pay (P2P) mainly 4 application Payable, Iexp, Iproc, and PO and Projects Module heavily producing Financial events for Tax , which is mostly Input in Nature.

  • Oracle Payables Invoice
  • Payables Credit/Debit Memo
  • Purchase Order
  • Purchase Transaction Quote
  • Purchase Requisition
  • Purchase Prepayment

whereas in Order to Cash (O2C) four main application like OM, OKS, Quote and AR using and producing Financial events for Tax with these transactions.

  • Sales Transaction Quote
  • Receivables Invoice
  • Sales Credit/Debit Memo
  • Sales Adjustment

Posted in Oracle E-Business Tax | No Comments »

Oracle R12 Financials Enhancements Cheat Sheet – > EBTax

Posted on January 15th, 2011 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

This is New Product in R12 which provides the infrastructure for transaction tax knowledge management and delivery using a global system architecture that is configurable and scalable for adding country specific tax content.

  • Modules Integrated with EB Tax:
    • Oracle Purchasing
    • Oracle Internet Procurement
    • Oracle Receivables
    • Consigned Inventory
    • Oracle Payables
    • Oracle Intercompany Invoicing
    • Oracle Order Management
    • Oracle Trade Management
    • Oracle Services Contracts
    • Oracle Order Capture/iStore/Quoting
    • Oracle Internet Expenses
    • Oracle Project Accounting
    • Oracle General Ledger
  • Configuration Options & Provider Service Subscriptions: Users using a subscription model can share the tax setup. The owner of tax setup data is defined as a Configuration Owner and can be an Operating Unit or a Legal Entity.
  • Events and Configuration Owner Options: Tax Events model allows E-Business Suite applications to map their various documents and actions across applications into corresponding tax event classes and tax event types.
  • Tax Configuration Manager: This component is responsible for creating and maintaining the structural foundation of tax, the building blocks.
  • Tax Determination Services: This component calculates transaction taxes based on transaction details and tax setup information.
  • Centralized Tax Record Repository for Audit and Reporting
  • Tax Reporting: Tax Reporting is flexible enough to provide data in a user-friendly format that allows the standard and identified country specific requirements to be met.
  • Tax Simulator: This user interface help the tax manager simulate the effect of a new rule or new ‘incremental’ setup data, such as a new tax rate.
  • Guided Configuration: Enables a tax manager, i.e., an expert in the domain of tax, to configure the system to meet the tax requirements in one or more countries.
  • Additional Enhancements:
    • Deferred Tax in Payables
    • Enhanced handling of Tax on Freight
    • Sales and Use Tax in procurement
    • Enhanced exemptions and exceptions
    • Multiple Tax Registrations
    • Multiple Recovery types
    • Tax reporting codes
    • Cash as well as Accrual Basis reporting for tax
    • Enhanced handling of Tax on Intercompany Movements

Posted in Oracle E-Business Tax | No Comments »

Options for Implementation mode for eBtax

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

In E-Business Suite R12, Oracle provided a powerful new feature,Oracle E-Business Tax, that unifies the management of sales, use, and value-added taxes.

Do you know eBTax Can be implemented in 2 modes with there major differences ?

eBTax native mode

  • The eBTax engine itself determines, calculates and records tax
  • Requires manual creation and maintenance of rules
  • Rates are provided by a 3rd party
  • Robust engine but must be configured from scratch
  • You need to keep checking for rate/rule changes

eBTax external tax engine mode

  • The eBTax engine calls an external tax engine
  • External tax engine is used to configure very comprehensive tax rules
  • Provides signature-ready return in local language and electronic filings

Posted in Oracle E-Business Tax | No Comments »

Its all about Taxation

Posted on February 28th, 2009 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Do you know when a well-designed Integrated system(like OracleApps/SAP) once properly deployed can connect every area of your organization—HR, customer service, internal business processes, inventory control, financial data centres, company information, order tracking, etc.—thereby the next big things is to improving your company’s effectiveness and efficiency for tax reporting need within product or outside product.

Taxation is having very complex model from implementation mapping point of view and must can be considered in two dimension.

  • U.S. Taxes requirement
    • Sales Tax
    • Seller’s Use Tax
    • Consumer’s Use Tax
    • Rental Tax
    • Leasing Tax
  • International Taxes
    • Input VAT
    • Output VAT
    • Import VAT
    • Export VAT
    • Acquisition VAT
    • Consumption Tax
    • Goods and Services Tax

Oracle EBS itself catering almost tax requirement expect few. Lets recap some of basic understanding of different tax type that might be big help and consideration for ERP implementation.

  • VAT
    In simple layman term you understand like when you sell something you add on tax which is payable to the tax authorities. When you buy something you are able to recover the tax.Normally the net amount is paid to the tax authorities. Certain items are not recoverable, hence the term recoverable and non recoverable taxes are considered.

VAT is imposed on the value added to goods or services at each stage of their supply. The VAT charged on a customer invoice is referred to as Output Tax. Any VAT paid on a vendor invoice is referred to as Input Tax.

The amount due each period can be described as follows:

Amount Due = Output Tax - Input Tax

  • GST

Goods and Services Tax – used in Canada and Australia ,Singapore– Similar to VAT

  • Withholding Taxes

A withholding tax is where an amount is withheld from a payment to the supplier and paid to the tax authorities. If the overall payment due to a supplier was say 120, it may be that they are only paid 100, the remaning 20 being paid over. Essential you are acting as a tax collector. This only applies to certain types of supplier in certain countries.

  • Recoverable Tax

Recoverable tax is one , which you can recover from your sales.

You can say VAT system. one suffer Tax when a person makes sales and which can be adjusted against the tax suffered when you make a purchase(Recoverable portion only) , end of the day , you pay to the tax authorities the Net of Tax paid on purchase and tax included on your sales.

  • Sales Tax

Sales taxes are tax levies charged on applicable revenues according to law; and reported and paid periodically to the relevant taxing jurisdiction.

Understanding is very important . Take a case with USA implemenation.

There is one basic rule that we need to understand when it comes to calculating tax, which is always calculated for the destination shipping address.

Take senarios : Dell.com is an online retail website. It ships all its orders from a Warehouse. There are a couple of customers ordering a laptop of Model xyz drive on the website. One of the customers resides in NY and the other resides in the CA.

Now we have to decide which state’s tax law should we apply for calculating tax for the Laptop? Is it Dell for both of the customers? No its not.

For the customer who resides in NY, NY’s state’s law will apply and for the customer in CA, CA’s tax laws will apply.

Let’s understand the simple method:
List price of Laptop = $800
Tax on Laptop in NY = 7 %
Tax on Laptop in CA = 5 %
Sale price of Laptop for the customer in NY = $856.00
Sale price of Laptop for the customer in CA = $840.00
So, we understand that two customers, in two different states, might end up paying two different prices for the same product purchased.

  • Use Tax or consumption tax

These are some sort of levied by local jurisdictions where goods and services are delivered from outside the jurisdiction but consumed locally, and are often accrued and paid by the buyer rather than the seller. Thailand is one such usage of such tax.Japan levies a consumption tax on the value of goods.

More on VAT

As Value Added Tax or VAT is a tax or levy on the business at all levels of the manufacture and production of a good or service rendered and based on the increase in price, or value, is provided at each level. The percentages of VAT vary depending on the goods or services provided.

Benefits of VAT?

The VAT has numerous benefits. They are:

  • It reduces cascading affects of taxes and removes distortions
  • It removes artificial incentives affecting choice of location of business since the VAT percentage on a particular type of good or service is same across all territories within the country
  • It is eminently collectible and more transparent; it renders high cost to businesses not being part of VAT chain; i.e. if someone conceals the output, one cannot get refund on input
  • Exports could be freed from Tax burden with World Trade Organization (WTO) compatibility

VAT @EBS

The VAT is defined as a Tax code in Oracle Applications in Accounts Payable module and the tax is attached to the invoice lines so that the tax is calculated as a positive tax on the invoice distribution lines.

What is important for Implementor for Tax

  • Data identification and configuration (aka set up)
  • Sales and use tax software integration (If using any third party tax software)
  • Record retention
  • Reporting : what is required is comprehensive data requirements of a tax department and tax reporting feature in ERP

Where is the Tax integration required

  1. Order Management :Estimation of Sales Tax on Sales Orders
  2. Accounts Receivables (AR) :Calculation of Sales Tax on Standard AR Invoices ,Credit memos/Debit memos & Adjustments ,Recurring invoices ,Manual invoices
  3. iReceivables (credit memo requests)
  4. Service & Project Billing (via AutoInvoice to AR)
  5. CRM (iStore and Quoting via Order Capture)
  6. Oracle Internet Expenses
  7. Payables : GST included tax supplier Invoice
  8. Purchasing :Estimate sales tax on POs, and update committed spend in Projects
  9. Inventory :Self-accrue use tax on material transaction movements
  10. General Ledger: Manually keyin Journal Entries
  11. Oracle Trade Management
  12. Oracle Services Contracts

Third Party tax @EBS

Vertex and Taxware are the two supported 3rd Party Software Vendors that Oracle Receivables uses to integrate with for tax calculating purposes. If you setup the integration the tax rates that are stored in the Oracle locations and rates tables are override and the calculation is done in the tax vendor.There is another Third party tax software called is SABRIX which is also widely used.

Next will discuss some important features of E Business tax . Till than ..:)

Posted in Oracle E-Business Tax | No Comments »

Page 1 of 11