Search Results home_postal_code

Overview

APPS.JTF_RS_EMP_ADDRESS_VL is a public Oracle E-Business Suite view owned by the APPS schema. It exposes employee address information — including home address, office location, telephone numbers, and e-mail — in a flattened, report-friendly structure. The _VL suffix identifies it as a "value list" style view, which in EBS typically denotes a view built from a translated or joined base table and commonly surfaced through descriptive flexfields, LOVs, or resource-management lookups. Because the view is documented as public, it is explicitly sanctioned for custom reporting and other read-only data requirements, avoiding the need for developers to build their own joins across the underlying HR tables. A user searching for the column keyword home_city will find it exposed directly here, making this view the appropriate entry point when an employee's city of residence is required. In 12.1.1 and 12.2.2 the object remains VALID and is registered under FND Design Data as JTF.JTF_RS_EMP_ADDRESS_VL.

Underlying Base Objects

The view is defined over the following documented base objects:

• PER_ADDRESSES (SYNONYM) — source of street address, city, country, and postal code attributes.
• PER_PEOPLE_F (VIEW) — the date-tracked person record supplying PERSON_ID and the link to the business group; _F denotes the effective-dated (date-tracked) table structure.
• PER_PHONES (SYNONYM) — source of home, office, fax, pager, and mobile numbers.
• HR_GENERAL (PACKAGE) — HR utility functions used to resolve descriptive values.
• HR_PERSON_NAME (PACKAGE) — resolves the employee's formatted name.
• HR_SECURITY (PACKAGE) — applies the HR security profile, restricting rows to the employees a given responsibility is permitted to see.

No database object references this view; it is a terminal, read-only presentation layer. The involvement of HR_SECURITY is significant: query results are filtered by the security profile of the connected user, so a report executed under a restricted responsibility returns only authorized employees.

Key Columns

• PERSON_ID (NUMBER, 10) — person identifier; join key to PER_ALL_PEOPLE_F and other HR objects.
• HOME_CITY (VARCHAR2, 30) — city where the employee's residence is located. This is the column sought by the user.
• HOME_STREET_ADDRESS (VARCHAR2, 722) — concatenated home street address.
• HOME_COUNTRY (VARCHAR2, 60) and HOME_POSTAL_CODE (VARCHAR2, 30) — residence country and postal code.
• HOME_PHONE_NUMBER / HOME_FAX (VARCHAR2, 60) — residential contact numbers.
• OFFICE_LOCATION (VARCHAR2, 45), OFFICE_NUMBER (VARCHAR2, 4000), OFFICE_FAX_NUMBER (VARCHAR2, 60) — work location and contact numbers.
• PAGER_NUMBER, MOBILE_NUMBER (VARCHAR2, 60) — additional contact channels.
• EMAIL_ADDRESS (VARCHAR2, 240) — employee e-mail.
• BUSINESS_GROUP_ID (NUMBER, 15) — the HR business group (organization) to which the employee belongs; use to partition reports across legal entities or operating units.

Common Use Cases and Queries

Typical uses include employee contact directories, mailing-label or emergency-contact reports, and data extracts for downstream systems. The view is also convenient for ad-hoc lookups of a single employee's residence city.

Standard retrieval:

• SELECT PERSON_ID, HOME_CITY, HOME_STREET_ADDRESS, HOME_COUNTRY, HOME_POSTAL_CODE, HOME_PHONE_NUMBER FROM APPS.JTF_RS_EMP_ADDRESS_VL;
• SELECT PERSON_ID, HOME_CITY, EMAIL_ADDRESS FROM APPS.JTF_RS_EMP_ADDRESS_VL WHERE UPPER(HOME_CITY) = UPPER(:p_city);
• SELECT PERSON_ID, HOME_CITY, BUSINESS_GROUP_ID FROM APPS.JTF_RS_EMP_ADDRESS_VL WHERE BUSINESS_GROUP_ID = :p_bg_id ORDER BY HOME_CITY;

Because HR_SECURITY governs row visibility, custom code should never assume an unrestricted result set; run reports under an appropriate HR responsibility or grant the required security profile to the executing user.