Analytics Catalog/Oracle Fusion ERP/Intercompany/Data model
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion ERP · FUN · Data model

Intercompany data model

Intercompany 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 star4 PVOs

Use case. Intercompany balances and pairing — the FUN distributions behind intercompany reconciliation.

CODE_COMBINATIO…GL_CODE_COMBINATIONSintercompany account▪ PK CODE_COMBINATION…LEDGER_IDGL_LEDGERSledger▪ PK LEDGER_IDPERIOD_NAMEGL_PERIODSperiod▪ PK PERIOD_NAMEBU_IDFUN_ALL_BUSINESS_UNITS_Vbusiness unit▪ PK BU_IDFUN_DIST_LINESfact · one row per intercompany distribu…Entered Amount · Accounted Amount▪ PK DIST_LINE_ID
●— fact → dimension join▪ PK = primary / join key

Fact — FUN_DIST_LINES

Grain: one row per intercompany distribution line. Derived measures: Entered Amount, Accounted Amount. Drill into the fact columns:

ColumnDefinition
AMOUNT_CRAmount cr.
AMOUNT_DRAmount dr.
DESCRIPTIONDescription.
DIST_NUMBERDistribution number.
PARTY_TYPE_FLAGIndicator (Y/N) for the party type.

all 5 columns & keys →

Dimensions / click any to drill into its columns

GL_CODE_COMBINATIONS → · intercompany account
ColumnDefinition
ACCOUNT_TYPEType of account.
CHART_OF_ACCOUNTS_IDIdentifier for the chart of accounts.
CODE_COMBINATION_IDIdentifier for the code combination.
ENABLED_FLAGIndicator (Y/N) for the enabled.
END_DATE_ACTIVEEnd date active.
START_DATE_ACTIVEStart date active.

all 7 columns & keys →

GL_LEDGERS → · ledger
ColumnDefinition
ACCOUNTED_PERIOD_TYPEType of accounted period.
CURRENCY_CODECode identifying the currency.
DESCRIPTIONDescription.
LEDGER_CATEGORY_CODECode identifying the ledger category.
NAMEName.
PERIOD_SET_NAMEName of the period set.

all 10 columns & keys →

GL_PERIODS · period

Column inventory surfaces on the table page.

FUN_ALL_BUSINESS_UNITS_V → · business unit
ColumnDefinition
BUSINESS_GROUP_IDIdentifier for the business group.
BU_IDIdentifier for the business unit.
BU_NAMEName of the business unit.
CREATED_BYUser who created the row.
CREATION_DATEDate and time the row was created.
DATE_FROMDate from.

all 18 columns & keys →

Extracted by 1 BICC PVO / same-module, fact first

These Public View Objects land the data behind this star — BICC extracts them, the model conforms them.

full Financials PVO → table map (Intercompany) →

Reports on this star

Every BICC PVO this module exposes, mapped to the physical tables it extracts from and the star it feeds.

PVOFully-qualified nameMaps to tablesFeeds star
DistributionLinePVOoracle.apps.financials.commonModules.intercompanyTransactions.publicView.analytics.DistributionLinePVOFUN_DIST_LINES, FUN_INTERCO_ORGANIZATIONS, FUN_LOOKUPSIntercompany Distributions fact
TransactionBatchPVOoracle.apps.financials.commonModules.intercompanyTransactions.publicView.analytics.TransactionBatchPVOFUN_INTERCO_ORGANIZATIONS, FUN_LOOKUPS, FUN_TRX_BATCHESreference / config
TransactionHeaderPVOoracle.apps.financials.commonModules.intercompanyTransactions.publicView.analytics.TransactionHeaderPVOFUN_INTERCO_ORGANIZATIONS, FUN_LOOKUPS, FUN_TRX_BATCHESreference / config
TransactionTypeBPVOoracle.apps.financials.commonModules.intercompanyTransactions.publicView.analytics.TransactionTypeBPVOFUN_TRX_TYPES_B, FUN_TRX_TYPES_TLreference / config
Want these models built on your data?
Conformed stars, dbt models, reconciled to source — you own all of it.
Talk to us