Search Results ap_tax_recvry_rates_all




Overview
Explore in AI Chat

Overview

The table AP_TAX_RECVRY_RATES_ALL is a legacy data object within the Oracle E-Business Suite (EBS) Payables (AP) module. According to the official ETRM documentation for versions 12.1.1 and 12.2.2, its status is explicitly noted as "No longer used." Historically, it was designed to store tax recovery rate details, which are specific percentages or rules for reclaiming taxes (such as Value Added Tax or Goods and Services Tax) on invoices. Its primary role was to support tax recovery functionality, allowing organizations to manage and apply different rates for tax reclaims based on various rules and jurisdictions. The inclusion of "_ALL" in the table name signifies it is a multi-organization structure, capable of storing data partitioned by the ORG_ID column for multiple operating units.

Key Information Stored

While the detailed column list is not provided in the excerpt, the documented primary and foreign key relationships indicate the core data elements. The primary key column is RATE_ID, uniquely identifying each tax recovery rate record. A critical foreign key column is RULE_ID, which links each rate to a corresponding rule defined in the AP_TAX_RECVRY_RULES_ALL table. Typically, such a table would also store columns for the effective recovery rate percentage (e.g., RATE), effective start and end dates (EFFECTIVE_START_DATE, EFFECTIVE_END_DATE), and the ORG_ID for multi-org support. Given the table's deprecated status, these columns are likely vestigial in modern implementations, with the functionality superseded by other tax engines or tables within EBS.

Common Use Cases and Queries

As the table is documented as no longer used, direct operational or reporting use cases in current EBS environments are non-existent. Its presence is primarily for backward compatibility or data migration purposes. In a historical context, a typical query might have joined this table to its parent rules table to retrieve all active rates for a specific tax recovery rule. A sample analytical pattern from a legacy system could have been:

  • SELECT r.rule_name, rt.rate, rt.effective_start_date FROM ap_tax_recvry_rates_all rt, ap_tax_recvry_rules_all r WHERE rt.rule_id = r.rule_id AND sysdate BETWEEN rt.effective_start_date AND nvl(rt.effective_end_date, sysdate);

Today, technical consultants or DBAs might query this table only during data audits, legacy system analysis, or to confirm the absence of active data before considering its cleanup.

Related Objects

The documented relationship data specifies a clear foreign key dependency from AP_TAX_RECVRY_RATES_ALL to another table. The related objects are:

  • AP_TAX_RECVRY_RULES_ALL: This is the parent table for tax recovery rules. The foreign key relationship is defined on the column AP_TAX_RECVRY_RATES_ALL.RULE_ID, which references the AP_TAX_RECVRY_RULES_ALL table. This indicates that each rate record was a child of a specific master recovery rule.

No other foreign keys or dependencies are listed in the provided metadata. Given the table's deprecated status, it is unlikely to be referenced by newer application interfaces or public APIs. Any existing references would be confined to legacy customizations or seed data.