Results for “condition_value”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AP_TAX_RECVRY_RATES_ALL is a table in the AP (Payables) schema of Oracle E-Business Suite, documented as part of the E-Business Tax (ETRM) physical data model for releases 12.1.1 and 12.2.2. Its documented description is explicit: the object is no longer used. Historically, this table was part of the legacy Oracle Payables tax recovery architecture, in which recovery rules defined which portions of a recoverable tax could be reclaimed and recovery rates supplied the percentage or amount applied to those rules. Modern releases instead apply tax recovery configuration through E-Business Tax (EBTax) setup, so the object is retained for backward physical compatibility rather than for active processing.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure is satellite-leaning. The table carries descriptive and rate attributes around a single parent key rather than representing an independent business concept, so it is most naturally modeled as a satellite attached to a parent hub or link. Its foreign key to AP_TAX_RECVRY_RULES_ALL via RULE_ID supports this interpretation: the rule is the reference point, and the rate rows hang off it.

Key Information Stored

The documented physical schema contains 55 columns. The most significant are the identifiers, the segment range qualifiers, the rate attributes, and the standard EBS audit and descriptive flexfield columns. The surrogate primary key is RATE_ID, enforced by AP_TAX_RECVRY_RATES_ALL_PK. No business-key unique index is documented, so RULE_ID combined with the applicable segment range and effective dates functions as the practical business identifier.

• RATE_ID — surrogate primary key for each recovery rate row.
• RULE_ID — foreign key to AP_TAX_RECVRY_RULES_ALL; the rule to which the rate belongs.
• RECOVERY_RATE — the recovery percentage or amount applied when the rule is satisfied.
• CONCATENATED_SEGMENT_LOW / CONCATENATED_SEGMENT_HIGH — the low and high bounds of the account segment range within which the rate applies.
• ENABLED_FLAG — indicates whether the rate row is active.
• START_DATE / END_DATE — the effective date range of the rate.
• CONDITION / CONDITION_VALUE — the qualifying condition and its value that must be met for the rate to apply.
• FUNCTION — the function used in evaluating the rate condition.
• DESCRIPTION — free-text description of the rate.
• ORG_ID — the operating unit (multi-org) identifier for the row.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield context and segments.
• GLOBAL_ATTRIBUTE_CATEGORY and GLOBAL_ATTRIBUTE1–GLOBAL_ATTRIBUTE20 — global descriptive flexfield columns.

Common Use Cases and Queries

Because the table is documented as no longer used, current production queries are typically diagnostic or historical rather than functional. Typical patterns include verifying whether residual rows exist before migration or upgrade, reconciling legacy recovery configuration against EBTax setup, and confirming operating-unit scoping. A representative query joining the rate rows to their parent rules is:

• SELECT r.RATE_ID, r.RULE_ID, r.RECOVERY_RATE, r.START_DATE, r.END_DATE, r.ENABLED_FLAG FROM ap.ap_tax_recvry_rates_all r WHERE r.ORG_ID = :p_org_id AND r.ENABLED_FLAG = 'Y';
• SELECT r.RULE_ID, r.RECOVERY_RATE, r.CONCATENATED_SEGMENT_LOW, r.CONCATENATED_SEGMENT_HIGH FROM ap.ap_tax_recvry_rates_all r WHERE r.RULE_ID = :p_rule_id AND TRUNC(SYSDATE) BETWEEN r.START_DATE AND NVL(r.END_DATE, TRUNC(SYSDATE));
• SELECT COUNT(*) FROM ap.ap_tax_recvry_rates_all; to establish whether data exists before any cleanup or archive activity.

Reporting on this table should be framed as legacy data analysis only, since it does not drive tax recovery calculation in supported 12.1.1 or 12.2.2 processing.

Related Objects

Relationship coverage is intentionally narrow. The single documented foreign key connects the rate rows to the recovery rule header, and the primary key is local. The following objects are the most significant for join and dependency analysis.

• AP_TAX_RECVRY_RULES_ALL — parent table; join on AP_TAX_RECVRY_RATES_ALL.RULE_ID = AP_TAX_RECVRY_RULES_ALL.RULE_ID.
• AP_TAX_RECVRY_RATES_ALL_PK — primary key constraint on RATE_ID, defining row uniqueness.
• E-Business Tax (EBTax) recovery configuration tables — the functional successors for recovery rates and rules in current releases.
• Payables operating unit and organization views keyed on ORG_ID — used for multi-org filtering of any legacy rows.
• Standard EBS audit and DFF/global DFF metadata — governs the ATTRIBUTE and GLOBAL_ATTRIBUTE columns.

Given the documented description and the restricted relationship set, this table should be treated as a legacy artifact. Any integration or reporting design in 12.1.1 or 12.2.2 should target EBTax recovery setup rather than AP_TAX_RECVRY_RATES_ALL.