Search Results no_unnest




Overview
Explore in AI Chat

Overview

CSI_ASSIGN_ROLE_PUB is a public PL/SQL package body in the APPS schema that supports Oracle EBS role assignment for users associated with the CSI (Customer Support Intelligence / Service) product family. Its core purpose is to automate the assignment of CSI-specific roles — namely CSI_END_USER and CSI_NORMAL_USER — to eligible application users by inspecting their responsibility grants and their enrollment in the JTF authentication principal hierarchy. This package forms part of the infrastructure that keeps Oracle's support and service self-service users properly provisioned with the correct CSI role, which governs downstream access to CSI functionality. The body carries a header revision string ($Header: csipuplb.pls 120.1 2006/01/11 14:17 epajaril noship $) indicating it is a controlled, versioned source module managed through the standard EBS source control process.

Key Procedures and Functions

The package exposes a single documented procedure, ROLE_ASSIGNMENT. Its distinguishing feature is the standard concurrent-program error handling interface, returning an error buffer (x_errbuf) and a return code (x_retcode). Internally, ROLE_ASSIGNMENT performs the following work: it first checks the csi_install_parameters table for a freeze flag; if the flag evaluates to 'Y', the procedure simply returns without processing. When the flag is not set to freeze, the procedure iterates over a cursor whose purpose is to identify candidate users and classify each as either CSI_END_USER or CSI_NORMAL_USER, then invokes jtf_auth_bulkload_pkg.assign_role to grant the appropriate role. The procedure therefore acts as a role-provisioning driver rather than a general-purpose API.

Tables Accessed

  • CSI_INSTALL_PARAMETERS — read to obtain the freeze flag; controls whether role assignment should be suppressed.
  • FND_USER — the source of application user records; only users whose end date is null or in the future are considered.
  • FND_USER_RESP_GROUPS — used to detect active responsibility assignments for each user.
  • FND_RESPONSIBILITY — joined to determine whether a user holds the ORACLE_SUPPORT responsibility, which distinguishes end users from normal users.
  • JTF_AUTH_PRINCIPALS_B and JTF_AUTH_PRINCIPAL_MAPS — the JTF authentication principal model is queried to verify that the user belongs to an IBU% parent principal and does not already belong to a CSI% principal.

Usage Notes

ROLE_ASSIGNMENT is designed to be invoked as a concurrent program, as evidenced by the x_errbuf and x_retcode OUT parameters and the absence of interactive prompting. It is typically scheduled or run manually by administrators when CSI role provisioning must be aligned with current user and responsibility data. The freeze-flag safeguard allows administrators to temporarily suspend role assignment during controlled maintenance windows. No other packages in the ETRM metadata reference this package, indicating it is a top-level entry point rather than a shared utility. Custom code should call it only through the concurrent program interface; direct invocation outside that framework bypasses the intended ERR-buffer reporting contract.