Analytics Catalog/Oracle Fusion ERP/Cash Management/Data model
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion ERP · CE · Data model

Cash Management data model

Cash Management 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 star9 PVOs

Use case. Bank statement review and reconciliation to system transactions.

STATEMENT_HEADE…CE_STATEMENT_HEADERSstatement▪ PK STATEMENT_HEADER…BANK_ACCOUNT_IDCE_BANK_ACCOUNTSbank account▪ PK BANK_ACCOUNT_IDBANK_BRANCH_IDCE_BANK_BRANCHES_Vbank branch▪ PK BANK_BRANCH_IDCURRENCY_CODEFND_CURRENCIEScurrency▪ PK CURRENCY_CODECE_STATEMENT_LINESfact · one row per bank statement lineLine Amount▪ PK STATEMENT_LINE_ID
●— fact → dimension join▪ PK = primary / join key

Fact — CE_STATEMENT_LINES

Grain: one row per bank statement line. Derived measures: Line Amount. Drill into the fact columns:

ColumnDefinition
ACCNT_SERVICER_REFAccnt servicer reference.
ADDENDA_TXTAddenda txt.
AMOUNTAmount.
BOOKING_DATEBooking date.
CHECK_NUMBERCheck number.
CLEARING_SYSTEM_REFClearing system reference.
COMM_WAIVER_IND_FLAGIndicator (Y/N) for the comm waiver ind.
CONTRACT_IDENTIFICATIONContract identification.

all 23 columns & keys →

Dimensions / click any to drill into its columns

CE_STATEMENT_HEADERS → · statement
ColumnDefinition
ELECTRONIC_SEQ_NUMElectronic seq number.
LEGAL_SEQ_NUMLegal seq number.
RECON_STATUS_CODECode identifying the recon status.
STATEMENT_ENTRY_TYPEType of statement entry.
STATEMENT_NUMBERStatement number.
STMT_FROM_DATEStmt from date.

all 7 columns & keys →

CE_BANK_ACCOUNTS → · bank account
ColumnDefinition
AP_USE_ALLOWED_FLAGIndicator (Y/N) for the payables use allowed.
AR_USE_ALLOWED_FLAGIndicator (Y/N) for the receivables use allowed.
BANK_ACCOUNT_NAMEName of the bank account.
BANK_ACCOUNT_NAME_ALTBank account name alt.
BANK_ACCOUNT_TYPEType of bank account.
CURRENCY_CODECode identifying the currency.

all 9 columns & keys →

CE_BANK_BRANCHES_V → · bank branch
ColumnDefinition
BANK_BRANCH_NAMEName of the bank branch.
BANK_NAMEName of the bank.

all 2 columns & keys →

FND_CURRENCIES · currency

Column inventory surfaces on the table page.

Extracted by 5 BICC PVOs / 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 (Cash Management) →

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
BankAccountPVOoracle.apps.financials.cashManagement.bankRelationships.publicView.analytics.BankAccountPVOCE_BANKS_V, CE_BANK_BRANCHES_V, CE_INTERNAL_BANK_ACCTS_VStatement Lines dim
BankAccountRefPVOoracle.apps.financials.cashManagement.bankRelationships.publicView.analytics.BankAccountRefPVOCE_BANK_ACCOUNTS, CE_BANK_BRANCHES_VStatement Lines dim
BankAccountBalanceAvailabilityPVOoracle.apps.financials.cashManagement.bankStatements.publicView.analytics.BankAccountBalanceAvailabilityPVOCE_STMT_BALANCES, CE_STMT_BAL_AVALBTYreference / config
BankAccountBalancePVOoracle.apps.financials.cashManagement.bankStatements.publicView.analytics.BankAccountBalancePVOCE_STMT_BALANCESreference / config
BankStatementHeaderPVOoracle.apps.financials.cashManagement.bankStatements.publicView.analytics.BankStatementHeaderPVOCE_STATEMENT_HEADERSStatement Lines dim
BankStatementLineAvailabilityPVOoracle.apps.financials.cashManagement.bankStatements.publicView.analytics.BankStatementLineAvailabilityPVOCE_STATEMENT_HEADERS, CE_STATEMENT_LINES, CE_STMT_LINE_AVALBTYStatement Lines fact
BankStatementLineChargesPVOoracle.apps.financials.cashManagement.bankStatements.publicView.analytics.BankStatementLineChargesPVOCE_STMT_LINE_CHARGESreference / config
BankStatementLinesPVOoracle.apps.financials.cashManagement.bankStatements.publicView.analytics.BankStatementLinesPVOCE_STATEMENT_HEADERS, CE_STATEMENT_LINESStatement Lines fact
ExternalTransactionsPVOoracle.apps.financials.cashManagement.cashTransactions.publicView.analytics.ExternalTransactionsPVOCE_EXTERNAL_TRANSACTIONSreference / config
Want these models built on your data?
Conformed stars, dbt models, reconciled to source — you own all of it.
Talk to us