Results for “iex_debug”
10 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.IEX_ATA_PUB is a public PL/SQL package body in Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2 that implements the Assign Territory Accesses business function for Oracle Advanced Collections (IEX). The package orchestrates the bulk assignment of territory access rights across customer accounts, allowing organizations to systematically grant and refresh collector access to accounts based on their territory definitions. This functionality is central to Advanced Collections territory management and is exposed through the concurrent program Assign Territory Accesses, which invokes the package's principal public entry point, ASSIGN_TERRITORY_ACCESSES.
The package includes internal machinery for multi-level territory strategies (a capability introduced for multi-level territory assignment), parallel processing of large account populations, and diagnostic tracing. Because territory reassignments can span hundreds of thousands of accounts, the package is designed to operate in a set-based, concurrent, and restartable manner, using request IDs and worker partitioning to scale across parallel workers.
Key Procedures and Functions
- ASSIGN_TERRITORY_ACCESSES — The primary public routine. It is the concurrent program entry point that drives territory access assignment for a given operating unit (
P_ORG_ID). It accepts the standard concurrent requestERRBUFandRETCODEoutput parameters, carries a strategy-level input (P_STR_LEVEL) supporting multi-level territory strategies, and manages territory access list processing. Internally it coordinates setup, parallel worker preparation, and account qualification logic. Parameter lists shown in the documentation excerpt reflect internal variables and should not be relied upon as public call signatures. - IEX_DEBUG — A diagnostic utility routine. Consistent with other IEX packages, it serves as the standard debug hook for the Advanced Collections modules, enabling developers to emit tracing and diagnostic messages during territory access assignment execution. It is the routine users surface when searching for iex_debug within this package.
- SET_AREA_SIZES — A supporting routine used to configure or adjust size parameters for the internal qualifying areas/structures referenced during territory assignment, supporting scalability of the processing.
Additional internal routines visible in the source excerpt include Set_Up, Concurrent_Profile_Options, and Prepare_Parallel_Processing, the last of which computes and returns the number of account workers actually used (X_ActualAccountWorkersUsed).
Tables Accessed
- JTF_TAE_1600_CUST_TRANS and JTF_TAE_1600_CUST_WINNERS — the core transaction and winner tables used to stage and resolve customer territory attributions during the assignment run.
- FND_CONCURRENT_REQUESTS_S — accessed to manage request IDs and support parallel/restartable concurrent processing across workers.
- V$PARAMETER — read to inspect database parameter settings relevant to tuning the assignment run.
- DUAL and PLITBLM — utility objects used for simple selections and PL/SQL table index manipulation.
Usage Notes
IEX_ATA_PUB is typically invoked in three ways: (1) through the Advanced Collections Assign Territory Accesses concurrent program, which is the standard supported execution path; (2) from forms that refresh territory access for accounts; and (3) from custom PL/SQL code that calls the public entry point ASSIGN_TERRITORY_ACCESSES directly. When invoking directly, callers must respect the concurrent request contract, submitting the program rather than calling the procedure inline for large account populations. The package is referenced by one other package, indicating integration with further Advanced Collections components. Administrators should run assignments in a scheduled, off-peak window given the volume of accounts involved, and monitor the concurrent request log for diagnostic output generated through IEX_DEBUG.
-
PACKAGE: APPS.IEX_ATA_PUB 12.1.1
-
PACKAGE: APPS.IEX_ATA_PUB 12.2.2