Results for “zip_code”

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

Overview

The APPS.HRIFV_US_FEDREP_GEN_H_LOCEXP view is a reporting object delivered with the Oracle E-Business Suite Human Resources Intelligence (HRI) product family, now classified as obsolete. It is a read-only view whose name reflects its purpose: a US federal reporting extract (US_FEDREP) of general (GEN) location hierarchy data (H_LOCEXP). In Oracle EBS 12.1.1 and 12.2.2 the view continues to reside in the APPS schema with status VALID, meaning related source objects remain available even though the HRI module itself is no longer actively supported.

The view presents a flattened, denormalized picture of US-style locations defined in Oracle HRMS. Rather than exposing the raw structure of the location tables, it joins the base location record to its translated (language-specific) counterpart and surfaces both the short location code and the longer descriptive text, which is why a search for location_description resolves to this object. The /* $HEADER */ comment embedded in the view text, dated 2001, confirms its long-standing lineage inside the HRI federal reporting stack.

Underlying Base Objects

The documented base objects referenced by this view are:

• HR_LOCATIONS_ALL (synonym) — the primary location entity, providing address, region, country, postal code, style, tax name, and inactive date.
• HR_LOCATIONS_ALL_TL (synonym) — the translated table supplying the LOCATION_CODE and DESCRIPTION values for the session language.
• HRI_GEN_HRCHY_SUMMARY (synonym) — used in a negative subquery to exclude locations already summarized within the HRI hierarchy, preventing duplicate reporting.
• HR_GENERAL (package) — invoked through HR_GENERAL.DECODE_LOOKUP to translate the region-2 state code into a readable state name using the US_STATE lookup type.

The join condition links LOCATION_ID across the base and translated entities, and the language filter LOCT.LANGUAGE = USERENV('LANG') restricts results to the caller's session language. Only records where STYLE = 'US' are returned, confirming the view's federal-reporting scope.

Key Columns

• LOCATION_NAME — sourced from LOCT.LOCATION_CODE; the short identifier for the location.
• LOCATION_DESCRIPTION — sourced from LOCT.DESCRIPTION; the free-text descriptive name, the column referenced by the "location_description" search.
• ADDRESS_LINE_1, ADDRESS_LINE_2, ADDRESS_LINE_3 — the three physical address lines of the location.
• CITY, COUNTY — mapped from TOWN_OR_CITY and REGION_1 respectively.
• STATE_NAME and STATE_CODE — the decoded US_STATE lookup value and the raw REGION_2 value.
• COUNTRY, ZIP_CODE — country and postal code for the address.
• INACTIVE_DATE, ADDRESS_STYLE, DEFAULT_TAX_CODE — status/expiry date, the HR location style, and the tax name.
• _DF — the descriptive flexfield descriptor marker '_DF:PER:HR_LOCATIONS:LOC', indicating the location flexfield context.
• LOCATION_ID, BUSINESS_GROUP_ID — the primary key and the owning business group.

Common Use Cases and Queries

This view is typically consumed by federal and regulatory reporting extracts that require a clean list of active US work locations, including tax and address detail. It is useful for reconciling HRMS location setup against payroll and tax reporting, and for producing state-by-state location registries using the decoded state name.

SELECT location_name,
       location_description,
       city,
       state_name,
       zip_code,
       default_tax_code
  FROM apps.hrifv_us_fedrep_gen_h_locpexp
 WHERE inactive_date IS NULL
 ORDER BY state_code, city;

Because the view is defined WITH READ ONLY, all access is query-only; it is intended strictly for reporting and integration extracts rather than transactional updates. Given the obsolete HRI status, organizations on 12.2.2 should confirm whether successor reporting objects are preferred before building new dependencies on this view.