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.
Problems that run through this table