2Tax Configuration Using Rapid Implementation

This chapter contains the following:

Define Taxes for Rapid Implementation

The Define Taxes for Rapid Implementation task list provides the required and frequently used setup tasks for implementation scenarios. You can use rapid setup spreadsheets to upload your tax setups to create:

  • Tax regimes

  • Taxes

  • Tax rates

  • Tax thresholds

Use the standard Define Tax Configuration and Define Advanced Tax Configuration task lists if needed as an additional supplement for any:

  • Ongoing maintenance of your tax setups that are not supported using rapid setup spreadsheets.

  • Limited tax configurations that cannot be set up or updated using the rapid implementation approach.

Tasks

The Define Taxes for Rapid Implementation task list consists of the following tasks:

Task Description Required Task to Enable Taxes for Transactions

Manage Tax Regimes

Create and maintain tax regimes for the taxes in each country and geographic region where a separate tax or collection of taxes apply.

You can use rapid setup spreadsheets to create tax regimes and tax regime subscriptions.

Yes

Run Jurisdiction and Rates Upload Program

Upload US sales and use tax jurisdictions and tax rates from a tax content provider.

No

Manage Taxes

Create and maintain details for the taxes of tax regimes.

You can use rapid setup spreadsheets to create taxes.

Yes

Manage Tax Rates and Tax Recovery Rates

Create and maintain details for tax rates, tax recovery rates, and tax accounting associated with these rates.

You can use rapid setup spreadsheets to create tax rates and tax recovery rates.

Yes

Manage Tax Rules

Create and maintain tax rules that define the conditions under which the exceptions to default taxability apply.

You can use rapid setup spreadsheets to create tax rules.

No

Manage Tax Registrations

Create and maintain tax registration information related to a party's transaction tax or withholding tax obligation with a tax authority for a tax jurisdiction where it conducts business.

No

Manage Tax Exemptions

Create and maintain tax exemptions to reduce or increase the tax rate applied to a transaction.

No

Manage Simulator Transactions

Verify tax configuration for taxes that are enabled for simulation or for both simulation and transactions to process real-time transactions without affecting any active data.

No

Note: When preparing the spreadsheets offline for upload into Oracle Fusion Tax, populate the necessary spreadsheet columns for these tax entities based on known transaction tax business requirements. You can use the detailed instructions and individual column help text in the spreadsheets as a guide.

Implement Tax

Oracle Fusion Tax provides a single-point solution for managing your transaction and withholding tax requirements.

Oracle Fusion Tax:

  • Uniformly delivers tax services to all core Oracle Fusion application business flows through one application interface.

  • Provides features for uploading third-party tax partner content.

  • Is configurable and scalable for adding and maintaining country-specific tax content.

Setting Up Oracle Fusion Tax

The Define Taxes for Rapid Implementation task list provides the required and most frequently used setup tasks for implementation scenarios. Using spreadsheets, you can upload your tax setups to create tax regimes, taxes, tax rates, and tax rules.

You can use the standard Define Tax Configuration task list for:

  • The ongoing maintenance of your tax setup.

  • Limited tax configurations that can't be set up or updated using the rapid implementation approach.

