Oracle Fusion ERP · AR · Data model
Receivables data model
Receivables 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 stars60 PVOs
Use case. Billing analysis and the receivable behind the AR-to-GL reconciliation.
●— fact → dimension join▪ PK = primary / join key
Fact — RA_CUSTOMER_TRX_ALL
Grain: one row per AR transaction (invoice, credit memo). Derived measures: Transaction Amount, Tax Amount. Drill into the fact columns:
| Column | Definition |
|---|---|
| BILLING_DATE | Billing date. |
| BR_AMOUNT | Br amount. |
| BR_ON_HOLD_FLAG | Indicator (Y/N) for the br on hold. |
| COMMENTS | Comments. |
| COMPLETE_FLAG | Indicator (Y/N) for the complete. |
| CREATION_DATE | Date and time the row was created. |
| CREDIT_METHOD_FOR_INSTALLMENTS | Credit method for installments. |
| CREDIT_METHOD_FOR_RULES | Credit method for rules. |
Dimensions / click any to drill into its columns
RA_CUSTOMER_TRX_LINES_ALL → · transaction line
| Column | Definition |
|---|---|
| ACCOUNTING_RULE_DURATION | Accounting rule duration. |
| AMOUNT_INCLUDES_TAX_FLAG | Indicator (Y/N) for the amount includes tax. |
| ASSESSABLE_VALUE | Assessable value. |
| AUTOTAX | Autotax. |
| DEFERRAL_EXCLUSION_FLAG | Indicator (Y/N) for the deferral exclusion. |
| DESCRIPTION | Description. |
HZ_CUST_ACCOUNTS → · customer account
| Column | Definition |
|---|---|
| ACCOUNT_ESTABLISHED_DATE | Account established date. |
| ACCOUNT_NAME | Name of the account. |
| ACCOUNT_NUMBER | Account number. |
| ACCOUNT_TERMINATION_DATE | Account termination date. |
| AUTOPAY_FLAG | Indicator (Y/N) for the autopay. |
| COTERMINATE_DAY_MONTH | Coterminate day month. |
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. |
GL_CODE_COMBINATIONS → · receivables 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. |
FUN_ALL_BUSINESS_UNITS_V → · business unit
| Column | Definition |
|---|---|
| BUSINESS_GROUP_ID | Identifier for the business group. |
| BU_ID | Identifier for the business unit. |
| BU_NAME | Name of the business unit. |
| CREATED_BY | User who created the row. |
| CREATION_DATE | Date and time the row was created. |
| DATE_FROM | Date from. |
FND_CURRENCIES · transaction currency
Column inventory surfaces on the table page.
Extracted by 16 BICC PVOs / same-module, fact first
These Public View Objects land the data behind this star — BICC extracts them, the model conforms them.
- AdjustmentDistributionPVO → feeds the fact
- AdjustmentPVO → feeds the fact
- CreditMemoApplicationDistributionPVO → feeds the fact
- CreditMemoApplicationPVO → feeds the fact
- HeaderSalesCreditPVO → feeds the fact
- LineSalesCreditPVO → feeds the fact
- ReceiptApplicationDistributionPVO → feeds the fact
- ReceiptApplicationPVO → feeds the fact
- ReceiptHistoryDistributionPVO → feeds the fact
- TransactionHeaderPVO → feeds the fact
- ReceiptHeaderPVO → feeds a dimension
- ReferenceAccountPVO → feeds a dimension
full Financials PVO → table map (Receivables) →
Reports on this star
Use case. Receivables aging and DSO — open balances bucketed by age.
●— fact → dimension join▪ PK = primary / join key
Fact — AR_PAYMENT_SCHEDULES_ALL
Grain: one row per transaction installment. Derived measures: Amount Due Original, Amount Due Remaining. Drill into the fact columns:
| Column | Definition |
|---|---|
| ACCTD_AMOUNT_DUE_REMAINING | Acctd amount due remaining. |
| ACTUAL_DATE_CLOSED | Actual date closed. |
| AMOUNT_ADJUSTED | Amount adjusted. |
| AMOUNT_ADJUSTED_PENDING | Amount adjusted pending. |
| AMOUNT_APPLIED | Amount applied. |
| AMOUNT_CREDITED | Amount credited. |
| AMOUNT_DUE_ORIGINAL | Amount due original. |
| AMOUNT_DUE_REMAINING | Amount due remaining. |
Dimensions / click any to drill into its columns
RA_CUSTOMER_TRX_ALL → · transaction
| Column | Definition |
|---|---|
| BILLING_DATE | Billing date. |
| BR_AMOUNT | Br amount. |
| BR_ON_HOLD_FLAG | Indicator (Y/N) for the br on hold. |
| COMMENTS | Comments. |
| COMPLETE_FLAG | Indicator (Y/N) for the complete. |
| CREATION_DATE | Date and time the row was created. |
HZ_CUST_ACCOUNTS → · customer
| Column | Definition |
|---|---|
| ACCOUNT_ESTABLISHED_DATE | Account established date. |
| ACCOUNT_NAME | Name of the account. |
| ACCOUNT_NUMBER | Account number. |
| ACCOUNT_TERMINATION_DATE | Account termination date. |
| AUTOPAY_FLAG | Indicator (Y/N) for the autopay. |
| COTERMINATE_DAY_MONTH | Coterminate day month. |
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. |
FUN_ALL_BUSINESS_UNITS_V → · business unit
| Column | Definition |
|---|---|
| BUSINESS_GROUP_ID | Identifier for the business group. |
| BU_ID | Identifier for the business unit. |
| BU_NAME | Name of the business unit. |
| CREATED_BY | User who created the row. |
| CREATION_DATE | Date and time the row was created. |
| DATE_FROM | Date from. |
FND_CURRENCIES · currency
Column inventory surfaces on the table page.
Extracted by 18 BICC PVOs / same-module, fact first
These Public View Objects land the data behind this star — BICC extracts them, the model conforms them.
- AdjustmentDistributionPVO → feeds the fact
- AdjustmentPVO → feeds the fact
- CreditMemoApplicationDistributionPVO → feeds the fact
- CreditMemoApplicationPVO → feeds the fact
- PaymentSchedulePVO → feeds the fact
- ReceiptApplicationDistributionPVO → feeds the fact
- ReceiptApplicationPVO → feeds the fact
- ReceiptHeaderPVO → feeds the fact
- ReceiptHistoryDistributionPVO → feeds the fact
- ReceiptHistoryPVO → feeds the fact
- HeaderSalesCreditPVO → feeds a dimension
- LineSalesCreditPVO → feeds a dimension
- ReferenceAccountPVO → feeds a dimension
- TransactionHistoryDistributionPVO → feeds a dimension
- TransactionHistoryPVO → feeds a dimension
- TransactionLineDistributionPVO → feeds a dimension
full Financials PVO → table map (Receivables) →
Reports on this star
Use case. Cash application and collections analysis.
●— fact → dimension join▪ PK = primary / join key
Fact — AR_CASH_RECEIPTS_ALL
Grain: one row per customer receipt. Derived measures: Receipt Amount, Applied Amount. Drill into the fact columns:
| Column | Definition |
|---|---|
| ACTUAL_VALUE_DATE | Actual value date. |
| AMOUNT | Amount. |
| ANTICIPATED_CLEARING_DATE | Anticipated clearing date. |
| COMMENTS | Comments. |
| CONFIRMED_FLAG | Indicator (Y/N) for the confirmed. |
| CREATION_DATE | Date and time the row was created. |
| CUSTOMER_RECEIPT_REFERENCE | Customer receipt reference. |
| DEPOSIT_DATE | Deposit date. |
Dimensions / click any to drill into its columns
AR_RECEIVABLE_APPLICATIONS_ALL → · application
| Column | Definition |
|---|---|
| ACCTD_AMOUNT_APPLIED_FROM | Acctd amount applied from. |
| ACCTD_AMOUNT_APPLIED_TO | Acctd amount applied to. |
| ACCTD_EARNED_DISCOUNT_TAKEN | Acctd earned discount taken. |
| ACCTD_UNEARNED_DISCOUNT_TAKEN | Acctd unearned discount taken. |
| AMOUNT_APPLIED | Amount applied. |
| AMOUNT_APPLIED_FROM | Amount applied from. |
HZ_CUST_ACCOUNTS → · customer
| Column | Definition |
|---|---|
| ACCOUNT_ESTABLISHED_DATE | Account established date. |
| ACCOUNT_NAME | Name of the account. |
| ACCOUNT_NUMBER | Account number. |
| ACCOUNT_TERMINATION_DATE | Account termination date. |
| AUTOPAY_FLAG | Indicator (Y/N) for the autopay. |
| COTERMINATE_DAY_MONTH | Coterminate day month. |
CE_BANK_ACCOUNTS → · bank account
| Column | Definition |
|---|---|
| AP_USE_ALLOWED_FLAG | Indicator (Y/N) for the payables use allowed. |
| AR_USE_ALLOWED_FLAG | Indicator (Y/N) for the receivables use allowed. |
| BANK_ACCOUNT_NAME | Name of the bank account. |
| BANK_ACCOUNT_NAME_ALT | Bank account name alt. |
| BANK_ACCOUNT_TYPE | Type of bank account. |
| CURRENCY_CODE | Code identifying the currency. |
AR_RECEIPT_METHODS → · receipt method
| Column | Definition |
|---|---|
| NAME | Name. |
FND_CURRENCIES · receipt currency
Column inventory surfaces on the table page.
Extracted by 18 BICC PVOs / same-module, fact first
These Public View Objects land the data behind this star — BICC extracts them, the model conforms them.
- AdjustmentDistributionPVO → feeds the fact
- AdjustmentPVO → feeds the fact
- HeaderSalesCreditPVO → feeds the fact
- LineSalesCreditPVO → feeds the fact
- MiscReceiptDistributionPVO → feeds the fact
- PaymentSchedulePVO → feeds the fact
- ReceiptApplicationDistributionPVO → feeds the fact
- ReceiptApplicationPVO → feeds the fact
- ReceiptHeaderPVO → feeds the fact
- ReceiptHistoryDistributionPVO → feeds the fact
- CreditMemoApplicationDistributionPVO → feeds a dimension
- CreditMemoApplicationPVO → feeds a dimension
- CustomerReceiptMethodPVO → feeds a dimension
- ReceiptMethodPVO → feeds a dimension
full Financials PVO → table map (Receivables) →
Reports on this star
Use case. Write-offs and adjustments review.
●— fact → dimension join▪ PK = primary / join key
Fact — AR_ADJUSTMENTS_ALL
Grain: one row per AR adjustment. Derived measures: Adjustment Amount. Drill into the fact columns:
| Column | Definition |
|---|---|
| ACCTD_AMOUNT | Acctd amount. |
| ADJUSTMENT_NUMBER | Adjustment number. |
| ADJUSTMENT_TYPE | Type of adjustment. |
| AMOUNT | Amount. |
| APPLY_DATE | Apply date. |
| COMMENTS | Comments. |
| CREATION_DATE | Date and time the row was created. |
| DOC_SEQUENCE_VALUE | Doc sequence value. |
Dimensions / click any to drill into its columns
RA_CUSTOMER_TRX_ALL → · transaction
| Column | Definition |
|---|---|
| BILLING_DATE | Billing date. |
| BR_AMOUNT | Br amount. |
| BR_ON_HOLD_FLAG | Indicator (Y/N) for the br on hold. |
| COMMENTS | Comments. |
| COMPLETE_FLAG | Indicator (Y/N) for the complete. |
| CREATION_DATE | Date and time the row was created. |
HZ_CUST_ACCOUNTS → · customer
| Column | Definition |
|---|---|
| ACCOUNT_ESTABLISHED_DATE | Account established date. |
| ACCOUNT_NAME | Name of the account. |
| ACCOUNT_NUMBER | Account number. |
| ACCOUNT_TERMINATION_DATE | Account termination date. |
| AUTOPAY_FLAG | Indicator (Y/N) for the autopay. |
| COTERMINATE_DAY_MONTH | Coterminate day month. |
GL_CODE_COMBINATIONS → · adjustment 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. |
Extracted by 16 BICC PVOs / same-module, fact first
These Public View Objects land the data behind this star — BICC extracts them, the model conforms them.
- AdjustmentDistributionPVO → feeds the fact
- AdjustmentPVO → feeds the fact
- CreditMemoApplicationDistributionPVO → feeds a dimension
- CreditMemoApplicationPVO → feeds a dimension
- HeaderSalesCreditPVO → feeds a dimension
- LineSalesCreditPVO → feeds a dimension
- ReceiptApplicationDistributionPVO → feeds a dimension
- ReceiptApplicationPVO → feeds a dimension
full Financials PVO → table map (Receivables) →
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 |
|---|---|---|---|
| AccountBankAccountPVO | oracle.apps.financials.receivables.customers.publicView.analytics.AccountBankAccountPVO | HZ_CONTACT_POINTS, HZ_ORGANIZATION_PROFILES, IBY_EXTERNAL_PAYERS_ALL | reference / config |
| AccountContactPVO | oracle.apps.financials.receivables.customers.publicView.analytics.AccountContactPVO | HZ_CUST_ACCOUNT_ROLES, HZ_PARTIES | reference / config |
| AccountContactPointPVO | oracle.apps.financials.receivables.customers.publicView.analytics.AccountContactPointPVO | HZ_CONTACT_POINTS, HZ_RELATIONSHIP_TYPES | reference / config |
| AccountContactRelationShipPVO | oracle.apps.financials.receivables.customers.publicView.analytics.AccountContactRelationShipPVO | HZ_CUST_ACCOUNT_ROLES, HZ_ORG_CONTACTS, HZ_PARTIES | reference / config |
| AccountCreditCardPVO | oracle.apps.financials.receivables.customers.publicView.analytics.AccountCreditCardPVO | HZ_LOCATIONS, IBY_CREDITCARD, IBY_PMT_INSTR_USES_ALL | reference / config |
| AccountPaymentNotificationPVO | oracle.apps.financials.receivables.customers.publicView.analytics.AccountPaymentNotificationPVO | IBY_EXTERNAL_PAYERS_ALL | reference / config |
| PaymentCodesPVO | oracle.apps.financials.receivables.customers.publicView.analytics.PaymentCodesPVO | IBY_PAYMENT_CODES_VL | reference / config |
| SiteBankAccountPVO | oracle.apps.financials.receivables.customers.publicView.analytics.SiteBankAccountPVO | HZ_CONTACT_POINTS, HZ_ORGANIZATION_PROFILES, IBY_EXTERNAL_PAYERS_ALL | reference / config |
| SiteContactPVO | oracle.apps.financials.receivables.customers.publicView.analytics.SiteContactPVO | HZ_CUST_ACCOUNT_ROLES, HZ_PARTIES | reference / config |
| SiteContactPointPVO | oracle.apps.financials.receivables.customers.publicView.analytics.SiteContactPointPVO | HZ_CONTACT_POINTS, HZ_RELATIONSHIP_TYPES | reference / config |
| SiteContactRelationShipPVO | oracle.apps.financials.receivables.customers.publicView.analytics.SiteContactRelationShipPVO | HZ_CUST_ACCOUNT_ROLES, HZ_ORG_CONTACTS, HZ_PARTIES | reference / config |
| SiteCreditCardPVO | oracle.apps.financials.receivables.customers.publicView.analytics.SiteCreditCardPVO | HZ_LOCATIONS, IBY_CREDITCARD, IBY_PMT_INSTR_USES_ALL | reference / config |
| SitePaymentNotificationPVO | oracle.apps.financials.receivables.customers.publicView.analytics.SitePaymentNotificationPVO | IBY_EXTERNAL_PAYERS_ALL | reference / config |
| SiteTaxClassificationPVO | oracle.apps.financials.receivables.customers.publicView.analytics.SiteTaxClassificationPVO | HZ_CLASS_CATEGORY_CODES_V, HZ_CODE_ASSIGNMENTS, ZX_FC_TYPES_VL | reference / config |
| SiteTaxExemptionPVO | oracle.apps.financials.receivables.customers.publicView.analytics.SiteTaxExemptionPVO | EGP_SYSTEM_ITEMS_B, HZ_PARTIES, INV_ORG_PARAMETERS | reference / config |
| SiteTaxRegistrationPVO | oracle.apps.financials.receivables.customers.publicView.analytics.SiteTaxRegistrationPVO | HZ_PARTIES, ZX_JURISDICTIONS_VL, ZX_REGIMES_VL | reference / config |
| SiteTaxReportingCodePVO | oracle.apps.financials.receivables.customers.publicView.analytics.SiteTaxReportingCodePVO | ZX_REPORTING_CODES_VL, ZX_REPORTING_TYPES_VL, ZX_REPORT_CODES_ASSOC | reference / config |
| SiteTaxValidationPVO | oracle.apps.financials.receivables.customers.publicView.analytics.SiteTaxValidationPVO | ZX_PARTY_TAXPAYER_IDNTFS, ZX_PARTY_TAX_PROFILE | reference / config |
| TaxClassificationPVO | oracle.apps.financials.receivables.customers.publicView.analytics.TaxClassificationPVO | HZ_CLASS_CATEGORY_CODES_V, HZ_CODE_ASSIGNMENTS, ZX_FC_TYPES_VL | reference / config |
| TaxExemptionPVO | oracle.apps.financials.receivables.customers.publicView.analytics.TaxExemptionPVO | EGP_SYSTEM_ITEMS_B, HZ_PARTIES, INV_ORG_PARAMETERS | reference / config |
| TaxRegistrationPVO | oracle.apps.financials.receivables.customers.publicView.analytics.TaxRegistrationPVO | HZ_PARTIES, ZX_JURISDICTIONS_VL, ZX_REGIMES_VL | reference / config |
| TaxReportingCodePVO | oracle.apps.financials.receivables.customers.publicView.analytics.TaxReportingCodePVO | ZX_REPORTING_CODES_VL, ZX_REPORTING_TYPES_VL, ZX_REPORT_CODES_ASSOC | reference / config |
| TaxValidationPVO | oracle.apps.financials.receivables.customers.publicView.analytics.TaxValidationPVO | ZX_PARTY_TAXPAYER_IDNTFS, ZX_PARTY_TAX_PROFILE | reference / config |
| AdjustmentApprovalActionHistoryPVO | oracle.apps.financials.receivables.publicView.analytics.AdjustmentApprovalActionHistoryPVO | AR_APPROVAL_ACTION_HISTORY | reference / config |
| AdjustmentDistributionPVO | oracle.apps.financials.receivables.publicView.analytics.AdjustmentDistributionPVO | AR_ADJUSTMENTS_ALL, AR_BPA_TEMPLATES_VL, AR_CASH_RECEIPTS_ALL | Transactions fact, Installments fact |
| AdjustmentPVO | oracle.apps.financials.receivables.publicView.analytics.AdjustmentPVO | AR_ADJUSTMENTS_ALL, AR_BPA_TEMPLATES_VL, AR_CASH_RECEIPTS_ALL | Transactions fact, Installments fact |
| ArLookupPVO | oracle.apps.financials.receivables.publicView.analytics.ArLookupPVO | AR_LOOKUPS | reference / config |
| CreditMemoApplicationDistributionPVO | oracle.apps.financials.receivables.publicView.analytics.CreditMemoApplicationDistributionPVO | AR_APP_RULE_SETS, AR_CONS_INV_ALL, AR_DISTRIBUTIONS_ALL | Transactions fact, Installments fact |
| CreditMemoApplicationPVO | oracle.apps.financials.receivables.publicView.analytics.CreditMemoApplicationPVO | AR_APP_RULE_SETS, AR_CONS_INV_ALL, AR_PAYMENT_SCHEDULES_ALL | Transactions fact, Installments fact |
| CreditMemoRequestPVO | oracle.apps.financials.receivables.publicView.analytics.CreditMemoRequestPVO | RA_CM_REQUESTS_ALL | reference / config |
| CustomerPrfilePVO | oracle.apps.financials.receivables.publicView.analytics.CustomerPrfilePVO | AR_APP_EXCEPTION_RULES, AR_AUTOCASH_HIERARCHIES, AR_AUTOMATCH_RULES | reference / config |
| CustomerReceiptMethodPVO | oracle.apps.financials.receivables.publicView.analytics.CustomerReceiptMethodPVO | AR_RECEIPT_METHODS, RA_CUST_RECEIPT_METHODS | Receipts dim |
| DistributionRulePVO | oracle.apps.financials.receivables.publicView.analytics.DistributionRulePVO | RA_RULES | reference / config |
| HeaderSalesCreditPVO | oracle.apps.financials.receivables.publicView.analytics.HeaderSalesCreditPVO | AR_BPA_TEMPLATES_VL, AR_CASH_RECEIPTS_ALL, AR_REVENUE_ADJUSTMENTS_ALL | Transactions fact, Installments dim |
| LineSalesCreditPVO | oracle.apps.financials.receivables.publicView.analytics.LineSalesCreditPVO | AR_BPA_TEMPLATES_VL, AR_CASH_RECEIPTS_ALL, AR_INTEREST_LINES_ALL | Transactions fact, Installments dim |
| MemoLinePVO | oracle.apps.financials.receivables.publicView.analytics.MemoLinePVO | AR_MEMO_LINES_ALL_B, AR_MEMO_LINES_ALL_TL | reference / config |
| MiscReceiptDistributionPVO | oracle.apps.financials.receivables.publicView.analytics.MiscReceiptDistributionPVO | AR_BATCHES_ALL, AR_CASH_RECEIPTS_ALL, AR_DISTRIBUTIONS_ALL | Receipts fact |
| PaymentSchedulePVO | oracle.apps.financials.receivables.publicView.analytics.PaymentSchedulePVO | AR_CASH_RECEIPTS_ALL, AR_CONS_INV_ALL, AR_PAYMENT_SCHEDULES_ALL | Installments fact, Receipts fact |
| PaymentTermBPVO | oracle.apps.financials.receivables.publicView.analytics.PaymentTermBPVO | RA_TERMS_B | reference / config |
| PaymentTermLinePVO | oracle.apps.financials.receivables.publicView.analytics.PaymentTermLinePVO | RA_TERMS_B, RA_TERMS_LINES | reference / config |
| PaymentTermTranslationPVO | oracle.apps.financials.receivables.publicView.analytics.PaymentTermTranslationPVO | RA_TERMS_TL | reference / config |
| RateAdjustmentPVO | oracle.apps.financials.receivables.publicView.analytics.RateAdjustmentPVO | AR_RATE_ADJUSTMENTS_ALL, GL_DAILY_CONVERSION_TYPES | reference / config |
| ReceiptApplicationDistributionPVO | oracle.apps.financials.receivables.publicView.analytics.ReceiptApplicationDistributionPVO | AR_APP_RULE_SETS, AR_BATCHES_ALL, AR_CASH_RECEIPTS_ALL | Transactions fact, Installments fact |
| ReceiptApplicationPVO | oracle.apps.financials.receivables.publicView.analytics.ReceiptApplicationPVO | AR_APP_RULE_SETS, AR_BATCHES_ALL, AR_CASH_RECEIPTS_ALL | Transactions fact, Installments fact |
| ReceiptHeaderPVO | oracle.apps.financials.receivables.publicView.analytics.ReceiptHeaderPVO | AR_BATCHES_ALL, AR_CASH_RECEIPTS_ALL, AR_COLLECTORS | Transactions dim, Installments fact |
| ReceiptHistoryDistributionPVO | oracle.apps.financials.receivables.publicView.analytics.ReceiptHistoryDistributionPVO | AR_CASH_RECEIPTS_ALL, AR_CASH_RECEIPT_HISTORY_ALL, AR_DISTRIBUTIONS_ALL | Transactions fact, Installments fact |
| ReceiptHistoryPVO | oracle.apps.financials.receivables.publicView.analytics.ReceiptHistoryPVO | AR_CASH_RECEIPTS_ALL, AR_CASH_RECEIPT_HISTORY_ALL, AR_PAYMENT_SCHEDULES_ALL | Installments fact, Receipts fact |
| ReceiptMethodPVO | oracle.apps.financials.receivables.publicView.analytics.ReceiptMethodPVO | AR_RECEIPT_CLASSES, AR_RECEIPT_METHODS, IBY_FNDCPT_PMT_CHNNLS_VL | Receipts dim |
| ReconciliationParameterPVO | oracle.apps.financials.receivables.publicView.analytics.ReconciliationParameterPVO | AR_RECON_SUMMARY_PARAMETERS, PER_PERSON_NAMES_F_V | reference / config |
| ReconciliationSummaryPVO | oracle.apps.financials.receivables.publicView.analytics.ReconciliationSummaryPVO | AR_RECON_SUMMARY_DETAILS | reference / config |
| ReferenceAccountPVO | oracle.apps.financials.receivables.publicView.analytics.ReferenceAccountPVO | FUN_ALL_BUSINESS_UNITS_V, GL_CODE_COMBINATIONS, GL_LEDGERS | Transactions dim, Installments dim |
| RevenueAdjustmentDistributionPVO | oracle.apps.financials.receivables.publicView.analytics.RevenueAdjustmentDistributionPVO | AR_REVENUE_ADJUSTMENTS_ALL, EGP_CATEGORIES_VL, EGP_SYSTEM_ITEMS_VL | reference / config |
| RevenueAdjustmentPVO | oracle.apps.financials.receivables.publicView.analytics.RevenueAdjustmentPVO | AR_REVENUE_ADJUSTMENTS_ALL, EGP_CATEGORIES_VL, EGP_SYSTEM_ITEMS_VL | reference / config |
| TransactionBizCategoriesPVO | oracle.apps.financials.receivables.publicView.analytics.TransactionBizCategoriesPVO | ZX_FC_BUSINESS_CATEGORIES_V | reference / config |
| TransactionHeaderPVO | oracle.apps.financials.receivables.publicView.analytics.TransactionHeaderPVO | AR_BPA_TEMPLATES_VL, AR_CASH_RECEIPTS_ALL, AR_LOOKUPS | Transactions fact, Installments fact |
| TransactionHistoryDistributionPVO | oracle.apps.financials.receivables.publicView.analytics.TransactionHistoryDistributionPVO | AR_BATCHES_ALL, AR_DISTRIBUTIONS_ALL, AR_TRANSACTION_HISTORY_ALL | Transactions fact, Installments dim |
| TransactionHistoryPVO | oracle.apps.financials.receivables.publicView.analytics.TransactionHistoryPVO | AR_BATCHES_ALL, AR_TRANSACTION_HISTORY_ALL, FND_DOCUMENT_SEQUENCES | Transactions fact, Installments dim |
| TransactionLineDistributionPVO | oracle.apps.financials.receivables.publicView.analytics.TransactionLineDistributionPVO | AR_BPA_TEMPLATES_VL, AR_CASH_RECEIPTS_ALL, AR_INTEREST_LINES_ALL | Transactions fact, Installments dim |
| TransactionLinePVO | oracle.apps.financials.receivables.publicView.analytics.TransactionLinePVO | AR_BPA_TEMPLATES_VL, AR_CASH_RECEIPTS_ALL, AR_DEFERRED_LINES_ALL | Transactions fact, Installments dim |
| TransactionTypePVO | oracle.apps.financials.receivables.publicView.analytics.TransactionTypePVO | AR_LOOKUPS, RA_CUST_TRX_TYPES_ALL | reference / config |
Want these models built on your data?
Conformed stars, dbt models, reconciled to source — you own all of it.