What is the primary key of HZ_PERSON_PROFILES?

not marked in the source dictionary

Where is HZ_PERSON_PROFILES used in reporting?

It appears in 41 OTBI subject areas.

Oracle Fusion · Data dictionary

Trading CommunityUsed in 41 subject areas12 reporting columns

Trading Community (Parties) (HZ).

Primary key: not yet catalogued for HZ_PERSON_PROFILES, reference Oracle Tables & Views guide.

Column	In reports	Description (inferred)
DATE_OF_BIRTH	●	Date of birth.
DATE_OF_DEATH	●	Date of death.
DECEASED_FLAG	●	Indicator (Y/N) for the deceased.
DECLARED_ETHNICITY	●	Declared ethnicity.
GENDER	●	Gender.
MARITAL_STATUS	●	Status of the marital.
PERSONAL_INCOME	●	Personal income.
PERSON_FIRST_NAME	●	Name of the person first.
PERSON_LAST_NAME	●	Name of the person last.
PERSON_MIDDLE_NAME	●	Name of the person middle.
PERSON_TITLE	●	Person title.
PLACE_OF_BIRTH	●	Place of birth.

No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.

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.

Need the extract + dbt staging for HZ_PERSON_PROFILES?

We ship parameterized SQL, BICC config, and dbt models you own.

Problems that run through this table