To set up Oracle Fusion Tax, the Application Implementation Consultant or Tax Manager must perform the following tasks:

  1. Manage tax regimes.

    • Perform the Manage Tax Regimes task to create and maintain tax regimes for the taxes in each country and geographic region where a separate tax or collection of taxes apply.

      You can use the Tax Configuration Workbook to upload all common tax regime setups as well as your organization specific setups, such as tax regime subscriptions.

      You can also use the individual Tax Regimes and Tax Regime Subscriptions spreadsheets to exclusively create tax regimes and tax regime subscriptions.

    • See the following topics::

      • Tax Configuration Workbook: Explained

      • Creating Tax Setup Using the Tax Configuration Workbook: Worked Example

      • Creating Tax Setup Using Tax Partner Content in the Tax Configuration Workbook: Worked Example

      • Tax Implementation Workbook: Explained

      • Creating Tax Setup Using the Tax Implementation Workbook: Worked Example

      • Creating a Tax Regime Using the Manage Tax Regimes Spreadsheet: Worked Example

  2. Run the jurisdiction and rates upload program.

    • For SaaS (Oracle Cloud) implementations, run the Import Tax Configuration Content job.

    • Refer to the Tax Configuration Content Upload Program: How It Is Processed topic.

  3. Manage taxes.

    • Perform the Manage Taxes task to create and maintain details for the taxes of tax regimes.

      You can use the Tax Configuration Workbook to upload all common tax setups.

      You can also use the individual Taxes spreadsheet to create taxes for a tax regime or a collection of tax regimes. Additionally, you can use the individual Tax Accounts spreadsheet to create tax account assignments.

    • See the following topics:

      • Tax Configuration Workbook: Explained

      • Creating Tax Setup Using the Tax Configuration Workbook: Worked Example

      • Creating Tax Setup Using Tax Partner Content in the Tax Configuration Workbook: Worked Example

      • Creating Tax Setup Using the Tax Implementation Workbook: Worked Example

  4. Manage tax rates and tax recovery rates.

    • Perform the Manage Tax Rates and Tax Recovery Rates task to create and maintain details for tax rates and tax recovery rates.

      You can use the Tax Configuration Workbook to upload all common tax rate and tax recovery rate setups.

      You can also use the individual Tax Rates, Tax Rate Accounts, Tax Recovery Rates, and Tax Recovery Rate Accounts spreadsheets to create:

      • Tax statuses

      • Tax jurisdictions

      • Tax rates

      • Tax recovery rates

      • Tax accounts

    • See the following topics:

      • Tax Configuration Workbook: Explained

      • Creating Tax Setup Using the Tax Configuration Workbook: Worked Example

      • Creating Tax Setup Using Tax Partner Content in the Tax Configuration Workbook: Worked Example

  5. Manage tax rules.

    • Perform the Manage Tax Rules task to create and maintain tax rules that define the conditions under which the exceptions to the default taxability apply.

      You can use the Tax Implementation Workbook to upload organization-specific tax rule setups.

      You can also use the individual Tax Rules spreadsheet to create tax rules details.

    • See the following topics:

      • Tax Implementation Workbook: Explained

      • Creating Tax Setup Using the Tax Implementation Workbook: Worked Example

  6. Manage tax registrations.

    • Perform the Manage Tax Registrations task to create and maintain tax registration information related to a party's transaction tax obligation with a tax authority for a tax jurisdiction where it conducts business.

      You can use the Tax Implementation Workbook to upload your organization-specific tax registrations.

    • Refer to the Tax Registrations: Explained topic.

  7. Manage tax exemptions.

    • Perform the Manage Tax Exemptions task to create and maintain tax exemptions to reduce or increase the tax rate applied to a transaction.

    • Refer to the Tax Exemptions: Explained topic.

  8. Manage simulator transactions.

    • Perform the Manage Simulator Transactions task to verify tax configuration for taxes that are enabled for simulation or for both simulation and transactions by processing real-time transactions without affecting active data.

    • Refer to the Tax Simulator: Explained topic.

This example shows how to create a tax regime in Oracle Fusion Tax using the Manage Tax Regimes spreadsheet.

Spreadsheet entry and upload of tax configuration facilitates a faster implementation. Use the spreadsheet feature to populate new transaction tax configuration and to download the existing transaction tax configuration.

The following table summarizes key decisions for this scenario:

Decision to Consider In This Example

What tax setup data are you creating?

Tax regime

Is the data an update to your existing tax configuration or is it new setup data?

New

Is there only one tax regime per country per tax type with the tax requirements administered by a government tax authority for the entire country?

Yes

Is this a parent tax regime?

No

Do you have an existing legal entity or business unit you want to subscribe to this tax regime?

Yes, a business unit

Prerequisites

To create tax data in a spreadsheet, you must ensure that the appropriate underlying master geography data already exists in Trading Community Model geographies.

Creating Tax Regime Setup Data in a Spreadsheet

Access the spreadsheets that are used to create tax configuration from the Rapid Setup Spreadsheets list. The list is located in the Search Results table on the respective Manage page.

