Search Results get_property_canonical_value

Overview

The APPS.FND_OAM_DSCFG_PROPERTIES_PKG package body is a table handler within the Oracle E-Business Suite Application Object Library (FND) diagnostic framework. Its purpose is to manage the individual configuration properties that are associated with diagnostic configuration instances. Each configuration instance is identified by a parent type and parent identifier, and the properties attached to it represent named, datatyped parameters with a canonical (normalized) value representation. In Oracle EBS 12.1.1 and 12.2.2, this package is classified as an "OTHER" API of package body scope, meaning it is a supporting internal utility rather than a formal public API. The source header identifies the file as AFOAMDSCPROPB.pls, version 120.2, dated 2005, and explicitly describes the body as "stateless, only contains a table handler to insert new properties," establishing that its core responsibility is persisting and retrieving configuration property records.

Key Procedures and Functions

The documented package exposes seventeen procedures and functions. Central to its function are the property maintenance routines:

• ADD_PROPERTY — Inserts a new property row, obtaining a surrogate key from the sequence and returning the generated property identifier to the caller. It enforces a prerequisite that a configuration instance be initialized, raising NO_DATA_FOUND when the security harness check fails.
• ADD_PROPERTY_ROWID and ADD_PROPERTY_RAW — Variant insertion routines supporting row identifier and raw data handling for property persistence.
• GET_PROPERTY_CANONICAL_VALUE and GET_PROPERTY_VALUE — Retrieval accessors that return the stored canonical representation and the interpreted property value respectively.
• SET_OR_ADD_PROPERTY — A convenience routine that updates an existing property or inserts it when absent.
• DELETE_PROPERTY — The single-property deletion routine matching the user's search term.
• DELETE_PROPERTIES — The bulk deletion routine for removing multiple or all properties associated with a parent configuration.

The remaining documented procedures complement these handlers, supporting the full lifecycle of configuration property management within the diagnostic instance framework.

Tables Accessed

The package operates against two documented database objects accessed through APPS synonyms. FND_OAM_DSCFG_PROPERTIES is the primary configuration property table and the direct target of inserts, updates, queries, and deletes. Columns populated during insertion include PROPERTY_ID, PARENT_TYPE, PARENT_ID, PROPERTY_NAME, DATATYPE, CANONICAL_VALUE, and the standard WHO audit columns sourced from FND_GLOBAL.USER_ID. FND_OAM_DSCFG_PROPERTIES_S is the associated sequence used to generate unique property identifiers. The package additionally depends on FND_OAM_DSCFG_INSTANCES_PKG for instance-initialization validation and FND_OAM_DEBUG for entry, exit, and exception logging.

Usage Notes

FND_OAM_DSCFG_PROPERTIES_PKG is referenced by two other packages within the diagnostic configuration subsystem and is typically invoked indirectly through the higher-level instance management layer rather than by end users. It is not a documented public API for customer extension. Logging conventions demonstrate a consistent debug pattern: level 2 messages for routine entry and exit, and level 6 for unexpected errors carrying SQLCODE and SQLERRM. The instance-initialization precondition means any custom code invoking ADD_PROPERTY must ensure a configuration instance has been established first through FND_OAM_DSCFG_INSTANCES_PKG, otherwise a NO_DATA_FOUND exception is raised deliberately as a security harness check.