Search Results date_confirmed

Overview

The HRFV_ADA_DIS_ACCOMMODATIONS view is an Oracle E-Business Suite business view template owned by the APPS schema and delivered within the PER (Human Resources) product family. It is generated as part of the flexfield view framework, where descriptive flexfield segments stored against person analysis records are pivoted into named, reportable columns. In this case, the view surfaces data captured against descriptive flexfield ID_FLEX_NUM = 50130, the flexfield used to record Americans with Disabilities Act (ADA) accommodation requests and their handling.

Rather than exposing raw SEGMENT1 through SEGMENTn attributes, the view maps each segment to a business-meaningful alias: DESCRIPTION, DATE_REQUESTED, STATUS, CONFIRMED_BY, DATE_CONFIRMED, DATE_PROVIDED, and COST. This makes it directly consumable by Oracle Reports, BI Publisher, OBIEE/OTBI extracts, and custom SQL, without requiring the developer to know the underlying segment numbering. The view is defined WITH READ ONLY, so it is intended strictly for query and reporting, not for DML.

Underlying Base Objects

The view joins four primary sources documented in the ETRM metadata:

• PER_PERSON_ANALYSES (synonym) — the transactional table holding each accommodation record per person, including the analysis criteria, date range, and flexfield context.
• PER_ANALYSIS_CRITERIA (synonym) — the flexfield definition table providing the segment values (SEGMENT1–SEGMENT7) for ID_FLEX_NUM = 50130.
• PER_PEOPLE_X (view) — supplies the person identity attributes, notably FULL_NAME and EMPLOYEE_NUMBER.
• HR_ALL_ORGANIZATION_UNITS_TL (synonym) — resolves the BUSINESS_GROUP_ID to the translated business group name.

Supporting program units referenced include the packages HR_BIS (used in BIS_DECODE_LOOKUP and GET_SEC_PROFILE_BG_ID), HR_SECURITY (row-level security enforcement), HR_GENERAL, and HR_PERSON_NAME. The HR_BIS.GET_SEC_PROFILE_BG_ID predicate restricts rows to the business group defined by the user's security profile, while BGRT.LANGUAGE = USERENV('LANG') localizes the business group name.

Key Columns

• BUSINESS_GROUP_NAME — translated name of the business group owning the record.
• PERSON_NAME — full name of the person associated with the accommodation.
• DATE_REQUESTED — date the accommodation was requested; derived from PAC.SEGMENT2. This is the column most frequently referenced in user searches.
• DESCRIPTION — nature or description of the requested accommodation (SEGMENT1).
• STATUS — accommodation status, decoded via HR_BIS.BIS_DECODE_LOOKUP('US_ADA_STATUSES', PAC.SEGMENT3).
• CONFIRMED_BY / DATE_CONFIRMED / DATE_PROVIDED — approval and fulfilment tracking fields (SEGMENT4–SEGMENT6).
• COST — associated cost of the accommodation (SEGMENT7).
• START_DATE / END_DATE / COMMENTS — from PER_PERSON_ANALYSES.
• EMPLOYEE_NUMBER, PERSON_ID, PERSON_ANALYSIS_ID, ANALYSIS_CRITERIA_ID, BUSINESS_GROUP_ID, ID_FLEX_NUM — keys for joining and drill-down.

Common Use Cases and Queries

Typical uses include ADA accommodation registers, case ageing by request date, and cost reporting. A representative query filtering on the requested date:

SELECT person_name, employee_number, description,
       date_requested, status, date_confirmed, cost
FROM   apps.hrfv_ada_dis_accommodations
WHERE  date_requested BETWEEN :p_from AND :p_to
ORDER  BY date_requested;

Because row-level security is embedded via HR_SECURITY and GET_SEC_PROFILE_BG_ID, results are automatically scoped to the querying user's business group, making the view suitable for self-service and secured reporting without additional predicates. A common point of confusion is that DATE_REQUESTED is not a native date column but a flexfield segment value; it is stored as character data and must be handled with appropriate date conversion when range filtering or comparing against SYSDATE.