Search Results log_transaction_data

Overview

WSM_WIP_LOT_TXN_PVT is a private PL/SQL package in the APPS schema that supports the Oracle Manufacturing Execution System (MES) and Work in Process (WIP) lot transaction functionality within Oracle E-Business Suite Release 12.1.1 and 12.2.2. The package encapsulates the business logic required to create, validate, and post lot-based transactions against discrete jobs, including split, merge, assembly update, routing update, quantity update, lot name update, bonus, bill of material update, status update, and component subinventory/locator update operations. It acts as the transaction-processing engine that receives transaction header data through a record type (WLTX_TRANSACTIONS_REC_TYPE) and job-related record types such as WLTX_STARTING_JOBS_REC_TYPE, and then orchestrates the appropriate WIP transaction API calls.

The package is classified as PVT (private), meaning it is intended for internal consumption by other WSM and WIP packages rather than being called directly from form-level or custom code. Its primary business value lies in enabling shop-floor operators and MES clients to perform controlled lot transactions while enforcing validation rules, capturing audit attributes, and persisting transaction history for traceability.

Key Procedures and Functions

The package exposes thirteen documented procedures and functions, each addressing a specific transaction category:

• INVOKE_TXN_API — Central entry point that dispatches a transaction request to the appropriate WIP API based on the transaction type supplied in the header record.
• SPLIT_TXN — Processes a job or lot split transaction, creating resulting jobs from a starting job.
• MERGE_TXN — Processes a merge transaction, combining starting jobs into one or more resulting jobs.
• UPDATE_ASSEMBLY_TXN — Updates the assembly associated with a WIP job.
• UPDATE_ROUTING_TXN — Updates routing information, such as operations and departments, on a WIP job.
• UPDATE_QUANTITY_TXN — Adjusts the transaction quantity on a job or lot.
• UPDATE_LOTNAME_TXN — Changes the lot name associated with a transaction.
• BONUS_TXN — Records a bonus (over-completion) quantity against a job.
• UPDATE_BOM — Updates bill of material component information for the job.
• UPDATE_STATUS — Changes the status of a WIP entity or job.
• UPDATE_COMP_SUBINV_LOC — Updates the subinventory and locator for a job component.
• LOG_TRANSACTION_DATA — Persists transaction header and detail data for audit and error tracking.

Tables Accessed

The package reads from and writes to core WIP and WSM tables through APPS synonyms. WIP_DISCRETE_JOBS, WIP_ENTITIES, and WIP_OPERATIONS hold the job and operation records being updated. BOM_DEPARTMENTS, BOM_OPERATION_SEQUENCES, and BOM_STANDARD_OPERATIONS provide routing and department validation data used by UPDATE_ROUTING_TXN and UPDATE_ASSEMBLY_TXN. WSM_SPLIT_MERGE_TRANSACTIONS stores the transaction header and detail records, while WSM_SM_STARTING_JOBS and WSM_SM_RESULTING_JOBS capture the source and target jobs for split and merge operations. WSM_JOB_SECONDARY_QUANTITIES supports secondary quantity handling, and PLITBLM is used for temporary or interface-style processing.

Usage Notes

WSM_WIP_LOT_TXN_PVT is referenced by seven other packages and is normally invoked indirectly through higher-level WSM or WIP transaction wrappers, MES client callouts, or concurrent programs that process lot transaction batches. Custom code should call the public WSM or WIP APIs rather than this private package directly, since its signature and internal logic may change without notice and it is not documented as a supported extension point. When troubleshooting the "update_routing_txn" operation, DBAs and developers should trace the call from INVOKE_TXN_API into UPDATE_ROUTING_TXN and inspect the associated BOM routing tables and WSM_SPLIT_MERGE_TRANSACTIONS rows.