Oracle Fusion · Data dictionary
HZ_CUST_ACCT_SITES_ALL
Trading CommunityUsed in 2 subject areas8 reporting columns
Trading Community (Parties) (HZ) — transaction table (rows scoped across all operating units).
Primary key: CUST_ACCT_SITE_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCT_SITE_LANGUAGE | ● | Account site language. | |
| CUSTOMER_CATEGORY_CODE | ● | Code identifying the customer category. | |
| CUST_ACCT_SITE_ID | PK | ● | Identifier for the customer account site. |
| END_DATE | ● | End date. | |
| SET_ID | ● | Identifier for the set. | |
| START_DATE | ● | Start date. | |
| STATUS | ● | Status. | |
| TRANSLATED_CUSTOMER_NAME | ● | Name of the translated customer. |
1 report read from this table
Change a column here and these are the reports that move with it — the blast radius for any change to HZ_CUST_ACCT_SITES_ALL.
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.
Need the extract + dbt staging for HZ_CUST_ACCT_SITES_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.