Search Results populate_main




Overview
Explore in AI Chat

Overview

APPS.JTF_RS_DBI_CONC_PUB is a public PL/SQL package body that supports the Oracle Daily Business Intelligence (DBI) product within Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal purpose is to populate denormalized resource group data so that the Sales Group Hierarchy can be presented through the view JTF_RS_DBI_RES_GRP_VL. The package is explicitly built for the DBI product and is not part of the mainline code of the ATG Resource Manager, as noted in the source header comments. It originated in January 2003 and has been modified over several releases to address performance, compatibility, and functional requirements, including exclusion of manager and administrative roles, removal of costly peer group queries, and the introduction of helper functions for first-time login sales pages.

Key Procedures and Functions

The package exposes eight documented procedures and functions:

  • POPULATE_MAIN — The primary entry point that drives the concurrent population logic, coordinating inserts into the DBI manager group and denormalized resource group tables.
  • POPULATE_RES_GRP — Populates the resource group denormalization tables used by the Sales Group Hierarchy view.
  • POPULATE_FLD_SRV_DISTRICT — Populates field service district groupings for the DBI hierarchy.
  • GET_SG_ID — Retrieves the sales group identifier, originally added to support first-time login sales pages using the 'SALES' usage.
  • GET_SG_ID_ALL_LOGIN — Variant that returns sales group identifiers for all login contexts.
  • GET_FSG_ID — Returns the field service group identifier.
  • GET_FSG_ID_ALL_LOGIN — Variant returning field service group identifiers across all login contexts.
  • GET_FIRST_LOGIN_GROUP_ID — Fetches the group identifier associated with first-time login scenarios.

Tables Accessed

The package reads source group and membership data from JTF_RS_GROUPS_B, JTF_RS_GROUPS_DENORM, JTF_RS_GROUP_MEMBERS, JTF_RS_GROUP_USAGES, JTF_RS_REP_MANAGERS, JTF_RS_RESOURCE_EXTNS, and JTF_RS_ROLES_B. It writes populated results into JTF_RS_DBI_MGR_GROUPS and JTF_RS_DBI_DENORM_RES_GROUPS, along with their _S sequence-support tables. Environment and installation context are obtained from BIS_SYSTEM_DATE, FND_APPLICATION, FND_ORACLE_USERID, and FND_PRODUCT_INSTALLATIONS. These accesses support the denormalization required for performant DBI reporting, particularly through the Sales Group Hierarchy view.

Usage Notes

JTF_RS_DBI_CONC_PUB is designed to be invoked as a concurrent program within Oracle EBS. The package header comments indicate that setup, wrapup, and debug handling are managed through calls to BIS_COLLECTION_UTILITIES, allowing parallel session enablement by the setup program itself — a design directed by the performance team. The package is referenced by no other packages, so it is not a dependency of standard application code. Customizations should therefore invoke it directly through a concurrent program definition or by explicit call from custom PL/SQL. Its behavior has evolved across releases, notably excluding manager and admin roles from group membership and eliminating first-time login group member inserts, since that functionality was not used in product pages.