Oracle Fusion · Data dictionary
HZ_ORGANIZATION_PROFILES
Trading CommunityUsed in 44 subject areas27 reporting columns
Trading Community (Parties) (HZ).
Primary key: not yet catalogued for HZ_ORGANIZATION_PROFILES, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| BANK_OR_BRANCH_NUMBER | ● | Bank or branch number. | |
| CEO_NAME | ● | Name of the ceo. | |
| CEO_TITLE | ● | Ceo title. | |
| COMMENTS | ● | Comments. | |
| CURR_FY_POTENTIAL_REVENUE | ● | Currency fy potential revenue. | |
| DB_RATING | ● | Db rating. | |
| DISADV_8A_IND | ● | Disadv 8a ind. | |
| FISCAL_YEAREND_MONTH | ● | Fiscal yearend month. | |
| GLOBAL_ULTIMATE_DUNS_NUM_C | ● | Global ultimate duns number c. | |
| GSA_INDICATOR_FLAG | ● | Indicator (Y/N) for the gsa indicator. | |
| HOME_COUNTRY | ● | Home country. | |
| HQ_BRANCH_IND | ● | Hq branch ind. | |
| INTERNAL_FLAG | ● | Indicator (Y/N) for the internal. | |
| LEGAL_STATUS | ● | Status of the legal. | |
| LINE_OF_BUSINESS | ● | Line of business. | |
| MINORITY_OWNED_IND | ● | Minority owned ind. | |
| MINORITY_OWNED_TYPE | ● | Type of minority owned. | |
| MISSION_STATEMENT | ● | Mission statement. | |
| ORGANIZATION_NAME | ● | Name of the organization. | |
| PARENT_DUNS_NUM_C | ● | Parent duns number c. | |
| PARTY_NUMBER | ● | Party number. | |
| PREF_FUNCTIONAL_CURRENCY | ● | Pref functional currency. | |
| PUBLIC_PRIVATE_OWNERSHIP_FLAG | ● | Indicator (Y/N) for the public private ownership. | |
| SMALL_BUS_IND | ● | Small bus ind. | |
| STOCK_SYMBOL | ● | Stock symbol. | |
| WOMAN_OWNED_IND | ● | Woman owned ind. | |
| YEAR_ESTABLISHED | ● | Year established. |
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.
- Costing - COGS and Gross Margin Real Time
- Costing - Cost Accounting Real Time
- Costing - New COGS and Gross Margin Details Real Time
- Distributed Order Orchestration - Fulfillment Lines Real Time
- Distributed Order Orchestration - Order Headers Real Time
- Distributed Order Orchestration - Order Holds Real Time
- Distributed Order Orchestration - Order Lines Real Time
- Distributed Order Orchestration - Price Adjustments Real Time
- Distributed Order Orchestration - Process Instances Real Time
- Fiscal Document Capture Transactions Real Time
- Fiscal Document Holds Real Time
- Fiscal Document Item Deliveries Real Time
- Installed Base - Customer Asset History Real Time
- Installed Base - Customer Asset Real Time
- Interfaced Fiscal Document Real Time
- Product Genealogy - Genealogy Instance Real Time
- Product Genealogy - Genealogy Object Composition Real Time
- Product Genealogy - Genealogy Object Where Used Real Time
- Product Genealogy - Genealogy Transaction Real Time
- Product Management - Manufacturer Real Time
Need the extract + dbt staging for HZ_ORGANIZATION_PROFILES?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table