Search Results fnd_oam_kbf_subs




Overview
Explore in AI Chat

Overview

FND_OAM_KBF_SUBS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Oracle Application Manager (OAM) framework, specifically the Knowledge Base Foundation (KBF) subsystem responsible for business exception subscriptions and notifications. The package is classified under ETRM as an OTHER API, indicating that it is an internal infrastructure component rather than a published integration API. Its primary business role is to generate and register subscription records that drive Oracle Alert-style business exception flows, enabling administrators to be notified when predefined conditions are detected within concurrent processing and application objects.

In Oracle EBS 12.1.1 and 12.2.2, the OAM component surfaces diagnostic and monitoring information through the Applications Dashboard and related administrative pages. FND_OAM_KBF_SUBS supplies the plumbing that creates the subscription list, the subject definition, and the associated business exception documents consumed by the notification engine. Its status is VALID, and it depends only on the SYS.STANDARD package, while no other APPS packages reference it, confirming its role as a leaf-level utility within the OAM code base.

Key Procedures and Functions

  • CREATESUBLIST — Builds the subscription list structure used by the business exception framework. It assembles the set of subscriptions that determine which recipients receive which exception notifications.
  • CREATESUBJECT — Creates the subscription subject, effectively defining the topic or event classification against which subscriptions are registered. This subject ties individual subscriptions to a specific monitored business condition.
  • CREATEBUSEXCEPDOC — Generates the business exception document, the payload that describes the exception condition and is delivered through the notification mechanism.
  • CREATEBUSEXCEPDOCPART1 — Produces the first part or section of the business exception document, supporting a modular construction approach where the document is assembled in stages.

The four documented procedures collectively cover the lifecycle of a business exception subscription: subject definition, subscription list assembly, and document generation. ETRM does not document parameter signatures, so parameter lists are intentionally not reproduced here.

Tables Accessed

The package reads from and writes to a mixture of concurrent processing, form registration, logging, and OAM notification tables through APPS synonyms:

Usage Notes

FND_OAM_KBF_SUBS is an internal, undocumented API intended for use by Oracle's own OAM and business exception framework rather than by customer extensions. It is typically invoked indirectly when administrators configure business exception subscriptions through the Oracle Application Manager or related administrative Dashboards, or when the underlying framework refreshes its submission and notification records.

Because ETRM classifies the package as OTHER and no other APPS packages reference it, direct invocation from custom code is discouraged. Sites that require exception notification behavior should configure it through the supported OAM user interface, allowing the framework to call CREATESUBLIST, CREATESUBJECT, and the CREATEBUSEXCEPDOC procedures on their behalf. This preserves upgrade safety across 12.1.1 and 12.2.2, where underlying table structures and OAM implementation details may differ.