Oracle Fusion ERP · TAX · Data model
Transaction Tax data model
Transaction Tax modeled as 1 conformed star — each a fact at its own grain sharing the same dimensions. Open a star to drill into its fact and dimension columns; the last tab lists every bicc View Object the module exposes.
Free reference1 star2 PVOs
Use case. Tax register and tax reconciliation by jurisdiction and rate.
●— fact → dimension join▪ PK = primary / join key
Fact — ZX_LINES_V
Grain: one row per tax line on a transaction. Derived measures: Taxable Amount, Tax Amount. Drill into the fact columns:
| Column | Definition |
|---|---|
| TAX | Tax. |
| TAX_JURISDICTION_CODE | Code identifying the tax jurisdiction. |
| TAX_JURISDICTION_NAME | Name of the tax jurisdiction. |
| TAX_LINE_NUMBER | Tax line number. |
| TAX_RATE | Tax rate. |
| TAX_RATE_CODE | Code identifying the tax rate. |
| TAX_RATE_NAME | Name of the tax rate. |
| TAX_REGIME_CODE | Code identifying the tax regime. |
Dimensions / click any to drill into its columns
GL_CODE_COMBINATIONS → · tax account
| Column | Definition |
|---|---|
| ACCOUNT_TYPE | Type of account. |
| CHART_OF_ACCOUNTS_ID | Identifier for the chart of accounts. |
| CODE_COMBINATION_ID | Identifier for the code combination. |
| ENABLED_FLAG | Indicator (Y/N) for the enabled. |
| END_DATE_ACTIVE | End date active. |
| START_DATE_ACTIVE | Start date active. |
GL_LEDGERS → · ledger
| Column | Definition |
|---|---|
| ACCOUNTED_PERIOD_TYPE | Type of accounted period. |
| CURRENCY_CODE | Code identifying the currency. |
| DESCRIPTION | Description. |
| LEDGER_CATEGORY_CODE | Code identifying the ledger category. |
| NAME | Name. |
| PERIOD_SET_NAME | Name of the period set. |
ZX_RATES_B · tax rate
Column inventory surfaces on the table page.
ZX_JURISDICTIONS_B · tax jurisdiction
Column inventory surfaces on the table page.
Reports on this star
Every BICC PVO this module exposes, mapped to the physical tables it extracts from and the star it feeds.
| PVO | Fully-qualified name | Maps to tables | Feeds star |
|---|---|---|---|
| TaxReportingUnitPVO | HcmTopModelAnalyticsGlobalAM.OrganizationAM.TaxReportingUnitPVO | FND_SETID_SETS_VL, HR_ALL_ORGANIZATION_UNITS_F, HR_ORGANIZATION_UNITS_F_TL | reference / config |
| POITaxonomyDataPVO | oracle.apps.prc.poi.publicView.analytics.POITaxonomyDataPVO | POI_TAXONOMY_DATA | reference / config |
Want these models built on your data?
Conformed stars, dbt models, reconciled to source — you own all of it.