Results for “rateco”

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

Overview

RATECO is a Receivables (AR) reporting view in Oracle E-Business Suite 12.1.1 and 12.2.2 that consolidates tax rate configuration data across two related verticals; state-level tax rules and county-level tax rules. The view joins the RATESTATE and RATECOUNTY views so that a single query returns both the state and county rate definitions applicable to a given geographic jurisdiction. Its structure supports tax determination and audit reporting where users need to review tax rates, tax types, effective dates, rounding rules, and service tax defaults side by side.

The view plays an important role in reporting and integration scenarios where external tax engines, reporting tools, or reconciliation processes require a flattened, denormalized snapshot of rate setup. Rather than querying the state and county objects separately and manually correlating effective dates, the RATECO view presents the combined result set keyed on geographic state and county identifiers.

Underlying Base Objects

According to the ETRM metadata, the view text is defined over two referenced objects: RATESTATE and RATECOUNTY. Both are themselves views or view-like objects exposing tax rate attributes. The metadata indicates that no base objects are separately documented, and the view is marked "Not implemented in this database," meaning the object definition exists in the Oracle data model documentation but the view is not instantiated in the queried environment.

RATESTATE supplies the state-level attributes, including GEOSTATE, RECEFFDATE, rate tiers one through five, tax type and tax type identifiers, effective dates, interstate and intrastate flags, rental and lease tax types, service transfer rules, maximum rule, and rounding rule. RATECOUNTY supplies the county-level attributes, including GEOCOUNTY, its own effective date flag, rate tiers one through seven, tax types, effective dates, interstate and intrastate codes, local administration flags, tax base amount, maximum tax code, GST flag, filing code, service tax default, and service maximum base amount. The join correlates the state and county records so that a row expresses the combined tax configuration for a location.

Key Columns

• GEOSTATE / GEOCOUNTY — Geographic identifiers for the state and county jurisdiction.
• RECEFFDATE / CORECEFFDATE — Effective dates for the state and county rate records respectively.
• STRATE1 through STRATE5 / CORATE1 through CORATE7 — Tiered rate values at state and county level.
• STRATETYPE* / CORATETYPE* — Rate type classification for each tier.
• STRATETAXTYPE* / CORATETAXTYPE* — Tax type associated with each tier.
• STRATEEFFDATE* / CORATEEFFDATE* — Per-tier effective dates.
• STINTERSTATE / COINTERSTATE / COINTRASTATECODE — Jurisdiction scope flags indicating whether the rate applies to interstate or intrastate transactions.
• STINTRASTATESALE / STINTRASTATERENT / STINTRASTATESERV / STINTRASTATERULE — Intrastate applicability rules by transaction category.
• STRENTLEASETAXTYPE — Tax type for rental and lease transactions.
• STMAXRULE / STROUNDINGRULE — Maximum tax and rounding behavior rules.
• COISLOCALADMIN / COTAXBASEAMT / COMAXTAXCODE / COGSTFLAG / COFILINGCODE — County-level administrative, base amount, maximum tax, GST, and filing attributes.
• COSERVICETAXDEFAULT / COSERVICEMAXBASEAMT / STSERVICETAXDEFAULT — Service tax default and maximum base amount settings.

Common Use Cases and Queries

The view is commonly used to audit tax rate configuration, reconcile rates between EBS and external tax providers, and produce reporting extracts for tax filings. A representative query returns state and county rates for a jurisdiction:

• SELECT GEOSTATE, GEOCOUNTY, RECEFFDATE, CORECEFFDATE, STRATE1, CORATE1, STRATETAXTYPE1, CORATETAXTYPE1 FROM RATECO WHERE GEOSTATE = :p_state ORDER BY GEOCOUNTY, RECEFFDATE;
• SELECT GEOSTATE, GEOCOUNTY, STROUNDINGRULE, STMAXRULE, COMAXTAXCODE FROM RATECO WHERE COGSTFLAG = 'Y';
• SELECT GEOSTATE, GEOCOUNTY, STSERVICETAXDEFAULT, COSERVICETAXDEFAULT, COSERVICEMAXBASEAMT FROM RATECO WHERE COISLOCALADMIN = 'Y';

Because the view is documented as not implemented in the reference database, availability must be verified in each target environment before these queries are deployed to production reporting.