Search Results clear_wip_line_ops_cache

Overview

APPS.WIP_FLOW_UTILITIES is a Work in Process (WIP) utility package that supports flow manufacturing and repetitive schedule processing within Oracle E-Business Suite release 12.1.1 and 12.2.2. Its primary responsibility is to centralize the validation, creation, update, and deletion of WIP flow schedules, along with the supporting validation logic used during interface processing and inventory transaction handling.

The package sits within the flow scheduling and work order layer of WIP, providing reusable routines that other EBS modules and custom code invoke when managing flow schedules tied to a WIP entity, organization, and primary item. It also performs prerequisite validations before and after inventory transactions, cleans up transactional artifacts following completion, and reconstructs routing-derived line operation data used by the scheduling engine.

Key Procedures and Functions

The package exposes 26 documented procedures and functions. Their purposes are as follows:

• SUBS_CHECK — Validates substitution relationships for a parent item within a given organization, returning status and error information.
• REVISION_GENERATION — Derives revision information for an interface record, supporting flow manufacturing revision handling.
• GENERATE_ISSUE_LOCATOR_ID — Determines the appropriate issue locator for a flow schedule based on organization, project, task, and WIP entity context.
• PRE_INV_VALIDATIONS — Performs validations on the interface data before inventory transaction processing, populating a header identifier for downstream use.
• POST_INV_VALIDATIONS — Performs validations after inventory transactions complete, using the header and organization header identifiers.
• POST_TRANSACTION_CLEANUP — Cleans up residual data associated with a processed transaction header.
• CREATE_FLOW_SCHEDULES — Bulk creation of flow schedules for a given header.
• CREATE_FLOW_SCHEDULE — Creates an individual flow schedule for a specified WIP entity and organization, capturing standard audit and primary item attributes.
• DELETE_FLOW_SCHEDULES — Bulk deletion of flow schedules, most commonly referenced when cleanup of scheduling records is required. This is the routine users typically search for when removing flow schedule data.
• DELETE_FLOW_SCHEDULE — Deletes an individual flow schedule.
• UPDATE_FLOW_SCHEDULE — Modifies attributes of an existing flow schedule.
• STATUS_CHANGE — Transitions a flow schedule between statuses such as released, complete, or on hold.
• UPDATE_COMPLETION_UOM — Adjusts the unit of measure associated with completion transactions.
• CHECK_VALIDATION_ERRORS — Inspects accumulated validation errors and reports their presence.
• FLOW_ERROR_CLEANUP — Removes error records created during flow processing.
• CONSTRUCT_WIP_LINE_OPS — Builds WIP line operation records derived from routing data.
• LINE_OP_EXISTS — Verifies whether a given line operation already exists.
• CLEAR_WIP_LINE_OPS_CACHE — Flushes cached line operation data.
• SHOW_WIP_LINE_OPS — Returns or displays WIP line operation information.
• LINE_OP_SAME_OR_PRIOR — Determines whether a line operation is the same as, or precedes, a reference operation.

Tables Accessed

The package operates against several core EBS tables via APPS synonyms.

• BOM_OPERATIONAL_ROUTINGS and BOM_OPERATION_SEQUENCES — supply routing and operation sequence data used when constructing WIP line operations.
• MTL_ITEM_REVISIONS, MTL_SYSTEM_ITEMS, MTL_SYSTEM_ITEMS_B, and MTL_SYSTEM_ITEMS_KFV — provide item master and revision information for validation and schedule creation.
• MTL_MATERIAL_TRANSACTIONS and MTL_MATERIAL_TRANSACTIONS_S — support inventory transaction validation and post-transaction cleanup.
• MTL_TRANSACTIONS_INTERFACE — holds interface rows validated before and after processing.
• MTL_TRANSACTION_LOTS_INTERFACE and MTL_TRANSACTION_LOTS_TEMP — manage lot data during interface processing.
• MTL_LOT_NUMBERS and MTL_SERIAL_NUMBERS_INTERFACE — support lot and serial validation.
• MTL_TRANSACTION_TYPES — supplies transaction type definitions.
• WIP_ACCOUNTING_CLASSES — provides accounting class context for WIP entities.

Usage Notes

WIP_FLOW_UTILITIES is generally invoked from flow scheduling forms, concurrent programs that process the flow schedule interface, and inventory transaction import routines. Custom extensions frequently call DELETE_FLOW_SCHEDULES and DELETE_FLOW_SCHEDULE during data cleanup. The package is referenced by three other packages, confirming its role as a shared utility. Because it manipulates production WIP and inventory data directly, it should be invoked within transactional boundaries and with appropriate error handling for the exposed error number and message parameters.