Oracle Fusion · Data dictionary
HR_LOCATIONS_ALL_F_VL
HCMUsed in 9 subject areas11 reporting columns
HR / Workforce (HR), view layer, joins the base table with translations for the current language.
Primary key: not yet catalogued for HR_LOCATIONS_ALL_F_VL, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ADDRESS_LINE_1 | ● | Address line 1. | |
| ADDRESS_LINE_2 | ● | Address line 2. | |
| ADDRESS_LINE_3 | ● | Address line 3. | |
| ADDRESS_LINE_4 | ● | Address line 4. | |
| COUNTRY | ● | Country. | |
| EMAIL_ADDRESS | ● | Email address. | |
| LOCATION_NAME | ● | Name of the location. | |
| POSTAL_CODE | ● | Code identifying the postal. | |
| TELEPHONE_NUMBER_1 | ● | Telephone number 1. | |
| TELEPHONE_NUMBER_2 | ● | Telephone number 2. | |
| TOWN_OR_CITY | ● | Town or city. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.
- Installed Base - Customer Asset History Real Time
- Maintenance Management - Asset History Real Time
- Project Billing - Invoices Real Time
- Project Billing - Revenue Real Time
- Project Control - Budgets Real Time
- Project Costing - Actual Costs Real Time
- Project Costing - Commitments Real Time
- Project Costing - Unprocessed Transactions Real Time
- Projects - Grants Management - Award Funding Real Time
Need the extract + dbt staging for HR_LOCATIONS_ALL_F_VL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table