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

Payables data model

Payables modeled as 4 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 reference4 stars19 PVOs

Use case. Invoice register, spend analysis, and the liability behind the AP-to-GL reconciliation.

SUPPLIER_IDPOZ_SUPPLIERSsupplier▪ PK SUPPLIER_IDINVOICE_DISTRIB…AP_INVOICE_DISTRIBUTIONS…distribution / account▪ PK INVOICE_DISTRIBU…LEDGER_IDGL_LEDGERSledger▪ PK LEDGER_IDCODE_COMBINATIO…GL_CODE_COMBINATIONSliability account▪ PK CODE_COMBINATION…BU_IDFUN_ALL_BUSINESS_UNITS_Vbusiness unit▪ PK BU_IDCURRENCY_CODEFND_CURRENCIESinvoice currency▪ PK CURRENCY_CODEAP_INVOICES_ALLfact · one row per supplier invoice head…Invoice Amount · Amount Paid · Unpa…▪ PK INVOICE_ID
●— fact → dimension join▪ PK = primary / join key

Fact — AP_INVOICES_ALL

Grain: one row per supplier invoice header. Derived measures: Invoice Amount, Amount Paid, Unpaid 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

POZ_SUPPLIERS → · supplier
ColumnDefinition
ALLOW_AWT_FLAGIndicator (Y/N) for the allow awt.
ATTRIBUTE1Descriptive flexfield segment.
ATTRIBUTE10Descriptive flexfield segment.
ATTRIBUTE11Descriptive flexfield segment.
ATTRIBUTE12Descriptive flexfield segment.
ATTRIBUTE13Descriptive flexfield segment.

all 145 columns & keys →

AP_INVOICE_DISTRIBUTIONS_ALL → · distribution / account
ColumnDefinition
ACCOUNTING_DATEAccounting date.
ADJUSTMENT_REASONAdjustment reason.
AMOUNTAmount.
AMOUNT_AT_PREPAY_PAY_XRATEAmount at prepay pay xrate.
AMOUNT_AT_PREPAY_XRATEAmount at prepay xrate.
AMOUNT_VARIANCEAmount variance.

all 59 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_CODE_COMBINATIONS → · liability 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 →

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 →

FND_CURRENCIES · invoice currency

Column inventory surfaces on the table page.

Extracted by 9 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 (Payables) →

Reports on this star

Use case. Invoice aging and cash forecasting — open installments bucketed by age.

