Search Results fnd_oam_doc_category_pkg

Overview

FND_OAM_DOC_CATEGORY_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Application Manager (OAM) family of utilities, the framework responsible for the Applications Dashboard, system monitoring, and diagnostic infrastructure within EBS. The package encapsulates maintenance logic for document category definitions used by the OAM documentation and help subsystem, providing a controlled API for populating and maintaining the FND_OAM_DOC_CATEGORY table. Because the package is validated and present in both 12.1.1 and 12.2.2, it can be treated as a stable, internally consumed component that supports the categorization of documentation assets surfaced through OAM user interfaces.

Key Procedures and Functions

The ETRM metadata documents three procedures exposed by this package. Consistent with the naming conventions of EBS seed-data and setup-data loaders, these routines are oriented toward row-level maintenance of the underlying category table rather than toward complex business processing.

• INSERT_ROW — Creates a new document category record in the underlying table. It is the entry point used when a category must be introduced into the OAM documentation repository.
• UPDATE_ROW — Modifies the attributes of an existing document category row. It allows category definitions to be renamed, re-described, or otherwise adjusted without direct DML against the base table.
• LOAD_ROW — Provides an idempotent load operation that inserts the category when it is absent and updates it when it already exists. This is the pattern typically used by seed-data and patching routines to guarantee a consistent end state across environments.

No parameter lists are documented in the ETRM metadata, so signatures should be confirmed against the deployed package specification in the target instance before invoking these procedures from custom code.

Tables Accessed

The package references a single documented table through the APPS synonym layer:

• FND_OAM_DOC_CATEGORY — the repository of document category definitions used by the OAM documentation framework. INSERT_ROW writes new rows to this table, UPDATE_ROW modifies existing rows, and LOAD_ROW performs a conditional insert-or-update against it.

The ETRM dependency listing also shows references to SYS.STANDARD, which reflects only standard PL/SQL language constructs rather than any additional application table access. No other application tables are documented as being referenced by this package.

Usage Notes

FND_OAM_DOC_CATEGORY_PKG is an internal Oracle-supplied package rather than a published integration API. Its routines are most commonly invoked from Oracle's own setup and patch infrastructure — seed data loaders, upgrade drivers, and AD utilities that must ensure the OAM document category table contains the categories expected by the running release. The LOAD_ROW pattern in particular is characteristic of utilities that are re-runnable by design and are executed repeatedly as part of patching or cloning.

Because the package is referenced by no other documented packages, it should be viewed as a leaf-level maintenance utility. Custom development should avoid becoming dependent on it; organizations that require controlled management of OAM document categories are better served by the standard Oracle-provided loading mechanisms or by carefully validated direct maintenance of FND_OAM_DOC_CATEGORY. As with all APPS-owned code, modifications should never be made to the package itself, since any custom change would be overwritten during patching and would place the instance outside of supported configuration.