Oracle Fusion ERP · P · Data model
Payments data model
Payments 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 star0 PVOs
Use case. Iby Trxn Documents analysis — the grain behind 3 report(s) in this module.
●— fact → dimension join
Fact — IBY_TRXN_DOCUMENTS
Grain: one row per iby trxn documents record. Derived measures: Amount. Drill into the fact columns:
Column inventory surfaces on the table page.
Dimensions / click any to drill into its columns
IBY_FORMATS_VL · dimension
Column inventory surfaces on the table page.
IBY_PAYMENT_METHODS_TL → · dimension
| Column | Definition |
|---|---|
| DESCRIPTION | Description. |
| PAYMENT_METHOD_CODE | Code identifying the payment method. |
| PAYMENT_METHOD_NAME | Name of the payment method. |
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.