Search Results delete_system_items

Overview

APPS.CSM_SYSTEM_ITEM_EVENT_PKG is a PL/SQL package within the Oracle EBS Applications schema that supports the Oracle Field Service and telephony-related components of the Customer Service (CS) module family. Its primary business function is to maintain the data structures that associate system items (inventory-tracked products) with users, user resources, and the appropriate field service accounts. The package responds to event-driven changes in system item assignments — such as the receipt of on-hand quantities, changes to item instance status, and modifications to user responsibility assignments — and propagates those changes into the CSM staging and account tables used by field service operations.

In EBS 12.1.1 and 12.2.2, the CSM_* event packages form a coordinated layer that keeps customer service data synchronized with the underlying inventory and installer data held in the Oracle Inventory (MTL/CSI) tables. CSM_SYSTEM_ITEM_EVENT_PKG sits within this layer and is invoked both from sibling event packages and from concurrent job processing.

Key Procedures and Functions

The documented package exposes seven procedures and functions:

• REFRESH_MTL_ONHAND_QUANTITY — Reconciles the CSM on-hand quantity staging table (CSM_MTL_ONHAND_QTY_ACC) against the authoritative inventory on-hand data in MTL_ONHAND_QUANTITIES_DETAIL for the system items in scope.
• REFRESH_ACC — Refreshes the account-level CSM accelerator tables (for example CSM_INV_LOC_ASS_ACC, CSM_ITEM_INSTANCES_ACC, CSM_SYSTEM_ITEMS_ACC) to reflect current item, instance, and location assignment data.
• GET_NEW_USER_SYSTEM_ITEMS — Retrieves the set of system items newly associated with a user, typically after a responsibility or organization assignment change, so that downstream processing can register the new items.
• SYSTEM_ITEM_MDIRTY_I — Marks system item records as “logically dirty” on insert, signaling dependent processes that recalculation or resynchronization is required.
• SYSTEM_ITEM_MDIRTY_D — Marks system item records as dirty on delete, supporting cleanup of dependent staging rows.
• DELETE_SYSTEM_ITEMS — Removes system item associations that are no longer valid for a user or resource.
• RECEIVED_MTL_ONHAND — Handles the event triggered when on-hand inventory is received for a system item, updating the CSM on-hand accelerator and related quantities.

Parameter signatures are not documented in the ETRM extract and should be confirmed by inspecting the package header in the target environment.

Tables Accessed

The package reads and writes a defined set of tables accessed through APPS synonyms. User and resource context is drawn from ASG_USER and ASG_USER_PUB_RESPS. Item instance and status data come from CSI_ITEM_INSTANCES and CSI_INSTANCE_STATUSES. Location and inventory assignment context is held in CSP_INV_LOC_ASSIGNMENTS, CSM_USER_INVENTORY_ORG, and CSM_INV_LOC_ASS_ACC. Quantities are staged and reconciled through CSM_MTL_ONHAND_QTY_ACC, CSM_MTL_ONHAND_QTY_ACC_S, and MTL_ONHAND_QUANTITIES_DETAIL. Account-level system item data is maintained in CSM_SYSTEM_ITEMS_ACC and CSM_SYSTEM_ITEMS_ACC_S, with item instance accounts in CSM_ITEM_INSTANCES_ACC. Billing classification is referenced via CS_BILLING_TYPE_CATEGORIES, and telephony request data via JTM_CON_REQUEST_DATA.

Usage Notes

CSM_SYSTEM_ITEM_EVENT_PKG is not typically invoked directly by end users. It is referenced by several sibling packages — CSM_CONCURRENT_JOBS_PKG, CSM_DEBRIEF_EVENT_PKG, CSM_MTL_SYSTEM_ITEMS_EVENT_PKG, CSM_MULTI_MOBQRY_PKG, CSM_ORDERS_PKG, and CSM_USER_EVENT_PKG — which call into it in response to field service events. In practice it is executed through concurrent programs such as the CSM concurrent job framework, and through forms or custom code that need to resynchronize system item assignments after inventory receipts, user responsibility changes, or item instance status updates. Customizations should call the package through its documented procedures rather than modifying the underlying CSM accelerator tables directly, to preserve the integrity of the dirty-flag mechanism implemented by SYSTEM_ITEM_MDIRTY_I and SYSTEM_ITEM_MDIRTY_D.