Oracle Fusion · OTBI subject area
Receivables - Customer Real Time
Free reference39 tables227 columnsFinancials
This is the OTBI subject area you select in Reports & Analytics to report on receivables data. It exposes the presentation columns mapped to the physical tables below, and corresponds to the Receivables module.
OTBI limitation: you can't join two subject areas in a single analysis, and real-time queries hit the live transaction tables. The customer-owned warehouse removes both limits — every subject area is conformed on shared keys so you can join across them, and reporting runs off the warehouse, not production.
Physical tables in this subject area
- AR_APP_EXCEPTION_RULES
- AR_AUTOCASH_HIERARCHIES
- AR_AUTOMATCH_RULES
- AR_CHARGE_SCHEDULES
- AR_COLLECTORS
- AR_RECEIPT_METHODS
- AR_STANDARD_TEXT_TL
- AR_STATEMENT_CYCLES
- FND_LOOKUP_VALUES_TL
- FND_TERRITORIES_TL
- FUN_ALL_BUSINESS_UNITS_V
- GL_DAILY_CONVERSION_TYPES
- GL_LEDGERS
- HZ_CONTACT_POINTS
- HZ_CUSTOMER_PROFILES_F
- HZ_CUST_ACCOUNTS
- HZ_CUST_ACCOUNT_ROLES
- HZ_CUST_ACCT_RELATE_ALL
- HZ_CUST_ACCT_SITES_ALL
- HZ_CUST_PROFILE_AMTS_F
- HZ_CUST_PROFILE_CLASSES
- HZ_CUST_SITE_USES_ALL
- HZ_LOCATIONS
- HZ_ORGANIZATION_PROFILES
- HZ_ORG_CONTACTS
- HZ_ORIG_SYSTEMS_VL
- HZ_ORIG_SYS_REFERENCES
- HZ_PARTIES
- HZ_PARTY_SITES
- HZ_PERSON_PROFILES
- HZ_RELATIONSHIP_TYPES
- IBY_CREDITCARD
- IBY_EXTERNAL_PAYERS_ALL
- IBY_EXT_BANK_ACCOUNTS
- IBY_PAYMENT_CODES_VL
- IBY_PMT_INSTR_USES_ALL
- RA_CUST_RECEIPT_METHODS
- RA_GROUPING_RULES
- RA_TERMS_TL
Need to join Receivables across other subject areas?
That's the warehouse build — conformed dimensions, reconciled to source, you own it.