1. Tables and Views for SCM
  2. CST_WO_UPDATE_EVENT_TXNS

CST_WO_UPDATE_EVENT_TXNS

This entity contains the status change transactions that are staged for the cost processor. Only certain status change transactions will be staged for costing.The cost processor will tie original transactions in a cost organization-cost book based on certain WO statuses. Examples: - WIP Variance - WIP Product Completion Cost Adjustment (for product completions) - WIP Operation Scrap Cost Adjustment (for operation scrap) - WORK ORDER EXPENSE Transaction

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

CST_WO_UPDATE_EVENT_TXNS_PK

WO_UPDATE_EVENT_TXN_ID

Columns

Name Datatype Length Precision Not-null Comments
WO_UPDATE_EVENT_TXN_ID NUMBER 18 Yes Surrogate ID identifying a work order update event in costing. This column will reuse the CST_TRANSACTION_S sequence to maintain the uniqueness of transactions at the distribution level.
CST_WORK_ORDER_ID NUMBER 18 Yes Surrogate ID identifying the work order for which update was performed.
COST_ORG_ID NUMBER 18 Yes Surrogate ID identifying the cost organization associated to the plant where the work order is executed.
COST_BOOK_ID NUMBER 18 Yes Surrogate ID identifying the cost book associated to the cost organization.
EVENT_DATE TIMESTAMP Yes Indicates the date and time when the work order update was performed.
TRANSACTION_DATE TIMESTAMP Indicates the date entered by user while making the status change.
LOGICAL_CLOSE_DATE TIMESTAMP Indicates the date and time when a close event is processed again because of more costs posted on a work order. For the original transaction received from source system this will remain NULL.
INVENTORY_ORGANIZATION_ID NUMBER 18 Yes Surrogate ID identifying the plant associated to the work order.
COST_DATE TIMESTAMP Cost date derived for sequencing the work order close transactions.
PERIOD_NAME VARCHAR2 15 Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method.
LE_TIMEZONE_CODE VARCHAR2 50 Legal Entity timezone. If NULL, then LE timezone is not enabled for the data in the row and the dates are assumed to be in database timezone.
CST_WO_UPDATE_EVENT_ID NUMBER 18 Yes Surrogate ID identifying the source update event in costing.
TXN_SOURCE_DOC_TYPE VARCHAR2 50 Document Type of the transaction. E.g. "WO" indicating a Work Order.
TXN_SOURCE_DOC_NUMBER VARCHAR2 240 Document Number of the transaction. This is the Work Order Number.
TXN_SOURCE_REF_DOC_TYPE VARCHAR2 50 For R11, this is the same as the Transaction Source Doc Type. In later release this can be a FPO linked to a WO.
TXN_SOURCE_REF_DOC_NUMBER VARCHAR2 240 For R11, this is the same as the Transaction Source Doc Number. In later release this can be a FPO Number linked to a WO.
BASE_TXN_TYPE_ID NUMBER 18 Yes Transaction type identifier. For close transactions this value comes from CST_INTERNAL_TXN_TYPES_VL.
BASE_TXN_SOURCE_TYPE_ID NUMBER 18 Yes Transaction source type identifier. For close transactions this value will come from CST_INTERNAL_TXN_TYPES_VL. This value will always be 0.
BASE_TXN_ACTION_ID NUMBER 18 Yes Transaction action identifier. For close transactions this value will come from CST_INTERNAL_TXN_TYPES_VL.
ITEM_COST_PROFILE_ID NUMBER 18 Identifies the item cost profile of the primary product of the Work Order associated to the close transaction.
COST_PROFILE_ID NUMBER 18 Surrogate ID identifying the cost profile based on the item setup being asset/expense.
COST_METHOD_CODE VARCHAR2 30 Cost method associated with cost profile of the primary item. This will be used to determine how to process the job close transaction eg. to expense or create variance.
TOTAL_COMPLETION_QUANTITY NUMBER This value would be populated at the time of processing this transaction to indicate the total completion quantity.
TOTAL_SCRAP_QUANTITY NUMBER This value would be populated at the time of processing this transaction to indicate the total scrap quantity.
PRODUCT_ADJ_PROCESSED_FLAG VARCHAR2 5 Yes Indicates if product completions and returns have been adjusted after the work order close to reflect the latest WIP value. Default N. Valid values are X, N and Y.
UOM_CODE VARCHAR2 3 Indicates the unit of measure for the completion quantity.
SCRAP_ADJ_PROCESSED_FLAG VARCHAR2 5 Yes Indicates if scrap and scrap returns have been adjusted after the work order close to reflect the latest WIP value. Default N. Valid values are X, N and Y.
WORK_ORDER_STATUS_ID NUMBER 18 Yes Indicates the current status of the work order after the update.
WO_SYSTEM_STATUS_CODE VARCHAR2 30 Yes Indicates the system status code derived using WIE_WO_STATUSES_VL.
PRIOR_WORK_ORDER_STATUS_ID NUMBER 18 Indicates the prior status of the work order before the update was performed.
PRIOR_WO_SYSTEM_STATUS_CODE VARCHAR2 30 Indicates the prior system status code derived using WIE_WO_STATUSES_VL.
INVENTORY_ITEM_ID NUMBER 18 Yes Surrogate ID identifying the primary item associated to the work order.
EXPENSE_REVERSED_FLAG VARCHAR2 4 Indicates the reversal status for the job close transaction that was earlier expensed. Possible values N - Not reversed, Y - Reversed and NULL.
REVERSAL_COST_DATE TIMESTAMP Indicates the cost date derived for booking the reversal of this expense transaction.
PREPROCESSING_STATUS VARCHAR2 30 Yes Indicates the preprocessing status SUCCESS, ERROR.
ERROR_CODE VARCHAR2 30 FND error code identifying the error message in case the transaction is in error.
POSTED_FLAG VARCHAR2 5 Indicates whether the update transaction has been processed by the cost processor. N-No, Y-Yes Null.
COSTING_STATUS VARCHAR2 1 Status of the transaction which denotes, whether a transaction has been pre-processed, processed by cost processors, distributions have been created or processed by sub-ledger accounting etc. C Fully costed E Error N Not processed P Partially costed X Excluded W Pending.
ACCOUNTING_STATUS VARCHAR2 1 Current accounting status of the transaction for display: D Draft accounted E Error F Final accounted N Not accounted X Excluded from accounting Z Not applicable.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.

