Oracle Fusion · Data dictionary
HZ_ORG_CONTACTS
Trading CommunityUsed in 7 subject areas4 reporting columns
Trading Community (Parties) (HZ).
Primary key: not yet catalogued for HZ_ORG_CONTACTS — reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CONTACT_NUMBER | ● | Contact number. | |
| DEPARTMENT_CODE | ● | Code identifying the department. | |
| JOB_TITLE | ● | Job title. | |
| JOB_TITLE_CODE | ● | Code identifying the job title. |
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.
- Procurement - Implemented Change Orders Real Time
- Procurement - Pending Change Orders Real Time
- Procurement - Purchasing Agreements Real Time
- Procurement - Purchasing Real Time
- Receivables - Customer Real Time
- Supplier - Supplier Real Time
- Supplier Import - Supplier Real Time
Need the extract + dbt staging for HZ_ORG_CONTACTS?
We ship parameterized SQL, BICC config, and dbt models you own.