Search Results bim_lead_conv_summ_pkg




Overview
Explore in AI Chat

Overview

BIM_LEAD_CONV_SUMM_PKG is a concurrent program registered within the Oracle E-Business Suite environment under the BIM – Marketing Intelligence product family. In the ETRM 12.2.2 documentation and the corresponding 12.1.1 reference set, this module is explicitly flagged as (Obsolete), meaning it is retained only for historical and upgrade purposes and is no longer part of the supported functional footprint. The program's function is to execute the PL/SQL package of the same name, which populates a lead conversion summary collection — that is, it aggregates marketing lead data into a summary structure consumed by Marketing Intelligence reporting and analytics.

The user-facing name presented in the Concurrent Programs form is BIM_LEAD_CONV_SUMM_PKG, and the descriptive text recorded in the metadata is “BIM_LEAD_CONV_SUMM_PKG Concurrent Program.” The program is documented as Enabled: No, confirming that it is disabled by default and will not appear as an executable option for request submission unless an administrator explicitly re-enables it.

Execution Details

The documented execution attributes are as follows:

  • Execution Method: PL/SQL Stored Procedure
  • Executable: BIM_LEAD_CONV_SUMM_PKG
  • Execution Filename: BIM_LEAD_CONV_SUMM_PKG.Populate
  • Argument Method: Standard
  • Subroutine Name: Not populated in the metadata

Because the execution method is PL/SQL Stored Procedure, the concurrent manager invokes the package directly within the database session rather than launching an external executable or Java class. The execution filename BIM_LEAD_CONV_SUMM_PKG.Populate identifies the specific procedure entry point that the manager calls. The Standard argument method indicates that arguments are passed positionally in the order defined by the concurrent program definition.

How to Run

Under normal circumstances the program would be submitted through the Standard Request Submission (SRS) window, Submit Requests, after navigating to the appropriate Marketing Intelligence responsibility. Reports and Programs is used to locate the program by its user-facing name and open the Parameters window.

The documented parameters are exposed through descriptive flexfield segments rather than conventional token parameters. The three defined segments are:

  • ATTRIBUTE1 — period year ($SRS$.BIM_LEAD_CONV_SUMM_PKG)
  • ATTRIBUTE2 — start period ($SRS$.BIM_LEAD_CONV_SUMM_PKG)
  • ATTRIBUTE3 — end period ($SRS$.BIM_LEAD_CONV_SUMM_PKG)

Each segment is documented with Display, Insert, and Update set to Yes, and no default type or default value is recorded, so the submitter must supply the period year and start/end period explicitly. Because the program is disabled, submission guidance is largely moot in a current 12.2.2 environment; it applies principally to legacy 12.1.1 instances that have not yet purged obsolete Marketing Intelligence objects.

Related Objects

The program belongs to the same obsolete Marketing Intelligence family as other BIM lead and opportunity collection programs. Related objects typically include the Marketing Intelligence interface and staging tables that the Populate procedure writes into, the Marketing Intelligence collection programs that invoke similar aggregation routines, and the BI Publisher or Oracle Reports summaries that consume the resulting summary rows. Administrators assessing this package should review the concurrent program definition, the executable registration, and any dependent request sets to determine whether the object can be safely removed or must remain dormant for upgrade compatibility.