Each rapid implementation task's Rapid Setup Spreadsheets list includes:

  • Downloading a workbook or spreadsheet template for new setup data creation.

  • Downloading existing setup data to a spreadsheet for reviewing existing setup data or adding new setup data.

  • Uploading new setup data from a workbook or spreadsheet.

For this example, download the tax regimes spreadsheet template for new setup data creation from the Manage Tax Regimes page.

  1. Go to the Manage Tax Regimes page.

  2. From the Rapid Setup Spreadsheets list in the Search Results table, click Download Tax Regimes Spreadsheet Template.

  3. Prepare your tax configuration using the Manage Tax Regimes spreadsheet.

  4. Enter the values as shown in the following table:

    Column Value

    Tax Regime Code

    US_SALES_TAX

    Country

    United States

    Start Date

    2001/01/01

    End Date

    Blank

  5. Save the spreadsheet data file as a Comma Separated Values (CSV) file using the macro on the Instructions tab.

  6. From the Rapid Setup Spreadsheets list in the Search Results table, click Upload Tax Regimes from a Spreadsheet.

  7. In the Upload Tax Regimes from a Spreadsheet dialog box, select your file and click Upload.

  8. On the Manage Tax Regimes page, select the Monitor Upload and Download Processes

  9. Note the status of your process.

    • If the status of the upload process is Succeeded, you can view your tax regime using the search criteria on the page.

    • If the upload process failed with a status other than Succeeded, check the details in the corresponding error log, correct any file errors, and upload the file again.

    Note: You can also download existing setups using the Download Tax Regimes to a Spreadsheet list item and update that spreadsheet with the new tax regime details.

Creating Tax Regime Subscription Setup Data in a Spreadsheet

Since you have set up your legal entities and business units previously, you can subscribe them to the tax regime created earlier.

For this example, subscribe business unit, Business Unit 001, to the tax regime you created.

Caution: You must ensure that the tax regime exists before uploading the Regime Subscriptions Spreadsheet Template.
  1. Navigate to the Manage Tax Regimes page.

  2. From the Rapid Setup Spreadsheets list in the Search Results table, click Download Regime Subscriptions Spreadsheet Template.

  3. Prepare your tax configuration using the Manage Tax Regime Subscriptions spreadsheet.

  4. Enter the values as shown in the following table:

    Column Value

    Tax Regime Code

    US_SALES_TAX

    Party Name

    Business Unit 001

    Party Type

    Business unit owning tax content

    Legal Entity Party Number

    Blank

    Enabled

    Y

    Effective Start Date

    2001/01/01

    Effective End Date

    Blank

  5. Save the spreadsheet data file as a CSV file using the macro on the Instructions tab.

  6. From the Rapid Setup Spreadsheets list in the Search Results table, click Upload Regime Subscriptions.

  7. In the Upload Regime Subscriptions from a Spreadsheet dialog box, select your file and click Upload.

  8. Click the Monitor Upload and Download Processes tab.

  9. Note the status of your process.

    • If the status of the upload process is Succeeded, you can view your tax regime subscription using the search criteria on the page.

    • If the upload process failed with a status other than Succeeded, check the details in the corresponding error log, correct any file errors, and upload the file again.

    Note: You can also download existing setups using the Download Regime Subscriptions to a Spreadsheet list item and update that spreadsheet with the new regime subscription record details.

The tax configuration content upload program populates data for the United States (US) in both Oracle Fusion Tax and the Oracle Fusion Trading Community Model geography hierarchy using a single data file provided by specific tax partners. This process is limited in geographic scope to just the United States.

The data file includes:

  • US sales and use tax rate information for all states, counties, and cities which impose sales and use taxes.

  • US state, county, city, and postal code geography combinations.

Alternatively, you can upload the tax partner content using the Tax Rapid Implementation spreadsheets. The spreadsheets are more flexible and support the upload of global tax content instead of just United States tax content. The Define Taxes for Rapid Implementation task list available in the Functional Setup Manager contains individual tasks from which external tax partners can access rapid implementation spreadsheet templates to provide the tax content to customers.

