Showing posts with label Oracle E-Business Tax. Show all posts
Showing posts with label Oracle E-Business Tax. Show all posts
Friday, April 12, 2013
In R12, we have E-Business Tax module to maintain the Tax
Details. Every TAX_RATE_CODE is attached to a TAX_REGIME and in-turn a
TAX_REGIME is tagged to one or more Operating Units. Below query is used to
list down the TAX_RATE_CODES attached to a Operating Unit.
SELECT hou.organization_id,
hou.set_of_books_id,
hou.default_legal_context_id,
hou.short_code,
hou.NAME,
zru.first_pty_org_id
party_tax_profile_id,
zru.tax_regime_id,
zru.tax_regime_code,
zxr.tax,
zxr.tax_status_code,
zxr.tax_rate_code,
zxr.tax_jurisdiction_code,
zxr.rate_type_code,
zxr.recovery_type_code,
zxr.percentage_rate,
zxr.tax_rate_id,
zxr.effective_from,
zxr.effective_to,
zxr.active_flag,
zxr.attribute3,
zxr.offset_tax,
zxr.offset_status_code,
zxr.offset_tax_rate_code
FROM zx_party_tax_profile ptp,
zx_subscription_details zsd,
hr_operating_units hou,
zx_regimes_usages zru,
zx_rates_vl zxr
WHERE zxr.tax_regime_code = zru.tax_regime_code
AND ptp.party_type_code = 'OU'
AND ptp.party_id = hou.organization_id
AND zru.first_pty_org_id = ptp.party_tax_profile_id
AND zru.first_pty_org_id = zsd.first_pty_org_id
AND zsd.tax_regime_code = ZRU.TAX_REGIME_CODE
AND zsd.parent_first_pty_org_id =
-99
AND SYSDATE BETWEEN zsd.effective_from AND NVL(zsd.effective_to,SYSDATE);
Below query is to list down the tax account based on
Operating Unit,
SELECT hou.organization_id,
hou.NAME,
tax_account_ccid,
zxr.tax,
zxr.tax_status_code,
zxr.tax_regime_code,
zxr.tax_rate_code,
zxr.tax_jurisdiction_code,
zxr.rate_type_code,
zxr.percentage_rate,
zxr.tax_rate_id,
zxr.effective_from,
zxr.effective_to,
zxr.active_flag
FROM zx_rates_vl zxr,
zx_accounts b,
hr_operating_units hou
WHERE b.internal_organization_id =
hou.organization_id
AND b.tax_account_entity_code = 'RATES'
AND b.tax_account_entity_id =
zxr.tax_rate_id
AND zxr.active_flag = 'Y'
AND SYSDATE BETWEEN zxr.effective_from AND nvl(zxr.effective_to, SYSDATE);
Friday, April 12, 2013 by Team search · 4
Monday, May 3, 2010
Below are steps needed to be followed for loading Tax Information into Oracle Apps R12.
1) Please get data file from tax partners (Vertex or Tax ware) in R12 format.
2) Copy file to a Linux or Unix directory. Filename - *.dat. Please note that loading the data file into interface table is a part of the Request Set and will not need to be done manually.
3) Click "Tax Managers" responsibility
4) Click "Schedule Request Set" link under "Requests"
5) Select "E-Business US
In the first stage,
a) Enter "File Location and Name" parameter (directory in which partner data file has been placed, filename could be *.dat) e.g. "/home/user/zx/TMD2.dat" ,
b) select "2" (for Tax ware) or "1" (for Vertex) for the "Tax Content Source" parameter
c) select a Tax Regime Code (new or migrated) for "Tax Content Source Tax Regime Code" parameter.
Click "Next" twice to submit the request.
In the first stage,
a) Enter "File Location and Name" parameter (directory in which partner data file has been placed, filename could be *.dat) e.g. "/home/user/zx/TMD2.dat" ,
b) select "2" (for Tax ware) or "1" (for Vertex) for the "Tax Content Source" parameter
c) select a Tax Regime Code (new or migrated) for "Tax Content Source Tax Regime Code" parameter.
Click "Next" twice to submit the request.
6) Check the status of programs
7) After completion, data will be loaded into TCA Geography model and Ebiz Tax entities - Tax, Status, Rates, and Jurisdictions.
Below Metalink notes on R12-Ebusiness tax functionality, may be helpful for fulfilling your requirements. Also find the attached Tax API list for Receivable module. Using E-business tax, we can calculate tax other than US also, example see the Metalink note: 577996.1 for implementing e-business tax for Canada
Ø Note: 577996.1 - Release 12: Integrating E-Business Tax with Oracle Receivables and Payables for Country CANADA
Ø R12 E-Bus Tax Partner Integration; Troubleshooting Tax Default Inconsistencies on Sales Orders Specific to Subscriptions of Service Providers [ID 471813.1]
Ø Using Taxware and Troubleshooting the Integration with R12 E-Business Tax (EBTax) [ID 806575.1].
Ø WHITE PAPER : How to Load a custom rate file in R12 E-Business Tax
Ø How Do I Upload Tax Data For Transactions to Receivables From a Legacy System If Oracle Does Not Provide An API? [ID 759708.1]
Monday, May 3, 2010 by Team search · 0
Subscribe to:
Posts (Atom)
Disclaimer
The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.