Oracle Fusion · Data dictionary
CMF_FD_LOC_INFO_PERSIST_OTBI_V
CostingUsed in 3 subject areas12 reporting columns
denormalized view.
Primary key: not yet catalogued for CMF_FD_LOC_INFO_PERSIST_OTBI_V, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ISSUER_CUSTOMER_TAXPAYER_ID | ● | Identifier for the issuer customer taxpayer. | |
| ISSUER_LE_TAXPAYER_ID | ● | Identifier for the issuer legal entity taxpayer. | |
| ISSUER_SUPPLIER_TAXPAYER_ID | ● | Identifier for the issuer supplier taxpayer. | |
| RECEIVER_CUSTOMER_TAXPAYER_ID | ● | Identifier for the receiver customer taxpayer. | |
| RECEIVER_LE_TAXPAYER_ID | ● | Identifier for the receiver legal entity taxpayer. | |
| RECEIVER_SUPPLIER_TAXPAYER_ID | ● | Identifier for the receiver supplier taxpayer. | |
| SHIPFROM_CUSTOMER_TAXPAYER_ID | ● | Identifier for the shipfrom customer taxpayer. | |
| SHIPFROM_LE_TAXPAYER_ID | ● | Identifier for the shipfrom legal entity taxpayer. | |
| SHIPFROM_SUPPLIER_TAXPAYER_ID | ● | Identifier for the shipfrom supplier taxpayer. | |
| SHIPTO_CUSTOMER_TAXPAYER_ID | ● | Identifier for the shipto customer taxpayer. | |
| SHIPTO_LE_TAXPAYER_ID | ● | Identifier for the shipto legal entity taxpayer. | |
| SHIPTO_SUPPLIER_TAXPAYER_ID | ● | Identifier for the shipto supplier taxpayer. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.
- Fiscal Document Capture Transactions Real Time
- Fiscal Document Holds Real Time
- Fiscal Document Item Deliveries Real Time
Need the extract + dbt staging for CMF_FD_LOC_INFO_PERSIST_OTBI_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table