Skip to main content

Oracle E-business Tax Setup



Setting up Tax


In Order to set up tax, first of all there are certain external dependencies which will be done.

External Dependencies


Create First Party: Legal Entity and Establishments
Create Reporting and Collecting Tax Authorities

Responsibility: Legal Entity Manager
Path: Legal Entity Manager -> Legal Entities -> Create Legal Entity

Use the Legal Entity Configuration to setup the following entities:

-First Party Legal Entity (that represents your company)
-First Party Legal Establishment (for each office, service center, warehouse and any other location within the company that requires a registration with a tax authority for one or more taxes). Setup associations between each legal establishment and a business entity.
-Legal Authority (for each tax authority that administers taxes in a tax regime where you do business)


Set The Profile Options


Set the following profile options as appropriate

eBTax: Allow Ad Hoc Tax Changes
eBTax: Allow Manual Tax Lines
eBTax: Allow Override of Customer Exemptions
eBTax: Allow Override of Tax Classification Code
eBTax: Allow Override of Tax Recovery Rate
eBTax: Inventory Item for Freight
eBTax: Invoice Freight as Revenue
eBTax: Read / Write Access to GCO Data
eBTax Taxware: Service Indicator
eBTax Taxware: Tax Selection
eBTax Taxware: Use Nexpro
eBTax Vertex: Case Sensitive

Responsibility: System Administrator

Navigation: Profile -> System


 

Tax Configuration


Tax Configuration Comprises of the following

·         Create Tax Regimes
·         Create Tax
·         Create Tax Status
·         Create Tax Jurisdictions
·         Tax Rate
·         Tax Rules

Create Tax Regime


Responsibility: Tax Manager
Path: Tax Managers -> Tax Configuration -> Tax Regime -> Create 

Prerequisites:
-Set up Legal Entities and Operating Units
-Enable currencies
-Design TCA Geography Hierarchy Structures (if required by the country)
-Set up Party Tax Profiles
-Optional: Set up tax zones, exchange rate types and tax authorities

All the mandatory fields are pointed with asterisk (*)



1)      Write the Tax Regime Code.
2)      Write the name of Regime.
3)      Select the country name.
4)      Give the effective from date.
5)      There are certain tax controls and defaults available enable the options that you want to use.

Regimes

1





2




3

 

Taxes

Set up details of the taxes within a tax regime. A tax includes:

-Configuration owner
-Default values from the tax regime
-Values specific to the tax
-Settings for tax accounts, tax exemptions, tax exceptions
-Settings for tax recovery, where applicable

Prerequisites:
-Set up a tax regime
-Optional set up ledgers and accounts, tax reporting codes and tax types (lookups).

Responsibility: Tax Manager
Navigation: Tax Managers -> Tax Configuration -> Taxes -> Create



3)      Enter the Tax Source.
4)      Enter Tax and Tax name.
5)      Give the effective from date.
6)      Choose the geography type parent geography type if any and the geography name.
7)      Select the tax currency.
8)       All the other details are optional.
9)      At this stage do not make tax available to transaction. This would be last step after completion of all set up steps.

Set the controls and defaults as appropriate.

 








Tax Statuses

Create a tax status for a combination of tax regime, tax and configurator owner.
Define all applicable tax rates and their effective periods under the tax status.
The tax status controls the defaulting of values to its tax rates.

Prerequisites:
-Set up taxes
-Optional, set up tax reporting types


Responsibility: Tax Manager
Path: Tax Managers -> Tax Configuration -> Tax Statuses -> Create


Status






1)      Select the Tax Regime Code you have already defined.
2)      Select the configuration owner.
3)      Select the tax already  created.
4)      Enter the Tax  Status Code and its name.
5)      Give the effective from date.
6)      All the other fields are optional.
7)      Set the default controls as required.




Tax Recovery Rate


Responsibility: Tax Manager
Path: Tax Managers -> Tax Configuration -> Tax Recovery Rate > Create


1)      Create the Tax Recovery Rate.
      2)      Enter the Tax Regime Code Already created.
3)      Select the configuration owner.
4)      Select the tax created.
5)      Enter the recovery rate code.
6)      Enter the percentage recovery rate.
7)      Enter the effective from date.


Tax Rates

Create tax rate records for tax statuses and tax jurisdictions.
For tax statuses, set up a tax rate record for each applicable tax rate that a tax status identifies.
For tax jurisdictions, set up tax rate records to identify the tax rate variations for a specific tax within different tax jurisdictions. For example, a city sales tax for a state or province may contain separate city tax jurisdictions, each with a specific rate for the same tax. You can also define tax recovery rates to claim full or partial recovery of taxes paid.

