Search Results insert_serial_numbers




Overview
Explore in AI Chat

Overview

CSL_MTL_SERIAL_NUMBERS_ACC_PKG is an APPS-owned PL/SQL package in Oracle E-Business Suite that supports the serial number accounting and reconciliation logic associated with the CSL (Customer Service / Depot Repair) module. Its header comment (cslsnacs.pls 120.0) indicates it originates from the field service and depot repair code line, and the package is classified as an "OTHER" API rather than a public, supported interface. In practice, the package maintains the relationship between physical inventory serial numbers (MTL_SERIAL_NUMBERS) and the accounting-level serial number staging tables used by the service organization. It provides entry points for inserting, deleting, and updating accounting serial numbers, as well as a procedure for processing concurrent request serial number output. The package is referenced by one other package in the EBS code base, suggesting it is an internal building block consumed by higher level service processing logic rather than being called directly by end users.

Key Procedures and Functions

The package exposes four documented procedures, all declared in the package specification:

  • INSERT_SERIAL_NUMBERS — Populates the accounting serial number tables for a given resource. It accepts a resource identifier parameter and is the primary entry point used to bring serial number data into the CSL accounting staging structures for that resource.
  • DELETE_SERIAL_NUMBERS — Removes accounting serial number records. It takes no parameters, indicating it operates on a defined working set (for example, records staged for the current session or concurrent request).
  • UPDATE_SERIAL_NUMBERS — Refreshes accounting serial number records, accepting a date parameter that is used to qualify which records are updated (typically records on or before the supplied date).
  • CON_REQUEST_SERIAL_NUMBERS — Handles serial number processing in the context of a concurrent request, coordinating the serial number data generated for the concurrent program run. It takes no parameters and likely reads the concurrent request context from the running session.

The absence of return values on all four procedures confirms the package operates by side effect, writing to and modifying database tables rather than returning result sets to the caller.

Tables Accessed

The package reads and writes a set of APPS-synonym tables. Core inventory serial data resides in MTL_SERIAL_NUMBERS, the base Oracle Inventory table holding serialized item instances. The CSL-specific accounting mirror is JTM_MTL_SERIAL_NUMBERS_ACC, which stores the accounting representation of those serial numbers, and JTM_ACC_TABLE_S, a setup table that drives accounting configuration. Concurrent request context is captured through JTM_CON_REQUEST_DATA.

Resource and responsibility resolution uses JTF_RS_RESOURCE_EXTNS (resource extensions for the resource identifier), FND_USER, ASG_USER, and ASG_PUB_RESPONSIBILITY and ASG_PUB from the CRM resource manager, which resolve which user and responsibility are processing the transaction. Inventory location assignments are validated through CSP_INV_LOC_ASSIGNMENTS, and PLITBLM is used as a PL/SQL index-by table for bulk processing serial number collections.

Usage Notes

Because this package is documented as an "OTHER" API, it is not part of the officially supported public API surface and is not intended for direct invocation by customers or third-party integrations. It is typically called from within Oracle's own service, depot repair, or field service forms and concurrent programs, where INSERT_SERIAL_NUMBERS, UPDATE_SERIAL_NUMBERS, and DELETE_SERIAL_NUMBERS are invoked in sequence to synchronize and reconcile serial number accounting data, and CON_REQUEST_SERIAL_NUMBERS is invoked from the concurrent manager to process the associated request output. The package appears in Oracle EBS 12.1.1 and 12.2.2 and, being internal, may be altered or replaced by Oracle in later patches; custom code should avoid direct dependencies on these procedures.