Search Results tax_rate
The AR_LOCATION_RATES_OLD
table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical data structure within the Accounts Receivable (AR) module. It serves as a historical repository for tax rate assignments associated with customer locations, enabling compliance with tax regulations and facilitating accurate tax calculations during invoice processing. This table is primarily utilized when tax rate updates occur, preserving previous rate configurations for audit trails and reporting purposes.
Table Structure and Key Columns
The AR_LOCATION_RATES_OLD
table contains the following essential columns:
- LOCATION_RATE_ID: Primary key identifier for the tax rate record.
- LOCATION_ID: Foreign key linking to
AR_LOCATIONS
, identifying the customer site. - TAX_CODE: The tax jurisdiction code applied to the location.
- RATE: The historical tax rate percentage stored for reference.
- START_DATE and END_DATE: Defines the effective period of the tax rate.
- CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY: Standard Oracle audit columns.
Functional Role in Tax Management
When tax rates are modified for a customer location via the AR Tax Rates form or APIs, Oracle EBS archives the superseded rates in AR_LOCATION_RATES_OLD
. This ensures:
- Historical Accuracy: Retains prior tax configurations for financial reporting and compliance.
- Audit Compliance: Supports tax audits by providing a traceable record of rate changes.
- Data Integrity: Prevents loss of critical tax data during updates.
Integration with Other Modules
The table interacts with:
- AR_LOCATIONS: Contains customer address details linked via
LOCATION_ID
. - AR_TAX_CODES: Provides tax jurisdiction definitions referenced by
TAX_CODE
. - AR_TRANSACTION_HISTORY: May reference historical rates for invoice adjustments.
Technical Considerations
In EBS 12.1.1 and 12.2.2, the table is managed through:
- Tax Rate Maintenance Forms: Manual updates trigger archival to
AR_LOCATION_RATES_OLD
. - APIs: Programmatic rate changes via
AR_TAX_PUB
package handle archival automatically. - Purge Mechanisms: Requires custom scripts to manage data growth, as Oracle does not provide standard purge programs for this table.
Customization and Extension Points
Common extensions include:
- Triggers: Additional validation during rate changes.
- Reports: Custom tax history reports querying this table.
- Data Migrations: Mapping legacy tax rates during implementations.
Conclusion
The AR_LOCATION_RATES_OLD
table is a vital component of Oracle EBS's tax infrastructure, ensuring regulatory compliance and data continuity. Its design supports complex tax scenarios while maintaining a clear audit trail. Administrators should monitor its growth and implement retention policies to balance storage needs with compliance requirements.
-
View: AR_POSTAL_CODE_RANGES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_POSTAL_CODE_RANGES_V, object_name:AR_POSTAL_CODE_RANGES_V, status:VALID, product: AR - Receivables , description: (Release 115 Only) , implementation_dba_data: APPS.AR_POSTAL_CODE_RANGES_V ,
-
View: AR_POSTAL_CODE_RANGES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_POSTAL_CODE_RANGES_V, object_name:AR_POSTAL_CODE_RANGES_V, status:VALID, product: AR - Receivables , description: (Release 115 Only) , implementation_dba_data: APPS.AR_POSTAL_CODE_RANGES_V ,
-
View: AR_AP_TAX_CODES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_AP_TAX_CODES_V, object_name:AR_AP_TAX_CODES_V, status:VALID, product: AR - Receivables , implementation_dba_data: APPS.AR_AP_TAX_CODES_V ,
-
View: AR_AP_TAX_CODES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_AP_TAX_CODES_V, object_name:AR_AP_TAX_CODES_V, status:VALID, product: AR - Receivables , implementation_dba_data: APPS.AR_AP_TAX_CODES_V ,
-
View: AR_XML_INVOICE_TAX_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_XML_INVOICE_TAX_V, object_name:AR_XML_INVOICE_TAX_V, status:VALID, product: AR - Receivables , implementation_dba_data: APPS.AR_XML_INVOICE_TAX_V ,
-
View: AR_XML_INVOICE_TAX_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_XML_INVOICE_TAX_V, object_name:AR_XML_INVOICE_TAX_V, status:VALID, product: AR - Receivables , implementation_dba_data: APPS.AR_XML_INVOICE_TAX_V ,
-
View: AR_INVOICE_TAX_SUMMARY_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_INVOICE_TAX_SUMMARY_V, object_name:AR_INVOICE_TAX_SUMMARY_V, status:VALID, product: AR - Receivables , description: Collects tax information for transactions , implementation_dba_data: APPS.AR_INVOICE_TAX_SUMMARY_V ,
-
View: AR_INVOICE_TAX_SUMMARY_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_INVOICE_TAX_SUMMARY_V, object_name:AR_INVOICE_TAX_SUMMARY_V, status:VALID, product: AR - Receivables , description: Collects tax information for transactions , implementation_dba_data: APPS.AR_INVOICE_TAX_SUMMARY_V ,
-
View: ARBV_AR_TAX_CODES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARBV_AR_TAX_CODES, object_name:ARBV_AR_TAX_CODES, status:VALID, product: AR - Receivables , description: - Retrofitted , implementation_dba_data: APPS.ARBV_AR_TAX_CODES ,
-
View: ARBV_AR_TAX_CODES
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARBV_AR_TAX_CODES, object_name:ARBV_AR_TAX_CODES, status:VALID, product: AR - Receivables , description: - Retrofitted , implementation_dba_data: APPS.ARBV_AR_TAX_CODES ,
-
View: ARFV_AR_TAX_CODES
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARFV_AR_TAX_CODES, object_name:ARFV_AR_TAX_CODES, status:VALID, product: AR - Receivables , description: - Retrofitted , implementation_dba_data: APPS.ARFV_AR_TAX_CODES ,
-
View: ARFV_AR_TAX_CODES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARFV_AR_TAX_CODES, object_name:ARFV_AR_TAX_CODES, status:VALID, product: AR - Receivables , description: - Retrofitted , implementation_dba_data: APPS.ARFV_AR_TAX_CODES ,
-
View: AR_CASH_RECEIPTS_MRC_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_CASH_RECEIPTS_MRC_V, object_name:AR_CASH_RECEIPTS_MRC_V, status:VALID, product: AR - Receivables , implementation_dba_data: APPS.AR_CASH_RECEIPTS_MRC_V ,
-
View: AR_CASH_RECEIPTS_MRC_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_CASH_RECEIPTS_MRC_V, object_name:AR_CASH_RECEIPTS_MRC_V, status:VALID, product: AR - Receivables , implementation_dba_data: APPS.AR_CASH_RECEIPTS_MRC_V ,
-
View: AR_CASH_RECEIPTS_ALL_MRC_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_CASH_RECEIPTS_ALL_MRC_V, object_name:AR_CASH_RECEIPTS_ALL_MRC_V, status:VALID, product: AR - Receivables , implementation_dba_data: APPS.AR_CASH_RECEIPTS_ALL_MRC_V ,
-
View: AR_CASH_RECEIPTS_ALL_MRC_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_CASH_RECEIPTS_ALL_MRC_V, object_name:AR_CASH_RECEIPTS_ALL_MRC_V, status:VALID, product: AR - Receivables , implementation_dba_data: APPS.AR_CASH_RECEIPTS_ALL_MRC_V ,
-
Table: AR_LOCATION_RATES_OLD
12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_LOCATION_RATES_OLD, object_name:AR_LOCATION_RATES_OLD, status:VALID, product: AR - Receivables , description: Sales tax rates for each tax authority , implementation_dba_data: AR.AR_LOCATION_RATES_OLD ,
-
Table: AR_LOCATION_RATES_OLD
12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_LOCATION_RATES_OLD, object_name:AR_LOCATION_RATES_OLD, status:VALID, product: AR - Receivables , description: Sales tax rates for each tax authority , implementation_dba_data: AR.AR_LOCATION_RATES_OLD ,
-
Table: AR_LOCATION_RATES
12.2.2
product: AR - Receivables , description: Sales tax rates for each tax authority , implementation_dba_data: Not implemented in this database ,
-
Table: AR_LOCATION_RATES
12.1.1
product: AR - Receivables , description: Sales tax rates for each tax authority , implementation_dba_data: Not implemented in this database ,
-
View: AR_TAX_SUMM_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_TAX_SUMM_V, object_name:AR_TAX_SUMM_V, status:VALID, product: AR - Receivables , description: (Release 10SC Only) , implementation_dba_data: APPS.AR_TAX_SUMM_V ,
-
View: AR_TAX_SUMM_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_TAX_SUMM_V, object_name:AR_TAX_SUMM_V, status:VALID, product: AR - Receivables , description: (Release 10SC Only) , implementation_dba_data: APPS.AR_TAX_SUMM_V ,
-
View: AR_AEL_GL_REC_ALL_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_AEL_GL_REC_ALL_V, object_name:AR_AEL_GL_REC_ALL_V, status:VALID, product: AR - Receivables , implementation_dba_data: APPS.AR_AEL_GL_REC_ALL_V ,
-
View: AR_AEL_GL_REC_ALL_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_AEL_GL_REC_ALL_V, object_name:AR_AEL_GL_REC_ALL_V, status:VALID, product: AR - Receivables , implementation_dba_data: APPS.AR_AEL_GL_REC_ALL_V ,
-
View: ARBV_TAXES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARBV_TAXES, object_name:ARBV_TAXES, status:VALID, product: AR - Receivables , description: This shows detailed tax information associated with transaction line items. , implementation_dba_data: APPS.ARBV_TAXES ,
-
View: AR_GTA_GT_LINES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_GTA_GT_LINES_V, object_name:AR_GTA_GT_LINES_V, status:VALID, product: AR - Receivables , description: Detail information for GTA invoice and VAT invoice , implementation_dba_data: APPS.AR_GTA_GT_LINES_V ,
-
View: ARBV_TAXES
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARBV_TAXES, object_name:ARBV_TAXES, status:VALID, product: AR - Receivables , description: This shows detailed tax information associated with transaction line items. , implementation_dba_data: APPS.ARBV_TAXES ,
-
View: AR_INVOICE_LINES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_INVOICE_LINES_V, object_name:AR_INVOICE_LINES_V, status:VALID, product: AR - Receivables , description: Collects invoice line item information , implementation_dba_data: APPS.AR_INVOICE_LINES_V ,
-
View: TAX_ADJUSTMENTS_V_V
12.1.1
product: AR - Receivables , description: Release 11.5 , implementation_dba_data: Not implemented in this database ,
-
View: AR_INVOICE_LINES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_INVOICE_LINES_V, object_name:AR_INVOICE_LINES_V, status:VALID, product: AR - Receivables , description: Collects invoice line item information , implementation_dba_data: APPS.AR_INVOICE_LINES_V ,
-
View: TAX_ADJUSTMENTS_V
12.1.1
product: AR - Receivables , description: Approved Tax Adjustments affecting Transactions or Receipt reversals , implementation_dba_data: Not implemented in this database ,
-
View: TAX_ADJUSTMENTS_V
12.2.2
product: AR - Receivables , description: Approved Tax Adjustments affecting Transactions or Receipt reversals , implementation_dba_data: Not implemented in this database ,
-
View: TAX_ADJUSTMENTS_V_V
12.2.2
product: AR - Receivables , description: Release 11.5 , implementation_dba_data: Not implemented in this database ,
-
View: TAX_LINES_RECURR_INVOICE_V
12.2.2
product: AR - Receivables , description: Lines subject to tax for the concurrent program Recurring Invoices (copy invoices) , implementation_dba_data: Not implemented in this database ,
-
View: ARBR_DOCUMENT_LINES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARBR_DOCUMENT_LINES_V, object_name:ARBR_DOCUMENT_LINES_V, status:VALID, product: AR - Receivables , description: Creation of ARBR_DOCUMENT_LINES_V view this is view is required for payment settlemnt , implementation_dba_data: APPS.ARBR_DOCUMENT_LINES_V ,
-
View: ARBR_DOCUMENT_LINES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARBR_DOCUMENT_LINES_V, object_name:ARBR_DOCUMENT_LINES_V, status:VALID, product: AR - Receivables , description: Creation of ARBR_DOCUMENT_LINES_V view this is view is required for payment settlemnt , implementation_dba_data: APPS.ARBR_DOCUMENT_LINES_V ,
-
View: TAX_ADJUSTMENTS_V_A
12.2.2
product: AR - Receivables , description: Release 11.5 , implementation_dba_data: Not implemented in this database ,
-
View: AR_DOCUMENT_LINES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_DOCUMENT_LINES_V, object_name:AR_DOCUMENT_LINES_V, status:VALID, product: AR - Receivables , implementation_dba_data: APPS.AR_DOCUMENT_LINES_V ,
-
View: TAX_ADJUSTMENTS_V_A
12.1.1
product: AR - Receivables , description: Release 11.5 , implementation_dba_data: Not implemented in this database ,
-
View: TAX_LINES_RECURR_INVOICE_V
12.1.1
product: AR - Receivables , description: Lines subject to tax for the concurrent program Recurring Invoices (copy invoices) , implementation_dba_data: Not implemented in this database ,
-
View: AR_GTA_TRX_LINES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_GTA_TRX_LINES_V, object_name:AR_GTA_TRX_LINES_V, status:VALID, product: AR - Receivables , description: Detail information for GTA invoice and VAT invoice , implementation_dba_data: APPS.AR_GTA_TRX_LINES_V ,
-
View: TAX_LINES_DELETE_V
12.1.1
product: AR - Receivables , description: Lines to retax after a user manually updates invoice header attributes , implementation_dba_data: Not implemented in this database ,
-
View: TAX_LINES_DELETE_V_V
12.1.1
product: AR - Receivables , description: Release 11 , implementation_dba_data: Not implemented in this database ,
-
View: TAX_LINES_DELETE_V_A
12.1.1
product: AR - Receivables , description: Release 11 , implementation_dba_data: Not implemented in this database ,
-
View: TAX_LINES_DELETE_V
12.2.2
product: AR - Receivables , description: Lines to retax after a user manually updates invoice header attributes , implementation_dba_data: Not implemented in this database ,
-
View: AR_DOCUMENT_LINES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_DOCUMENT_LINES_V, object_name:AR_DOCUMENT_LINES_V, status:VALID, product: AR - Receivables , implementation_dba_data: APPS.AR_DOCUMENT_LINES_V ,
-
View: ARFV_TAXES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARFV_TAXES, object_name:ARFV_TAXES, status:VALID, product: AR - Receivables , implementation_dba_data: APPS.ARFV_TAXES ,
-
View: TAX_LINES_DELETE_V_A
12.2.2
product: AR - Receivables , description: Release 11 , implementation_dba_data: Not implemented in this database ,
-
View: TAX_LINES_DELETE_V_V
12.2.2
product: AR - Receivables , description: Release 11 , implementation_dba_data: Not implemented in this database ,
-
View: ARFV_TAXES
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.ARFV_TAXES, object_name:ARFV_TAXES, status:VALID, product: AR - Receivables , implementation_dba_data: APPS.ARFV_TAXES ,