Prerequisites:
-Set up tax status
-Set up units of measure (for quantity rate types)
-Optional, set up tax transaction type lookup codes, an offset tax, tax jurisdictions, tax reporting types, tax recovery rates, primary and secondary tax recovery types and tax recovery rules.

Responsibility: Tax Manager
Path: Tax Managers -> Tax Configuration -> Tax Rates -> Create

Tax Rate



1)      Enter the tab create.
2)      Enter the tax Regime Code.
3)      Select the Configuration Owner.
4)      Select the Tax and Tax status already created.
5)      Select the tax jurisdiction code.
6)      Enter the percentage rate of the tax.
7)      Enter the effective from date.

Tax Rules


Although tax rules are optional but you have to create your own rules or active the default rules.

Responsibility: Tax Manager
Path: Tax Managers -> Tax Configuration -> Tax Rules -> Create

Rule







1)      Select the Configuration Owner.
2)      Select the tax regime code.
3)      Select the Tax already created.
4)      Select the rule type, if you have not defaulted the rules in default and controls then you can default them from this window.
5)      Select the rule type from the list of menu which you want to make default or want to create your own.

Tax Availability


Responsibility: Tax Manager
Navigation: Tax Managers -> Tax Configuration -> Taxes -> Create


1)      Tax will be available to transaction when all the above steps are completed
2)      When you enable the checkbox; tax will be available for transaction.
3)      Now you can use the above created tax in AP and AR
4)      Make tax available


Comments

Popular posts from this blog

Oracle Subledger Accounting (SLA) Tables, Views

Oracle Subledger Accounting (SLA) Tables, Views Oracle Subledger Accounting Tables: TABLE NAME DESCRIPTION XLA_AAD_GROUPS The XLA_AAD_GROUPS table stores the merge dependencies analyzed during the merge analysis.  All application accounting definitions with the same GROUP_NUM must be merged together. XLA_AAD_HDR_ACCT_ATTRS The XLA_AAD_HDR_ACCT_ATTRS stores standard, system and custom sources assigned to an accounting attribute at the AAD level. XLA_AAD_HEADER_AC_ASSGNS Store the analytical criteria for the application accounting definitions. XLA_AAD_LINE_DEFN_ASSGNS This table stores the journal lines definitions for the application accounting definitions. XLA_AAD_LOADER_DEFNS_T The XLA_AAD_LOADER_DEFNS_T table is the interface table that facilitates the data transfer from data files and the database. XLA_AAD_LOADER_LOGS The XLA_AAD_LOADER_LOGS table stores the errors and logs generated by the application accounting definitions loader. XLA_AAD_SOURCES XLA_AAD_SOURCES table stores a...

Oracle Fusion Cloud: Supplier Import Process using File Based Data Import (FBDI)

 Supplier Data Migration or Upload to Oracle Fusion environment File-Based Data Import for Oracle Procurement Cloud Supplier import in oracle fusion   In this post , We will discuss about Supplier import in oracle fusion. Oracle has provided the FBDI tool to import suppliers from External  Source  to the Oracle fusion. Supplier Import in Oracle fusion we first need to  Download  the Supplier Import FDBI  templates  given by the Oracle fusion to import suppliers. Oracle has given 5 Different FBDI templates to Import supplier in Fusion. Here in this post , I will share the Complete steps for Supplier import in oracle fusion. You can refer this post for Supplier Import.   Steps for Supplier import in oracle fusion     Step1- First we need to download Supplier Data  Template  from Oracle Repository. Go to this path for Oracle Repository. ( select Based on your Cloud version) https://docs.oracle.com/en/...

Number to Word conversion in RTF

<?xdofx: expression ?> for extended SQL functions <?xdoxslt: expression ?> for extended XSL functions. You cannot mix xdofx statements with XSL expressions in the same context This function enables the conversion of numbers to words for RTF template output. This is a common requirement for check printing. The new function is “to_check_number”. The syntax of this function is <?xdofx:to_check_number(amount, precisionOrCurrency, caseType, decimalStyle)?> The following table describes the function attributes:   Attribute Description Valid Value amount The number to be transformed. Any number precisionOrCurrency For this attribute you can specify either the precision, which is the number of digits after the decimal point; or the currency code, which will govern the number of digits after the decimal point. The currency code does not generate a currency symbol in the output. An integer, such as 2; or a currency code, such as ‘USD’. caseType The case type of th...