Oracle Fusion · Data dictionary
ZX_REPORT_CODES_ASSOC
TaxUsed in 2 subject areas3 reporting columns
Transaction Tax (ZX).
Primary key: REPORTING_CODE_ASSOC_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| EFFECTIVE_FROM | ● | Effective from. | |
| EFFECTIVE_TO | ● | Effective to. | |
| REPORTING_CODE_ASSOC_ID | PK | ○ | Identifier for the reporting code assoc. |
| REPORTING_CODE_CHAR_VALUE | ● | Reporting code char value. |
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.
- Receivables - Customer Account Site Tax Profile Real Time
- Receivables - Customer Tax Profile Real Time
Need the extract + dbt staging for ZX_REPORT_CODES_ASSOC?
We ship parameterized SQL, BICC config, and dbt models you own.