INVOICE_IDAP_INVOICES_ALLinvoice▪ PK INVOICE_IDSUPPLIER_IDPOZ_SUPPLIERSsupplier▪ PK SUPPLIER_IDLEDGER_IDGL_LEDGERSledger▪ PK LEDGER_IDBU_IDFUN_ALL_BUSINESS_UNITS_Vbusiness unit▪ PK BU_IDCURRENCY_CODEFND_CURRENCIEScurrency▪ PK CURRENCY_CODEAP_PAYMENT_SCHEDULES_ALLfact · one row per invoice installment (…Gross Amount · Amount Remaining▪ PK INVOICE_ID
●— fact → dimension join▪ PK = primary / join key

Fact — AP_PAYMENT_SCHEDULES_ALL

Grain: one row per invoice installment (due date). Derived measures: Gross Amount, Amount Remaining. Drill into the fact columns:

ColumnDefinition
AMOUNT_REMAININGAmount remaining.
DISCOUNT_AMOUNT_AVAILABLEDiscount amount available.
DISCOUNT_DATEDiscount date.
DUE_DATEDue date.
GROSS_AMOUNTGross amount.
HOLD_DATEHold date.
HOLD_FLAGIndicator (Y/N) for the hold.
IBY_HOLD_REASONIby hold reason.

all 21 columns & keys →

Dimensions / click any to drill into its columns

AP_INVOICES_ALL → · invoice
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.

all 63 columns & keys →

POZ_SUPPLIERS → · supplier
ColumnDefinition
ALLOW_AWT_FLAGIndicator (Y/N) for the allow awt.
ATTRIBUTE1Descriptive flexfield segment.
ATTRIBUTE10Descriptive flexfield segment.
ATTRIBUTE11Descriptive flexfield segment.
ATTRIBUTE12Descriptive flexfield segment.
ATTRIBUTE13Descriptive flexfield segment.

all 145 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 →

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 →

FND_CURRENCIES · currency

Column inventory surfaces on the table page.

Extracted by 9 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 (Payables) →

Reports on this star

Use case. Payment register and disbursement audit.

CHECK_IDAP_CHECKS_ALLpayment / check▪ PK CHECK_IDSUPPLIER_IDPOZ_SUPPLIERSsupplier▪ PK SUPPLIER_IDLEDGER_IDGL_LEDGERSledger▪ PK LEDGER_IDBANK_ACCOUNT_IDCE_BANK_ACCOUNTSdisbursement bank account▪ PK BANK_ACCOUNT_IDCURRENCY_CODEFND_CURRENCIESpayment currency▪ PK CURRENCY_CODEAP_INVOICE_PAYMENTS_ALLfact · one row per payment applied to an…Payment Amount · Discount Taken▪ PK INVOICE_PAYMENT_ID
●— fact → dimension join▪ PK = primary / join key

Fact — AP_INVOICE_PAYMENTS_ALL

Grain: one row per payment applied to an invoice. Derived measures: Payment Amount, Discount Taken. Drill into the fact columns:

ColumnDefinition
ACCOUNTING_DATEAccounting date.
AMOUNTAmount.
AMOUNT_INV_CURRAmount inventory currency.
BANK_ACCOUNT_NUMBank account number.
BANK_ACCOUNT_TYPEType of bank account.
BANK_NUMBank number.
DISCOUNT_LOSTDiscount lost.
DISCOUNT_TAKENDiscount taken.

all 22 columns & keys →

Dimensions / click any to drill into its columns

AP_CHECKS_ALL → · payment / check
ColumnDefinition
ADDRESS_LINE1Address line1.
ADDRESS_LINE2Address line2.
ADDRESS_LINE3Address line3.
ADDRESS_LINE4Address line4.
AMOUNTAmount.
BANK_ACCOUNT_TYPEType of bank account.

all 44 columns & keys →

POZ_SUPPLIERS → · supplier
ColumnDefinition
ALLOW_AWT_FLAGIndicator (Y/N) for the allow awt.
ATTRIBUTE1Descriptive flexfield segment.
ATTRIBUTE10Descriptive flexfield segment.
ATTRIBUTE11Descriptive flexfield segment.
ATTRIBUTE12Descriptive flexfield segment.
ATTRIBUTE13Descriptive flexfield segment.

all 145 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 →

CE_BANK_ACCOUNTS → · disbursement 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 →

FND_CURRENCIES · payment currency

Column inventory surfaces on the table page.

Extracted by 4 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 (Payables) →

Reports on this star

Use case. Holds analysis — what is blocking payment and why.

INVOICE_IDAP_INVOICES_ALLinvoice▪ PK INVOICE_IDSUPPLIER_IDPOZ_SUPPLIERSsupplier▪ PK SUPPLIER_IDBU_IDFUN_ALL_BUSINESS_UNITS_Vbusiness unit▪ PK BU_IDLEDGER_IDGL_LEDGERSledger▪ PK LEDGER_IDAP_HOLDS_ALLfact · one row per hold placed on an inv…Held Amount▪ PK HOLD_ID
●— fact → dimension join▪ PK = primary / join key

Fact — AP_HOLDS_ALL

Grain: one row per hold placed on an invoice. Derived measures: Held Amount. Drill into the fact columns:

ColumnDefinition
HOLD_DATEHold date.
HOLD_DETAILSHold details.
HOLD_IDIdentifier for the hold.
HOLD_LOOKUP_CODELookup code for the hold.
HOLD_REASONHold reason.
LAST_UPDATE_DATEDate and time the row was last updated (the incremental-extract key).
LINE_NUMBERLine number.
RELEASE_LOOKUP_CODELookup code for the release.

all 11 columns & keys →

Dimensions / click any to drill into its columns

AP_INVOICES_ALL → · invoice
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.

all 63 columns & keys →

POZ_SUPPLIERS → · supplier
ColumnDefinition
ALLOW_AWT_FLAGIndicator (Y/N) for the allow awt.
ATTRIBUTE1Descriptive flexfield segment.
ATTRIBUTE10Descriptive flexfield segment.
ATTRIBUTE11Descriptive flexfield segment.
ATTRIBUTE12Descriptive flexfield segment.
ATTRIBUTE13Descriptive flexfield segment.

all 145 columns & keys →

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 →

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 →

Extracted by 10 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 (Payables) →

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
InvoiceDistributionAppliedPVOoracle.apps.financials.payables.invoices.transactions.publicView.analytics.InvoiceDistributionAppliedPVOAP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICE_LINES_ALLInvoices fact, Installments dim
InvoiceDistributionPVOoracle.apps.financials.payables.invoices.transactions.publicView.analytics.InvoiceDistributionPVOAP_BATCHES_ALL, AP_CHECKS_ALL, AP_INCOME_TAX_REGIONSInvoices fact, Installments dim
InvoiceHeaderPVOoracle.apps.financials.payables.invoices.transactions.publicView.analytics.InvoiceHeaderPVOAP_BATCHES_ALL, AP_INVOICES_ALL, AP_INV_APRVL_HIST_ALLInvoices fact, Installments dim
InvoiceHoldPVOoracle.apps.financials.payables.invoices.transactions.publicView.analytics.InvoiceHoldPVOAP_HOLDS_ALL, RCV_SHIPMENT_HEADERSHolds fact
InvoiceLineAppliedPVOoracle.apps.financials.payables.invoices.transactions.publicView.analytics.InvoiceLineAppliedPVOAP_INVOICES_ALL, AP_INVOICE_LINES_ALL, FA_BOOK_CONTROLSInvoices fact, Installments dim
InvoiceLinePVOoracle.apps.financials.payables.invoices.transactions.publicView.analytics.InvoiceLinePVOAP_BATCHES_ALL, AP_INVOICES_ALL, AP_INVOICE_LINES_ALLInvoices fact, Installments dim
InvoicePaymentSchedulePVOoracle.apps.financials.payables.invoices.transactions.publicView.analytics.InvoicePaymentSchedulePVOAP_INVOICES_ALL, AP_PAYMENT_SCHEDULES_ALL, IBY_EXT_BANK_ACCOUNTSInvoices fact, Installments fact
PrepaymentAppliationDistributionPVOoracle.apps.financials.payables.invoices.transactions.publicView.analytics.PrepaymentAppliationDistributionPVOAP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICE_LINES_ALLInvoices fact, Installments dim
PaymentTermHeaderBPVOoracle.apps.financials.payables.invoicesSetup.paymentTerms.publicView.analytics.PaymentTermHeaderBPVOAP_TERMS_Breference / config
PaymentTermHeaderTranslationPVOoracle.apps.financials.payables.invoicesSetup.paymentTerms.publicView.analytics.PaymentTermHeaderTranslationPVOAP_TERMS_TLreference / config
DisbursementHeaderPVOoracle.apps.financials.payables.payments.singlePayments.publicView.analytics.DisbursementHeaderPVOAP_CHECKS_ALL, CE_PAYMENT_DOCUMENTS, FND_DOCUMENT_SEQUENCESPayments dim
DisbursementHistoryHeaderPVOoracle.apps.financials.payables.payments.singlePayments.publicView.analytics.DisbursementHistoryHeaderPVOAP_PAYMENT_HISTORY_ALLreference / config
PaidDisbursementSchedulePVOoracle.apps.financials.payables.payments.singlePayments.publicView.analytics.PaidDisbursementSchedulePVOAP_BATCHES_ALL, AP_CHECKS_ALL, AP_INVOICES_ALLInvoices fact, Installments fact
PaymentHistoryDistributionPVOoracle.apps.financials.payables.payments.singlePayments.publicView.analytics.PaymentHistoryDistributionPVOAP_BATCHES_ALL, AP_CHECKS_ALL, AP_INVOICES_ALLInvoices fact, Installments fact
ReconciliationParameterPVOoracle.apps.financials.payables.reports.reconciliationReports.publicView.analytics.ReconciliationParameterPVOAP_RECON_SUMMARY_PARAMETERS, PER_PERSON_NAMES_F_Vreference / config
ReconciliationSummaryPVOoracle.apps.financials.payables.reports.reconciliationReports.publicView.analytics.ReconciliationSummaryPVOAP_RECON_SUMMARY_DETAILSreference / config
PayablesLookupPVOoracle.apps.financials.payables.shared.publicView.analytics.PayablesLookupPVOAP_LOOKUP_CODESreference / config
TrialBalancePVOoracle.apps.financials.payables.shared.publicView.analytics.TrialBalancePVOAP_TRIAL_BALANCES, HZ_PARTIES, HZ_PARTY_SITESreference / config
WithholdingBucketPVOoracle.apps.financials.payables.sharedSetup.withholdingTaxes.publicView.analytics.WithholdingBucketPVOZX_BUCKETS_F, ZX_TAXES_VLreference / config
Want these models built on your data?
Conformed stars, dbt models, reconciled to source — you own all of it.
Talk to us