Settings That Affect Tax Configuration Content Uploads

The execution of the tax configuration content upload program differs depending upon the type of Oracle Fusion Applications implementation involved.

  • For non-Software as a Service (SaaS) implementations, use the Run Jurisdiction and Rates Upload Program task in the Financials offering or the rapid implementation task list to start the Upload Tax Configuration Content job set. The Upload Tax Configuration Content job set consists of two individual jobs:

    1. Upload Tax Content File

    2. Process Tax Content Data

  • For SaaS (Oracle Cloud) implementations, run the Import Tax Configuration Content job using the Scheduled Processes page.

You must populate all parameters displayed for each process to prevent errors. Specific parameters are as follows:

Parameter Description

File Location and Name

The full application server directory path and file name related to the specific tax partner data file that is saved on the application server.

Note: This parameter isn't used in Oracle Cloud implementations.

Tax Content Source

The name of the specific tax partner provider that was previously created in Oracle Fusion applications.

Tax Regime Code

The specific US tax regime code that already exists in Oracle Fusion Tax against which the data content upload is executed.

Prerequisites for a Cloud Implementation

Prior to running the Import Tax Configuration Content job in a Cloud implementation, to enable access to the tax partner data file, you must perform the following steps:

  1. Log into Oracle Fusion applications using a specific user that has access to complete the tax configuration content upload process.

    Note: Predefined job roles such as Tax Manager, Financial Application Administrator, and Applications Implementation Consultant, have this access.
  2. From the Navigator menu, go to the File Import and Export page.

  3. Upload the compressed version of the tax partner data file from your local directory to the Universal Content Management server.

  4. Enter fin/tax/import as the account.

  5. Before you run the Import Tax Configuration Content job, run the Load Interface File for Import process from the Scheduled Processes page on the Navigator menu. You run this to transfer the data from the UCM server to the zx_data_upload_interface table.

How Tax Data Content Is Processed

The tax data content upload process:

  1. Uploads all US sales and use tax rates available from a tax partner.

  2. Uploads new or updated US sales and use tax rates available in monthly data files provided by a tax partner.

  3. Creates entities for a specific US tax regime including:

    • Taxes

    • Tax statuses

    • Tax jurisdictions

    • Tax rates

  4. Uploads US state, county, city, and postal code combinations into the Trading Community Model geography hierarchy.

Tip: Prior to initiating the tax data content upload for a tax regime, you have the option to configure taxes directly as:
  • State

  • County

  • City

This approach is used to control configuration settings at the tax level. In this case, do not enable the taxes for simulation or for both simulation and transaction purposes until you are certain that there will not be changes to tax-level configuration.

If you configure taxes before initiating the tax data content upload for a tax regime, you can configure tax liability accounts at the tax level. The tax liability accounting configuration predefined at the parent tax level is automatically assigned to child tax jurisdictions and tax rates created during the tax data content upload process.

Use the Tax Configuration Workbook to upload all common tax setups. For example, create standard state, county, and city sales tax rates within the US using this workbook.

Tax Configuration Workbook Worksheets

The Tax Configuration Workbook is a Microsoft Excel spreadsheet template with six common tax setup worksheets:

Worksheet Predefined Data Content Setup Options

Manage Tax Regimes

Yes

Option 1: Use the tax regimes that are already included for 28 countries. You can modify or delete any of the predefined tax regimes where needed.

Option 2: Use tax partner content for the Tax Configuration Workbook.

Manage Taxes

Yes

Option 1: Use the taxes that are already included for 28 countries. You can modify or delete any of the predefined taxes where needed.

Option 2: Use tax partner content for the Tax Configuration Workbook.

Manage Tax Zones

No

Prepare the tax zones with the appropriate corresponding geographies.

Manage Rates

No

Option 1: Prepare the tax rates.

Option 2: Use tax partner content for the Tax Configuration Workbook.

Manage Tax Thresholds

No

Option 1: Prepare the tax thresholds or maximum taxes.

Option 2: Use tax partner content for the Tax Configuration Workbook.

Manage Tax Recovery Rates

