Search Results lead_rank_score




Overview
Explore in AI Chat

Overview

The concurrent program ASXSLRS is a Sales Foundation utility registered under the AS – Sales Foundation product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Its user-facing name is Update LEAD_RANK_SCORE, and its sole documented purpose is to update the LEAD_RANK_SCORE column on the AS_SALES_LEADS and AS_ACCESSES_ALL tables. These two tables are central to the Oracle Sales lead management data model: AS_SALES_LEADS stores sales lead header records, while AS_ACCESSES_ALL stores the assignment and access-control rows that determine which resources can view or work a given lead.

The program is enabled in the ETRM repository and is classified as a maintenance process rather than an interactive report. Because it performs a bulk update against high-volume lead tables, it exists primarily to service the lead ranking and scoring feature within Oracle Sales, where leads are prioritized for sales representatives based on ranking algorithms. The LEAD_RANK_SCORE value is the numeric score surfaced by those ranking routines.

Execution Details

Per the documented ETRM metadata, the concurrent program is configured as follows:

The executable short name ASXSLRS resolves to the PL/SQL package procedure AS_SALES_LEAD_RANKS_PVT.UPDATE_LEAD_RANK_SCORE. Because the execution method is a stored procedure rather than a report or a host script, the program does not produce a printed output file; its effect is transactional, committing score recalculations directly to the underlying lead tables. The Standard argument method indicates that no special token substitution or incremental-argument handling is used, and the program is invoked with its parameter list defined in the standard concurrent program framework.

How to Run

The ETRM documentation states explicitly that the program “should be run from lead rank API only.” This is a critical operational constraint. Although the program is enabled and can technically be submitted from the Standard Request Submission (SRS) window, Oracle’s documented guidance is that it be invoked indirectly by the lead ranking API rather than launched manually by an end user. Administrators should therefore treat ASXSLRS as a background service routine that the application calls when lead ranking is calculated or refreshed.

Where a manual or scheduled submission is required for troubleshooting or batch recalculation, the program is submitted through the standard SRS flow (Requests → Run) under the application Sales Foundation, using the user-facing name Update LEAD_RANK_SCORE. Because the Argument Method is Standard, parameters—if exposed in a given environment—are supplied directly as concurrent program arguments rather than through a report parameter form. Any run should be scoped to a maintenance window, since the process updates the full set of lead rank scores across AS_SALES_LEADS and AS_ACCESSES_ALL.

Related Objects

  • AS_SALES_LEADS – primary lead table whose LEAD_RANK_SCORE column is updated.
  • AS_ACCESSES_ALL – assignment/access table whose LEAD_RANK_SCORE column is also updated.
  • AS_SALES_LEAD_RANKS_PVT – the PL/SQL package containing UPDATE_LEAD_RANK_SCORE; also the entry point for the lead rank API.
  • Lead Rank API – the documented caller of this program; the supported invocation path.
  • Concurrent program ASXSLRS – the SRS registration referencing the procedure.

Supporting objects include the Oracle Sales lead and opportunity schema, assignment manager views, and the DBA/System Administrator concurrent manager queues used to schedule the request. No interface table or output report is associated with this program in the documented metadata.