Analytics Catalog/Data dictionary/HZ_ORIG_SYS_REFERENCES
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

HZ_ORIG_SYS_REFERENCES

Trading CommunityUsed in 3 subject areas2 reporting columns

Trading Community (Parties) (HZ).

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

Columns

ColumnKeyIn reportsDescription (inferred)
ORIG_SYSTEM_REFERENCE●Orig system reference.
REQUEST_ID●Identifier of the process that created or last updated the row.

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. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.

Need the extract + dbt staging for HZ_ORIG_SYS_REFERENCES?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us
Problems that run through this table
Aging as of any date · Reporting without memory · The export ceiling