Search Results cc_transact

Overview

MTL_CC_TRANSACT_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Cycle Count (physical inventory) transaction engine. It provides the server-side logic used to record and validate cycle count transactions raised against inventory items, lots, and serial numbers. The package is classified in ETRM as an OTHER API, meaning it is not a formally published public interface but is nevertheless referenceable by other Oracle inventory modules. Invalidation and replenishment processing for cycle counts, together with the Cycle Count Open Interface (CCEOI), depend on this package to translate user-entered count results into material transaction records.

Key Procedures and Functions

The ETRM documentation for release 12.2.2 lists a single documented procedure:

• CC_TRANSACT — The core transactional routine. It accepts a cycle count transaction request and drives the validation and insertion of the corresponding material transaction. Its responsibilities include resolving the item, lot, and serial context of the count, validating that the referenced entities are legitimate, and writing the transaction into the MTL_MATERIAL_TRANSACTIONS interfaces. Because it operates against temporary and interface tables, it functions as the bridge between the cycle count entry screens and the standard inventory transaction processor.

No public function signatures or parameter lists are published in the ETRM metadata; callers should treat the procedure as internal and avoid constructing direct calls from custom code.

Tables Accessed

The package reads and writes the following documented tables, referenced through APPS synonyms:

• MTL_MATERIAL_TRANSACTIONS_TEMP — the staging table where the cycle count transaction is assembled before processing.
• MTL_MATERIAL_TRANSACTIONS_S — the sequence used to generate transaction identifiers.
• MTL_TRANSACTION_LOTS_TEMP — temporary lot-level transaction detail associated with the pending count adjustment.
• MTL_LOT_NUMBERS — validation of the lot being counted.
• MTL_SERIAL_NUMBERS and MTL_SERIAL_NUMBERS_TEMP — serial number validation and staging for serial-controlled items.
• MTL_SYSTEM_ITEMS — item master attributes, including control flags and UOM, used to drive validation.
• DUAL — utility selection for scalar values.

In addition, the package depends on the SYS.STANDARD package provided by the database.

Usage Notes

MTL_CC_TRANSACT_PKG is not intended to be called directly from custom forms or concurrent programs. Instead, it is invoked indirectly by the cycle count application layer. The ETRM dependency list shows it is referenced by INV_CYC_LOVS, MTL_CCEOI_ACTION_PUB, and MTL_CCEOI_PROCESS_PVT, confirming its role inside the Cycle Count Open Interface and cycle count list-of-values processing. Administrators and developers troubleshooting cycle count posting errors should trace execution through these parent packages rather than attempting to invoke CC_TRANSACT in isolation. Because the package manipulates temporary interface tables, it must be executed within the same session and transaction context as the calling cycle count process; calling it outside that flow can leave orphaned rows in the temporary tables. The object is VALID in 12.1.1 and 12.2.2, so no compatibility differences are documented between the two releases. Customizations should preferably be layered on the CCEOI public packages, which represent the supported integration point, rather than on this internal transaction package.