Oracle Fusion · Data dictionary
FOS_TXN_EVENTS
SharedUsed in 2 subject areas21 reporting columns
Source object in the Oracle Fusion data model.
Primary key: not declared here, see Oracle's Tables and Views page for FOS_TXN_EVENTS
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CORRECTION_FLAG | ● | Indicator (Y/N) for the correction. | |
| EVENT_DATA_ID | ● | Identifier for the event data. | |
| EVENT_DATE | ● | Event date. | |
| EVENT_DEFINITION_ID | ● | Identifier for the event definition. | |
| EVENT_LINE_NUMBER | ● | Event line number. | |
| EVENT_NUMBER | ● | Event number. | |
| PARENT_EVENT_DATA_ID | ● | Identifier for the parent event data. | |
| PARENT_EVENT_DEFINITION_ID | ● | Identifier for the parent event definition. | |
| QUANTITY | ● | Quantity. | |
| RECEIPT_AMOUNT | ● | Receipt amount. | |
| RECEIPT_CURRENCY_CODE | ● | Currency code for the receipt. | |
| REFERENCE_EVENT_DATA_ID | ● | Identifier for the reference event data. | |
| REFERENCE_EVENT_DEFINITION_ID | ● | Identifier for the reference event definition. | |
| RETURN_CONSIGNMENT_STOCK_FLAG | ● | Indicator (Y/N) for the return consignment stock. | |
| SECONDARY_QTY | ● | Secondary quantity. | |
| SECONDARY_UOM | ● | Secondary unit of measure. | |
| SOURCE_TXN_EVENT_ID | ● | Identifier for the source transaction event. | |
| STATUS | ● | Status. | |
| SYSTEM_ID | ● | Identifier for the system. | |
| TRANSACTION_ORG_CODE | ● | Code identifying the transaction organization. | |
| UOM | ● | Unit of measure. |
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. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
- Costing - Fiscal Document Capture Transactions Real Time
- Supply Chain Financial Orchestration Real Time
Need the extract + dbt staging for FOS_TXN_EVENTS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table