No

Option 1: Prepare the tax recovery rates.

Option 2: Use tax partner content for the Tax Configuration Workbook.

Example of Creating Tax Setup Using the Tax Configuration Workbook

This example shows how you can create standard sales tax rates within the US using the Tax Configuration Workbook. You can create sales tax rates at state, county, and city levels using this method.

Here's a summary of key decisions you make in this scenario:

Decision to Consider In This Example

What tax setup are you creating?

Tax Rates

Do you have exception rules for calculating US sales tax on transactions?

No

Do you use tax partner content?

No

Creating Tax Setup

Follow these steps to create tax rates in the Tax Configuration Workbook:

  1. Navigate to the Manage Tax Regimes page.

  2. Click the Rapid Setup Spreadsheets button and select Download Tax Configuration Workbook.

  3. Save the Tax Configuration Workbook in your local directory.

  4. Review the details on the Instructions sheet of the workbook.

  5. For the Manage Tax Regimes and Manage Taxes worksheets, use the predefined content for the US sales tax. You can modify or delete the predefined content where needed.

  6. Use the instructions and the column help text to populate the required setups in the Manage Rates worksheet.

  7. After completing the Tax Rates worksheet, go to Instructions sheet again.

  8. Click Generate CSV File. It performs theses actions:

    • Saves the entire Tax Configuration Workbook data in a comma separated values (CSV) file.

    • Saves the CSV file into a single compressed file attachment.

  9. Save the compressed file attachment in your local directory.

  10. Click the Rapid Setup Spreadsheets button and select Upload Tax Configuration Workbook.

  11. Select the compressed file that you saved earlier.

  12. Click Open and then click Upload.

  13. Note the process ID and click the Monitor Upload and Download Processes tab.

  14. Click Refresh and ensure that the process ID completes with a Succeeded status.

    • If the status of the upload process is Succeeded, you can view your setups using the search criteria on the page.

    • If the status of the upload process isn't Succeeded, your upload has failed. Check the details in the corresponding error log, correct any file errors, and reupload the file.

Example of Creating Tax Setup Using Tax Partner Content in the Tax Configuration Workbook

This example shows how to create standard sales tax jurisdictions and tax rates within the US using tax partner content in the Tax Configuration Workbook. You can create sales tax jurisdictions at state, county, and city levels using this method.

Here's a summary of key decisions you make in this scenario:

Decision to Consider In This Example

What tax setup are you creating?

  • Tax regime

  • Taxes

  • Tax jurisdictions

  • Tax rates

Do you have exception rules for calculating US sales tax on transactions?

No

Do you use tax partner content?

Yes

Prerequisites

Before you begin, you must obtain the tax data content required to populate the Tax Configuration Workbook template. Contact your tax partner representatives to get these details.

Creating Tax Setup

Follow these steps to create tax setups using tax partner content in the Tax Configuration Workbook:

  1. Open the Tax Configuration Workbook provided by your tax partner and go to the Instructions sheet.

  2. Click Generate CSV File. It performs these actions:

    • Saves the entire Tax Configuration Workbook data in a comma separated values (CSV) file.

    • Saves the CSV file into a single compressed file attachment.

  3. Save the compressed file attachment in your local directory.

  4. On the Manage Tax Regimes page, click the Rapid Setup Spreadsheets button and select Upload Tax Configuration Workbook.

  5. Select the compressed file that you saved earlier.

  6. Click Open and then click Upload.

  7. Note the process ID and go to the Monitor Upload and Download Processes tab.

  8. Click Refresh and ensure that the process ID completes with a Succeeded status.

    • If the status of the upload process is Succeeded, you can view your setups using the search criteria on the page.

    • If the status of the upload process isn't Succeeded, your upload has failed. Check the details in the corresponding error log, correct any file errors, and reupload the file.

Use the Tax Implementation Workbook to upload the following items into Oracle Fusion Tax or supporting products such as the Oracle Fusion Trading Community Model (party classifications) or Oracle Fusion Inventory (product fiscal classifications):

  • Tax regime subscriptions

  • Tax registrations

  • Tax exemptions

  • Party classifications

  • Tax reporting codes

  • Tax payer identifiers

  • Product fiscal classifications

  • Tax rules

