Oracle Fusion · Data dictionary
WIE_RESOURCE_TRANSACTIONS
SharedUsed in 2 subject areas15 reporting columns
Work in Process (WIE).
Likely primary key: WO_RESOURCE_TRANSACTION_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| REQUIRED_USAGE | ● | Required usage. | |
| SOURCE_HEADER_REF | ● | Source header reference. | |
| SOURCE_LINE_REF | ● | Source line reference. | |
| SOURCE_SYSTEM_CODE | ● | Code identifying the source system. | |
| SOURCE_SYSTEM_ID | ● | Identifier for the source system. | |
| SOURCE_SYSTEM_TYPE | ● | Type of source system. | |
| TRANSACTION_DATE | ● | Transaction date. | |
| TRANSACTION_QUANTITY | ● | Transaction quantity. | |
| TRANSACTION_TYPE_CODE | ● | Code identifying the transaction type. | |
| TRANSACTION_UOM_CODE | ● | Code identifying the transaction unit of measure. | |
| WO_RESOURCE_TRANSACTION_ID | PK? | ● | Identifier for the wo resource transaction. |
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.
Need the extract + dbt staging for WIE_RESOURCE_TRANSACTIONS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table