Search Results populate_res_grp

Overview

JTF_RS_DBI_8I_CONC_PUB is an internal Oracle E-Business Suite PL/SQL package owned by the APPS schema and declared with AUTHID CURRENT_USER. It provides the Sales Group Hierarchy API for non-DBI products and is used exclusively by Oracle Sales Intelligence. The package exists to make sales group hierarchy data available to the DBI (Daily Business Intelligence) product through Oracle 8i-compatible code paths, deliberately separated from the mainline ATG Resource Manager code base. Its central responsibility is to materialize flattened sales group hierarchy information into denormalized tables that back the view JTF_RS_DBI_RES_GRP_VL, which Sales Group Hierarchy reporting in DBI consumes.

The package header carries the version marker $Header: jtfrsdas.pls 115.2 2004/06/25, confirming its lineage as a long-standing internal component. Its scope is explicitly internal, meaning it is not part of the supported public API surface for customer extension, even though it resides in the APPS schema. The API classification is PUB per the ETRM 12.2.2 metadata, and no other packages reference it.

Key Procedures and Functions

• POPULATE_RES_GRP — The primary concurrent program entry point. It populates sales group hierarchy data by writing to the JTF_RS_DBI_MGR_GROUPS and JTF_RS_DBI_DENORM_RES_GROUPS tables so the hierarchy becomes accessible through the JTF_RS_DBI_RES_GRP_VL view. It follows the standard concurrent program signature pattern, exposing ERRBUF and RETCODE as OUT NOCOPY VARCHAR2 parameters for error messaging and completion status respectively. This is the procedure most commonly associated with the search term "populate_res_grp".
• GET_SG_ID — A function that returns a sales group identifier. Given a user identifier, it resolves and returns a group ID in which the logged-in user acts as manager or administrator, supporting security and context resolution for hierarchy queries.

Tables Accessed

The package reads and writes a focused set of resource-management tables. On the write side, JTF_RS_DBI_MGR_GROUPS and JTF_RS_DBI_MGR_GROUPS_S (its sequence/denormalized counterpart) and JTF_RS_DBI_DENORM_RES_GROUPS with JTF_RS_DBI_DENORM_RES_GROUPS_S form the denormalized hierarchy store that POPULATE_RES_GRP maintains. Source data is drawn from JTF_RS_GROUPS_B and JTF_RS_GROUPS_DENORM (group definitions), JTF_RS_REP_MANAGERS (reporting manager relationships used to derive hierarchy levels), and JTF_RS_RESOURCE_EXTNS (resource attributes). GET_SG_ID relies on these same group and manager tables to resolve a user's group context. Supporting metadata lookups include BIS_SYSTEM_DATE (effective dating for BIS/DBI processing), FND_APPLICATION, FND_ORACLE_USERID, and FND_PRODUCT_INSTALLATIONS (environment and product installation checks), while ALL_INDEXES is consulted for index metadata.

Usage Notes

JTF_RS_DBI_8I_CONC_PUB is invoked through the concurrent manager rather than directly from Oracle Forms. The POPULATE_RES_GRP procedure is registered as the "Populate Sales Group Hierarchy" concurrent program and is scheduled to refresh the denormalized DBI hierarchy tables on a recurring basis. Because the package is documented as exclusively built for the DBI product and excluded from the mainline ATG Resource Manager code, custom code should not call it directly. Implementations requiring sales group hierarchy data for DBI should rely on the concurrent program schedule and consume data through the JTF_RS_DBI_RES_GRP_VL view instead of querying the underlying denormalized tables or invoking package procedures directly. The 8i-compatible design indicates the code was written to run against older database versions and remains in place for backward compatibility within EBS 12.1.1 and 12.2.2 rather than reflecting current development practice.