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

Expenses data model

Expenses modeled as 2 conformed stars — 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 reference2 stars0 PVOs

Use case. Ap Invoices analysis — the grain behind 2 report(s) in this module.

PER_ALL_PEOPLE_Fconformed dimensionPER_PERSON_NAMES_F_Vconformed dimensionORGANIZATION_IDHR_ALL_ORGANIZATION_UNIT…conformed dimension▪ PK ORGANIZATION_IDHR_ORGANIZATION_UNITS_F_…conformed dimensionPER_LOCATION_DETAILS_F_VLconformed dimensionAP_INVOICES_ALLfact · one row per ap invoices recordAmount▪ PK INVOICE_ID
●— fact → dimension join▪ PK = primary / join key

Fact — AP_INVOICES_ALL

Grain: one row per ap invoices record. Derived measures: Amount. Drill into the fact columns:

ColumnDefinition
AMOUNT_APPLICABLE_TO_DISCOUNTAmount applicable to discount.
AMOUNT_PAIDAmount paid.
APPROVAL_DESCRIPTIONDescription of the approval.
APPROVAL_ITERATIONApproval iteration.
APPROVAL_STATUSStatus of the approval.
BANK_CHARGE_BEARERBank charge bearer.
BASE_AMOUNTBase amount.
BUDGET_DATEBudget date.

all 63 columns & keys →

Dimensions / click any to drill into its columns

PER_ALL_PEOPLE_F → · conformed dimension
ColumnDefinition
APPLICANT_NUMBERApplicant number.
ATTRIBUTE1Descriptive flexfield segment.
ATTRIBUTE10Descriptive flexfield segment.
ATTRIBUTE11Descriptive flexfield segment.
ATTRIBUTE12Descriptive flexfield segment.
ATTRIBUTE13Descriptive flexfield segment.

all 105 columns & keys →

PER_PERSON_NAMES_F_V → · conformed dimension
ColumnDefinition
ATTRIBUTE1Descriptive flexfield segment.
ATTRIBUTE10Descriptive flexfield segment.
ATTRIBUTE11Descriptive flexfield segment.
ATTRIBUTE12Descriptive flexfield segment.
ATTRIBUTE13Descriptive flexfield segment.
ATTRIBUTE14Descriptive flexfield segment.

all 124 columns & keys →

HR_ALL_ORGANIZATION_UNITS_F → · conformed dimension
ColumnDefinition
ACTION_OCCURRENCE_IDIdentifier for the action occurrence.
BUSINESS_GROUP_IDIdentifier for the business group.
COST_ALLOCATION_KEYFLEX_IDIdentifier for the cost allocation keyflex.
CREATED_BYUser who created the row.
CREATION_DATEDate and time the row was created.
EFFECTIVE_END_DATEEnd date of the effective-dated record.

all 18 columns & keys →

HR_ORGANIZATION_UNITS_F_TL → · conformed dimension
ColumnDefinition
CREATED_BYUser who created the row.
CREATION_DATEDate and time the row was created.
EFFECTIVE_END_DATEEnd date of the effective-dated record.
EFFECTIVE_START_DATEStart date of the effective-dated record.
LANGUAGELanguage.
LAST_UPDATED_BYUser who last updated the row.

all 13 columns & keys →

PER_LOCATION_DETAILS_F_VL → · conformed dimension
ColumnDefinition
ACTIVE_STATUSStatus of the active.
AC_LOCATION_CODECode identifying the ac location.
ANNUAL_WORKING_DURATION_UNITSAnnual working duration units.
BILL_TO_SITE_FLAGIndicator (Y/N) for the bill to site.
CREATED_BYUser who created the row.
CREATION_DATEDate and time the row was created.

all 47 columns & keys →

Reports on this star

Use case. Exm Credit Card Trxns analysis — the grain behind 1 report(s) in this module.

PER_ALL_ASSIGNMENTS_Mconformed dimensionCODE_COMBINATIO…GL_CODE_COMBINATIONSconformed dimension▪ PK CODE_COMBINATION…PER_ALL_PEOPLE_Fconformed dimensionPER_PERSON_NAMES_F_Vconformed dimensionHR_ORGANIZATION_UNITS_F_…conformed dimensionEXM_CREDIT_CARD_TRXNSfact · one row per exm credit card trxns…Charge Amount
●— fact → dimension join▪ PK = primary / join key

Fact — EXM_CREDIT_CARD_TRXNS

Grain: one row per exm credit card trxns record. Derived measures: Charge Amount. Drill into the fact columns:

ColumnDefinition
REFERENCE_NUMBERReference number.

all 1 columns & keys →

Dimensions / click any to drill into its columns

PER_ALL_ASSIGNMENTS_M → · conformed dimension
ColumnDefinition
ACTION_CODECode identifying the action.
ACTION_OCCURRENCE_IDIdentifier for the action occurrence.
ADJUSTED_FTEAdjusted fte.
ALLOW_ASG_OVERRIDE_FLAGIndicator (Y/N) for the allow asg override.
ANNUAL_WORKING_DURATIONAnnual working duration.
ANNUAL_WORKING_DURATION_UNITSAnnual working duration units.

all 129 columns & keys →

GL_CODE_COMBINATIONS → · conformed dimension
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 →

PER_ALL_PEOPLE_F → · conformed dimension
ColumnDefinition
APPLICANT_NUMBERApplicant number.
ATTRIBUTE1Descriptive flexfield segment.
ATTRIBUTE10Descriptive flexfield segment.
ATTRIBUTE11Descriptive flexfield segment.
ATTRIBUTE12Descriptive flexfield segment.
ATTRIBUTE13Descriptive flexfield segment.

all 105 columns & keys →

PER_PERSON_NAMES_F_V → · conformed dimension
ColumnDefinition
ATTRIBUTE1Descriptive flexfield segment.
ATTRIBUTE10Descriptive flexfield segment.
ATTRIBUTE11Descriptive flexfield segment.
ATTRIBUTE12Descriptive flexfield segment.
ATTRIBUTE13Descriptive flexfield segment.
ATTRIBUTE14Descriptive flexfield segment.

all 124 columns & keys →

HR_ORGANIZATION_UNITS_F_TL → · conformed dimension
ColumnDefinition
CREATED_BYUser who created the row.
CREATION_DATEDate and time the row was created.
EFFECTIVE_END_DATEEnd date of the effective-dated record.
EFFECTIVE_START_DATEStart date of the effective-dated record.
LANGUAGELanguage.
LAST_UPDATED_BYUser who last updated the row.

all 13 columns & keys →

Reports on this star

View Objects for this module surface through the BICC domain inventory.

Want these models built on your data?
Conformed stars, dbt models, reconciled to source — you own all of it.
Talk to us