For example, use the Tax Implementation Workbook to assign your particular business units or legal entities to a tax regime to calculate taxes on transactions.

Tax Implementation Workbook Worksheets

The Tax Implementation Workbook is a Microsoft Excel spreadsheet template with nine tax setup worksheets:

Worksheet Implementation Notes

Tax Regime Subscriptions

Assign single or multiple business units or legal entities to a tax regime.

Party Tax Profile Controls

Create party tax profiles for legal reporting units, third parties, and third-party sites where needed.

This worksheet is not used regularly because party tax profiles are usually created automatically when the core baseline entity is created. For example, a legal reporting unit party tax profile is created automatically when you create the corresponding legal entity as part of the standard enterprise structure configuration.

In exceptional cases where party tax profiles are not created automatically, unhide and use this worksheet.

Tax Registrations

Assign tax registrations for first-party legal reporting units, third parties, and third-party sites for tax determination or self-assessment of taxes. Setting up tax registrations is optional.

Tax Exemptions

Create tax exemption configuration for third parties and third-party sites. Setting up tax exemptions is optional.

For example, the configuration of state-level customer exemption certificates in the United States. When an exemption is granted to a customer through an exemption certificate, the exemption certificate information is uploaded for a specific state. You can also apply the exemption certificate at all lower levels within the state such as all county and city levels.

For a blanket customer exemption certificate that is not state-specific, no tax jurisdiction information must be specified.

Party Classifications

Create party fiscal classifications for subsequent use in tax rules having a party fiscal classification determining factor class.

Creation of party fiscal classifications is supported for legal reporting units, legal entities, third parties, and third-party sites. However, party fiscal classifications in tax rules that apply to a large grouping of the third party and third-party sites are typically created for third parties and third-party sites such as customers, customer sites, suppliers, or supplier sites. The tax rules which use party fiscal classifications are defined using the Tax Rules worksheet while the prerequisite party fiscal classifications referenced in the tax rules are defined in the Party Classifications worksheet.

The tax rules which use party fiscal classifications are defined using the tax rules worksheet while the prerequisite party fiscal classifications referenced in the tax rules are defined in the party classifications worksheet.

Tax Reporting Codes

Create tax reporting codes and tax reporting types for downstream use in tax reports.

Tax reporting types capture additional tax information on transactions for your tax reports. You can use tax reporting types for your internal reporting needs and to fulfill country-specific reporting requirements. You may create tax reporting codes for a tax reporting type to provide additional granularity for tax reporting.

Tax Payer Identifiers

Define specific Taxpayer IDs for third parties and third-party sites for purposes of reporting.

Product Fiscal Classifications

Create product fiscal classifications for subsequent use in tax rules having a product inventory linked determining factor class.

In practice, product fiscal classifications are created to categorize a group of individual items associated with an inventory catalog for which there is similar tax treatment across the majority of the individual items. In this context, items could be specific goods or services and the product fiscal classifications could be a corresponding categorization of those goods or services, which are treated similarly from a tax determination perspective.

The tax rules that use product fiscal classifications are defined using the Tax Rules worksheet. The prerequisite product fiscal classifications referenced in the tax rules are defined in the Product Fiscal Classifications worksheet.

Tax Rules

Define business-driven or industry-specific taxability or tax exemption rules.

Option 1: Prepare the tax rules.

Option 2: Use tax partner content for the Tax Implementation Workbook.

Typically, tax partners deliver their primary common configuration using the Tax Configuration Workbook. However, they may also deliver unique taxability and tax exemption rules once clients have defined their specific business and industry needs in this area.

Example of Creating Tax Setup Using the Tax Implementation Workbook

This example shows how you can create organization-specific tax regime subscriptions and tax rules using the Tax Implementation Workbook.

Scenario: You own a single business unit in the US used in processing payables invoices. You must calculate US sales tax on these transactions. You have already created the tax regime for the US sales tax. Here's what you want to do next:

  1. Assign this business unit to the tax regime.

  2. Set up a basic tax rule.

