Results for “bix_agent_class_p”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

BIX_AGENT_CLASS_P is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the Oracle Business Intelligence (BIX) family of database objects that support the EBS embedded analytics and reporting infrastructure, specifically the components that feed agent-based, event-driven reporting. The package is classified as OTHER within the documented API taxonomy, meaning it is not a formally published public interface but rather an internal processing unit invoked by the reporting framework itself.

The operational role of BIX_AGENT_CLASS_P is to consolidate agent call activity data into the BIX data mart so that classification-aware agent reporting can be produced. The name and its documented dependency on CCT_CLASSIFICATIONS indicate that the package associates inbound or outbound agent call records with classification codes, thereby enabling reports that categorize agent interactions by business classification. Its single documented entry point, POPULATE, carries out the extraction, transformation, and load logic required to keep the relevant data mart tables current.

Key Procedures and Functions

The package exposes one documented procedure:

• POPULATE — The worker routine that loads or refreshes agent classification reporting data. It reads source activity and classification records, applies the mapping logic that ties agent activity to classification values, and writes the summarized results into the BIX data mart tables. It is the only entry point referenced by the reporting framework and is intended to be executed as a batch operation rather than interactively.

No parameter lists are documented in the ETRM metadata, so callers should not assume a public signature. The procedure is invoked internally by the BIX reporting layer.

Tables Accessed

The package references the following tables through APPS synonyms:

• BIX_DM_AGENT_CALL_SUM — The agent call summary table in the BIX data mart. This is the primary target of the POPULATE procedure, holding aggregated call metrics by agent.
• BIX_DM_REPORT — The data mart report definition table, used to register or resolve the report context under which the agent classification data is presented.
• CCT_CLASSIFICATIONS — The classification reference table. POPULATE reads this to obtain the classification codes and descriptions that determine how agent activity is categorized in the output.
• JTF_RS_GROUP_MEMBERS — The resource group membership table from the CRM resource manager. It supplies the agent-to-group relationships used to scope or filter the population of summary rows.
• DUAL — Used for scalar evaluations and single-row expressions within the procedural logic.

Usage Notes

BIX_AGENT_CLASS_P is an internal framework package. The ETRM metadata records that it is referenced by zero other packages, confirming that no supported PL/SQL API depends on it and that it is not a candidate for direct invocation from custom code. In practice, it is called by the BIX reporting and data mart refresh mechanisms, most likely from a concurrent program or a scheduled reporting job that rebuilds agent classification summaries on a periodic basis.

Because the API classification is OTHER and no parameter list is published, the package should be treated as closed to extension and customization. It is safe to read the results it produces in BIX_DM_AGENT_CALL_SUM, but modifications to the package body, or direct calls from forms or custom concurrent programs, are not supported and are vulnerable to being overwritten by patching or upgrade in 12.1.1 and 12.2.2. Administrators diagnosing agent classification reporting gaps should examine the scheduling and completion status of the concurrent job that triggers POPULATE rather than attempt to call the procedure manually.