Search Results csm_mtl_system_items_acc_s

Overview

CSM_MTL_SYSTEM_ITEMS_EVENT_PKG is an APPS-owned PL/SQL package body in Oracle E-Business Suite (validated against 12.1.1 and 12.2.2) that forms part of the Oracle TeleService / Depot Repair infrastructure supporting "Create Service" and field service item-event processing. Its central purpose is to maintain the customer-facing, service-oriented subset of inventory master data — the items that a call center agent or field service user is permitted to select when authoring service requests, incidents, and return or repair transactions. The package bridges Oracle Inventory's item master (MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS_TL) with the CSM "Acc" (accessible) shadow tables, which pre-compute item accessibility by user, inventory organization, and responsibility. The user search term "csm_mtl_system_items_acc_s" corresponds directly to the CSM_MTL_SYSTEM_ITEMS_ACC_S table referenced by this package; the trailing "_S" denotes the sequence used to generate primary keys for the accessible-items cache. By populating and refreshing that cache, the package allows service applications to query item data through lightweight local tables rather than joining directly to high-volume Inventory tables, improving response time in the Service Request and incident forms.

Key Procedures and Functions

ETRM documents four callable units within this package body:

• REFRESH_MTL_SYSTEM_ITEMS_ACC — the primary maintenance routine. It rebuilds or reconciles the contents of the accessible-items cache (CSM_MTL_SYSTEM_ITEMS_ACC) against current Inventory master data, honoring profile options, user responsibility, and inventory organization restrictions. It is the unit typically scheduled from a concurrent program or invoked after item-master changes.
• GET_NEW_USER_MTL_SYSTEM_ITEMS — returns the set of system items that are newly accessible to a given user, based on the user's current organization and responsibility assignments. It isolates the delta between what a user could previously see and what the refresh has now made available.
• MTL_SYSTEM_ITEMS_ACC_I — the insert handler for the accessible-items cache, adding rows for items newly granted visibility to a user or organization.
• MTL_SYSTEM_ITEMS_ACC_D — the delete handler for the accessible-items cache, removing rows whose accessibility has been revoked.

Together the four units implement an I(nsert)/D(elete) maintenance pattern, with GET_NEW_USER_MTL_SYSTEM_ITEMS supplying the driving set and REFRESH_MTL_SYSTEM_ITEMS_ACC orchestrating the operation. The package is not referenced by any database object, confirming it is a top-level driver rather than a subordinate library.

Tables Accessed

The package depends on a broad cross-section of Service, Inventory, and CSC schema objects (accessed through APPS synonyms). The core write target is CSM_MTL_SYSTEM_ITEMS_ACC, with its companion sequence object CSM_MTL_SYSTEM_ITEMS_ACC_S. Supporting access tables include CSM_ITEM_INSTANCES_ACC, CSM_INCIDENTS_ALL_ACC, CSM_REQ_LINES_ACC, CSM_REQ_LINE_DETAILS_ACC, and CSM_USER_INVENTORY_ORG, which establish user-to-organization context. Master data is read from MTL_SYSTEM_ITEMS, MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS_TL, MTL_ITEM_CATEGORIES, MTL_CATEGORIES, and MTL_CATEGORY_SETS. Service transaction context comes from CS_INCIDENTS_ALL_B, CS_TRANSACTION_TYPES_B, CSI_ITEM_INSTANCES, CSP_REQUIREMENT_HEADERS, CSP_REQUIREMENT_LINES, CSP_REQ_LINE_DETAILS, and OE_ORDER_LINES_ALL. Utilities include FND_API, FND_GLOBAL, FND_LOG, FND_PROFILE, FND_RESPONSIBILITY, FND_USER, ASG_USER, ASG_DOWNLOAD, and JTM_CON_REQUEST_DATA. Related CSM packages (CSM_ACC_PKG, CSM_PROFILE_PKG, CSM_UTIL_PKG, CSM_SYSTEM_ITEM_EVENT_PKG) are invoked for shared logic.

Usage Notes

CSM_MTL_SYSTEM_ITEMS_EVENT_PKG is normally invoked indirectly. The refresh routine is scheduled as a concurrent program during implementation and after bulk item-master loads, so that the accessible-items cache reflects newly defined or re-categorized items. The event-driven procedures are called from service application forms (Service Request, Incident, Depot Repair) when a user's organization or responsibility changes, or when a user first requests an item list. Only five other packages reference this object, indicating a narrow, deliberately encapsulated call surface. Customizations that add or restructure inventory categories should re-run the refresh to keep the cache synchronized; direct DML against CSM_MTL_SYSTEM_ITEMS_ACC is not recommended, as the package maintains integrity between the cache, sequence, and dependent CSM access tables.