Indexes

Index Uniqueness Tablespace Columns
CST_WO_UPDATE_EVENT_TXNS_N1 Non Unique Default POSTED_FLAG, COST_ORG_ID, COST_BOOK_ID
CST_WO_UPDATE_EVENT_TXNS_N2 Non Unique Default COSTING_STATUS
CST_WO_UPDATE_EVENT_TXNS_N3 Non Unique Default TXN_SOURCE_REF_DOC_NUMBER
CST_WO_UPDATE_EVENT_TXNS_N4 Non Unique Default CST_WO_UPDATE_EVENT_ID
CST_WO_UPDATE_EVENT_TXNS_N5 Non Unique Default NVL("TRANSACTION_DATE","EVENT_DATE")
CST_WO_UPDATE_EVENT_TXNS_N6 Non Unique Default INVENTORY_ITEM_ID, NVL("TRANSACTION_DATE","EVENT_DATE")
CST_WO_UPDATE_EVENT_TXNS_PK Unique Default WO_UPDATE_EVENT_TXN_ID
CST_WO_UPDATE_EVENT_TXNS_U1 Unique Default COST_ORG_ID, COST_BOOK_ID, CST_WO_UPDATE_EVENT_ID, LOGICAL_CLOSE_DATE
CST_WO_UPDATE_EVENT_TXNS_U2 Unique Default COST_ORG_ID, COST_BOOK_ID, CST_WORK_ORDER_ID, EVENT_DATE, LOGICAL_CLOSE_DATE