Search Results validate_itemsku

Overview

MTL_CCEOI_PROCESS_PVT is a private PL/SQL package body in the APPS schema that implements the processing engine behind Oracle EBS Cycle Count open interface imports. In Oracle E-Business Suite 12.1.1 and 12.2.2, cycle counting is used to validate on-hand quantities for selected items in a subinventory without halting production or order fulfillment. Physical counts are captured by warehouse personnel and ultimately staged in the MTL_CC_ENTRIES_INTERFACE table before being applied against the live count structure defined by MTL_CYCLE_COUNT_HEADERS, MTL_CYCLE_COUNT_ITEMS, and MTL_CYCLE_COUNT_ENTRIES.

This package serves as the validation, transformation, and posting layer for that inbound count data. It accepts raw interface rows, validates them against inventory setup, class definitions, item attributes, UOM conversions, lot and serial controls, and location rules; records rejects to the interface error table; and, when validation succeeds, generates the cycle count entry records and any resulting adjustments. Because the object is classified as a Private (PVT) API, it is not intended as a public integration contract; it is called internally by concurrent programs and sibling packages such as MTL_CC_TRANSACT_PKG. The dependency metadata lists 20 documented procedures and confirms the package is VALID in the documented environment.

Key Procedures and Functions

• PROCESS_DATA — Main driver that iterates the open interface and orchestrates validation, insertion, and error handling.
• VALIDATE_CHEADER, VALIDATE_COUNTLISTSEQ, VALIDATE_ITEMSKU, VALIDATE_UOMQUANTITY, VALIDATE_CDATE_COUNTER, VALIDATE_SECONDARYUOMQTY — Validation routines that confirm the count header, count list sequence, item identifier, primary and secondary quantities, count date, and counter are legitimate before processing.
• INSERT_CCIENTRY, UPDATE_CCIENTRY, DELETE_CCIENTRY — Maintain cycle count entry rows in the interface staging structures.
• INSERT_CCENTRY, UPDATE_CCENTRY — Populate and amend the production cycle count entries table.
• INSERT_CCEOIERROR, DELETE_CCEOIERROR — Write and clear interface error records for rejected rows.
• CALCULATE_ADJUSTMENT — Derives the quantity adjustment required when a counted quantity differs from system on-hand.
• SET_CCEXPORT, SET_CCEOIFLAGS — Manage status and export flags that control interface lifecycle states.
• CHECK_SERIAL_LOCATION — Verifies serial-number and location consistency for serialized items.
• DELETE_RESERVATION — Releases inventory reservations associated with count entries.
• RESET_GLOBAL_VARS — Reinitializes package-level global variables between processing runs.

Tables Accessed

The package reads and writes the open interface staging tables MTL_CC_ENTRIES_INTERFACE and MTL_CC_INTERFACE_ERRORS, using the sequence-backed surrogate keys MTL_CC_ENTRIES_INTERFACE_S1, MTL_CC_INTERFACE_ERRORS_S, and MTL_CYCLE_COUNT_ENTRIES_S. It reads configuration from MTL_CYCLE_COUNT_CLASSES, MTL_CYCLE_COUNT_HEADERS, MTL_CYCLE_COUNT_ITEMS, and MTL_CYCLE_COUNT_ENTRIES, and validates inventory context against MTL_PARAMETERS, MTL_SECONDARY_INVENTORIES, MTL_ITEM_LOCATIONS, MTL_LOT_NUMBERS, MTL_SYSTEM_ITEMS, MTL_SERIAL_NUMBERS, and MTL_MATERIAL_TRANSACTIONS_S. Supporting lookups include BOM_STANDARD_OPERATIONS and MRP_PROJECT_PARAMETERS. Dependencies on INV_CC_RESERVATIONS_PVT, INV_LOG_UTIL, INV_VALIDATE, INV_SERIAL_NUMBER_PUB, MTL_CC_TRANSACT_PKG, and MTL_CCEOI_VAR_PVT reflect the package's role in reservation handling, error logging, validation, and serialized-item processing.

Usage Notes

In 12.1.1 and 12.2.2, this package is invoked indirectly through the Cycle Count Open Interface concurrent program and through related count processing flows, not from a form field-level trigger. Custom code should not call MTL_CCEOI_PROCESS_PVT directly; Oracle's supported integration surface is the open interface tables, populated with validated header, item, and quantity data and submitted for processing. When rows fail, the calling program reports errors written to MTL_CC_INTERFACE_ERRORS, which users correct and resubmit. Review of this package is most relevant when diagnosing interface import failures, unwanted adjustment generation, serial or lot validation errors, and reservation behavior during count freeze and posting.