This table gives you a summary of key decisions you make in this scenario:

Decision to Consider In This Example

What tax setup are you creating?

  • Tax regime subscription

  • Tax rule

Do you have an existing legal entity or business unit you want to subscribe to this tax regime?

Yes, a business unit

Prerequisites

You must first create your required foundation tax setups, including any among these:

  • Tax regimes

  • Taxes

  • Tax statuses

  • Tax jurisdictions

  • Tax rates

Creating Tax Setup

Follow these steps to create tax regime subscriptions and tax rules in the Tax Implementation Workbook:

  1. Navigate to the Manage Tax Regimes page.

  2. Click the Rapid Setup Spreadsheets button and select Download Tax Implementation Workbook.

  3. Save the Tax Implementation Workbook in your local directory.

  4. Review the details on Instructions sheet of the workbook.

  5. Use the instructions and the column help text to populate the required setups in the Manage Tax Regime Subscriptions and Tax Rules worksheets.

  6. After completing the Manage Tax Regime Subscriptions and Tax Rules worksheets, go to the Instructions sheet again.

  7. Click Generate CSV File. It performs these actions:

    • Saves the entire Tax Implementation Workbook data in a comma separated values (CSV) file.

    • Saves the CSV file into a single compressed file attachment.

  8. Save the compressed file attachment in your local directory.

  9. Click the Rapid Setup Spreadsheets button and select Upload Tax Implementation Workbook.

  10. Select the compressed file that you saved earlier.

  11. Click Open and then click Upload.

  12. Note the process ID and click the Monitor Upload and Download Processes tab.

  13. Click Refresh and ensure that the process ID completes with a Succeeded status.

    • If the status of the upload process is Succeeded, you can view your setups using the search criteria on the page.

    • If the status of the upload process isn't Succeeded, your upload has failed. Check the details in the corresponding error log, correct any file errors, and reupload the file.

FAQs for Define Taxes for Rapid Implementation

Can I only use the rapid implementation task list to create my tax configuration?

No, you don't have to use the rapid implementation task list to create your tax configuration. You can also configure taxes using these task lists:

  • Define Tax Configuration task list

  • Define Advanced Tax Configuration task list

Alternatively, you can search for a specific individual task in Setup and Maintenance work area.

However, using the rapid implementation task list has its own advantages. It greatly speeds up and simplifies the transaction tax implementation process. It only includes setup tasks that are required and most frequently used in implementation scenarios.

You can use the Tax Configuration Workbook to upload all common tax setups into Oracle Tax. For example, consider a 4% sales tax rate that generally applies to all customer sales transactions taking place within the state of Alabama. Use the workbook to upload this.

On the other hand, the Tax Implementation Workbook is for uploading only tax setups specific to your organization. Use this workbook to upload details into Oracle Tax as well as other supporting products. For example, you may want to calculate taxes on receivables or payables transactions for your particular business units or legal entities. All you have to do is use this workbook to assign these entities to a tax regime.

What happens during spreadsheet upload?

During a spreadsheet upload, the process automatically compares the spreadsheet records with the preexisting configuration. If an individual spreadsheet record already exists, the application doesn't insert that spreadsheet record again. The application only uploads new spreadsheet records for which a configuration doesn't already exist.

Can I update an existing tax configuration using spreadsheet upload?

Yes, you can use spreadsheet upload to update an existing tax configuration for specific tax rate and tax recovery rate fields. Here's a list of worksheets and the fields that you can update using these worksheets:

Worksheet Fields

Manage Rates

  • Tax Rate

  • Set as Default Rate

  • Default Recovery Rate Code

  • Effective End Date

  • Inner City Jurisdiction

Manage Tax Recovery Rates

  • Tax Rate

  • Set as Default Rate

How can I identify the cause of an error during a tax spreadsheet upload?

You can review spreadsheet upload errors on the Manage Tax Regimes page. Just go to the Monitor Upload and Download Processes tab and open the output file and the log file generated for your process ID. All you have to do is just correct the errors in the spreadsheet and upload it again.