Search Results jtf_rs_dbi_mgr_groups_s

Overview

APPS.JTF_RS_DBI_8I_CONC_PUB is a public PL/SQL package body in the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment that supports the resource management and CRM reporting infrastructure. It belongs to the JTF (Java Technology Foundation) resource scheduling module and is specifically associated with the DBI (Database Inventory) layer of the Resource Manager. Its principal business purpose is to populate and maintain denormalized resource group data used by resource reporting and analytics, particularly for the 8i-based concurrent processing path. The package is classified as a public API (API classification: PUB), meaning it is intended to be invoked from external callers such as concurrent programs or custom code rather than being restricted as an internal helper. Because it is a package body owned by APPS and marked VALID, it forms part of the deployed, supported code base of the customer's EBS instance.

Key Procedures and Functions

The ETRM documentation records two procedures/functions within JTF_RS_DBI_8I_CONC_PUB. No parameter lists are documented; the descriptions below are limited to their documented purpose.

• POPULATE_RES_GRP — This procedure is the primary driver of the package's business function. Its role is to populate resource group data within the denormalized reporting tables, enabling efficient querying of resource-to-group relationships for CRM resource analytics and related concurrent reporting processes. It likely orchestrates the retrieval and insertion of resource group information into the target denormalized structures.
• GET_SG_ID — A function that retrieves a surrogate/source group identifier (SG ID) used to link resource group records across the denormalized tables. It supports the population logic by resolving or generating the key value required to associate resource group rows consistently.

Tables Accessed

The package references several tables, all accessed through APPS synonyms. The primary denormalized target and source tables include JTF_RS_DBI_DENORM_RES_GROUPS, JTF_RS_DBI_DENORM_RES_GROUPS_S, JTF_RS_DBI_MGR_GROUPS, and JTF_RS_DBI_MGR_GROUPS_S. These store flattened resource group and manager group data that the package maintains. The base entity tables JTF_RS_GROUPS_B, JTF_RS_GROUPS_DENORM, JTF_RS_REP_MANAGERS, and JTF_RS_RESOURCE_EXTNS provide the source resource, group, and reporting manager information that is transformed and loaded. Utility and framework tables include BIS_SYSTEM_DATE and BIS_COMMON_PARAMETERS (for date and parameter context), FND_APPLICATION, FND_ORACLE_USERID, and FND_PRODUCT_INSTALLATIONS (for application and environment metadata), along with ALL_INDEXES for index-related processing. The relevant sequence JTF_RS_DBI_MGR_GROUPS_S (referenced at the top-level dependency list) is also used. BIS_COLLECTION_UTILITIES, BIS_COMMON_PARAMETERS, and BIS_SYSTEM_DATE are invoked to support the collection and transformation workflow.

Usage Notes

JTF_RS_DBI_8I_CONC_PUB is typically invoked in the context of concurrent processing — the "CONC" in its name indicates it is designed to run as or from a concurrent program that refreshes resource group denormalization data. It may be scheduled periodically or triggered on demand to keep the denormalized resource group reporting tables synchronized with their base source tables. Although no other database objects are documented as referencing this package (it is referenced by 0 other packages), it is classified as a public API, so custom extensions, concurrent program definitions, or database triggers may invoke POPULATE_RES_GRP and GET_SG_ID directly. Administrators should ensure that the underlying JTF_RS_DBI_* tables and sequences are valid and that the concurrent request has appropriate privileges (FND_GLOBAL user context) before execution, as the package relies on FND_GLOBAL and FND_MESSAGE for session and error handling.