Search Results csi_ctr_interface_pub




Overview
Explore in AI Chat

Overview

CSI_CTR_INTERFACE_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Enterprise Asset Management (eAM) and Enterprise Asset Management / Installed Base product family, specifically the Counter (CSI_CTR) module that tracks cumulative and non-cumulative counter readings for assets, equipment, and meters. The package serves as the public application programming interface through which external data — meter readings captured by field devices, third-party systems, or batch processes — is loaded into the Oracle counter-reading interface tables and subsequently processed into the production counter tables. Its primary business function is to provide a controlled, validated entry point for the counter open interface, allowing customers to import counter and counter-property readings in bulk without directly manipulating the interface tables or invoking a concurrent program manually. Because it is classified as a PUB (public) API, it is intended for supported external invocation and shields callers from underlying table and processing changes across patch levels.

Key Procedures and Functions

The documented metadata exposes a single public entry point:

  • EXECUTE_OPEN_INTERFACE — This procedure drives the counter open interface processing cycle. When invoked, it submits or performs the validation and transfer of rows staged in the counter interface tables into the corresponding base counter tables. It is the orchestrating call that a custom loader or concurrent program uses once counter interface records have been populated, ensuring that the standard validation logic, error handling, and table migration are executed consistently with Oracle's delivered processing rules.

No other public procedures or functions are documented in the ETRM metadata for this package, indicating that EXECUTE_OPEN_INTERFACE constitutes the entire supported external surface of CSI_CTR_INTERFACE_PUB.

Tables Accessed

The package operates across the following documented tables, referenced through APPS synonyms:

  • CSI_CTR_READINGS_INTERFACE — The primary staging table for incoming counter readings. Rows are inserted here by external loaders prior to interface execution.
  • CSI_CTR_READ_PROP_INTERFACE — The interface table holding counter property reading attributes associated with staged readings.
  • CSI_COUNTER_READINGS — The production table that receives validated counter readings from the interface.
  • CSI_CTR_PROPERTY_READINGS — The production table receiving validated counter property values.
  • CSI_COUNTER_PROPERTIES_B — The base table of counter property definitions, consulted to validate that incoming property readings reference valid properties.
  • PLITBLM — The Oracle Applications standard PL/SQL character table type used internally, typically for passing arrays of identifiers or names during processing.

Usage Notes

CSI_CTR_INTERFACE_PUB is normally invoked after an external process has populated the CSI interface tables with counter reading data. Typical callers include concurrent programs and custom PL/SQL loaders that stage meter or counter data from external measurement systems, ETL routines, or legacy systems. The package is not documented as being referenced by any other APPS packages, so its use is deliberately external rather than internal to the eAM call stack. Developers integrating counter data should insert records into CSI_CTR_READINGS_INTERFACE and CSI_CTR_READ_PROP_INTERFACE, then call EXECUTE_OPEN_INTERFACE to trigger the standard validation and transfer to the production counter tables. Because package interfaces in EBS can change between releases, custom code should rely only on the documented public procedure and avoid direct dependencies on internal implementation. As with all public APIs, the procedure should be tested in a non-production environment before being scheduled or embedded in automated load processes.