Results for “update_resources”

30 results




Overview
Explore in AI Chat

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

Overview

IEX_COLLECTORS_TO_RESOURCE is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM as an OTHER API. Its header comment ($Header: iexctrab.pls 120.6 2006/07/18 21:19:47 acaraujo noship $) identifies it as a relatively long-lived script tied to the Collections (IEX) module lineage, with the last substantive baseline edit dated July 2006 — consistent with code that is stable and rarely revised across the 12.1.1 and 12.2.2 releases. The package addresses a specific integration concern in Oracle Advanced Collections: synchronizing Collector records (the accounts-receivable agents stored in AR_COLLECTORS) with the generic resource model held in the JTF Resource Manager tables. In other words, it bridges the Collections-specific concept of a "collector" to the application-wide concept of a "resource," allowing collectors to be resolved by the same resource infrastructure used by telephony, territory, and interaction components.

The body exposes three documented program units and several private worker procedures, including MERGE_COLLECTORS, which is invoked internally as the first substantive step of UPDATE_COLLECTORS. The header comment block explicitly attributes UPDATE_COLLECTORS as the main entry point, describing its primary parameter P_debug, which enables or disables log messages. Diagnostic output is written through FND_FILE, and when debug is active, the code enables SQL trace via DBMS_SESSION.SET_SQL_TRACE, then records the start timestamp and the values of up to five responsibility parameters — confirming that the process is designed to be scoped by responsibility.

Key Procedures and Functions

  • UPDATE_COLLECTORS — The public driver procedure. It accepts the concurrent-program error buffer and return code (ERRBUF, RETCODE), up to five responsibility identifiers (P_RESP1 through P_RESP5), and the P_debug flag. It enables SQL trace when debug is requested, logs each supplied parameter, calls MERGE_COLLECTORS, then conditionally calls UPDATE_COLLECTORS_PVT once for each non-null responsibility parameter. It returns standard EBS concurrent request status through RETCODE.
  • UPDATE_COLLECTORS_PVT — The responsibility-scoped work engine, invoked by UPDATE_COLLECTORS for each responsibility supplied. It performs the actual collector-to-resource update logic for a single responsibility, keeping the public driver thin and allowing the process to be repeated across several organizational units within one execution.
  • UPDATE_RESOURCES — The resource-side synchronization routine that maintains the JTF resource records corresponding to collectors, ensuring resource definitions remain consistent after the collector data is refreshed.

MERGE_COLLECTORS is declared and called internally (its comment notes a correction of 14-Jul-2005 that changed it to a function form and added a missing COMMIT when no responsibility was selected), but it is not part of the documented public surface.

Tables Accessed

  • AR_COLLECTORS / AR_COLLECTORS_S — The base and translation tables holding collector definitions; these are the primary source and update target.
  • JTF_RS_RESOURCE_EXTNS, JTF_RS_ROLES_B, JTF_RS_ROLE_RELATIONS — The Resource Manager structures into which collector identities are reflected as resources, role definitions, and role relationships.
  • PER_ALL_PEOPLE_F — Resolves the underlying HR person record associated with a collector or resource.
  • FND_USER, FND_RESPONSIBILITY, FND_FORM_FUNCTIONS, FND_COMPILED_MENU_FUNCTIONS — Used to validate and resolve the responsibility parameters and their associated application function security context.
  • HZ_PARTIES — Supplies the trading-community party identity linked to a collector or resource.
  • DBMS_SESSION, DUAL, PLITBLM — Utility references for trace enablement, timestamp retrieval, and internal PL/SQL table handling.

Usage Notes

The procedure signature (ERRBUF, RETCODE, P_RESP1–P_RESP5, P_debug) is the canonical shape of an Oracle EBS concurrent program entry point, so UPDATE_COLLECTORS is registered as a concurrent executable and submitted from the Collections responsibility — typically as an administrative or setup task after collector or resource data changes. The five responsibility parameters indicate the concurrent program definition exposes responsibility selection, letting administrators synchronize a bounded set of organizations rather than the entire collector population. Because MERGE_COLLECTORS issues its own COMMIT, the program commits incrementally; failures mid-run can therefore leave partial synchronization, and reruns should be planned accordingly. The package is referenced by no other documented package, making it a terminal integration point rather than a shared library. Supported in 12.1.1 and 12.2.2, its behavior and structure are unchanged between those releases aside from standard EBS technical-stack compatibility. When diagnostics are required, running with P_debug = 'Y' writes to the concurrent request log and produces a SQL trace.