Search Results bim_geo_pkg




Overview
Explore in AI Chat

Overview

BIM_GEO_PKG is a concurrent program registered within the Oracle E-Business Suite under the BIM – Marketing Intelligence product family. This module is identified in the ETRM documentation as obsolete, meaning it is no longer an active or supported component in current EBS implementations. The program carries the user-facing name BIM_GEO_PKG and is classified as a collection program, which indicates its intended role was to gather, stage, or aggregate geography-related marketing data within the Marketing Intelligence data model. The documented description identifies it simply as the "BIM_GEO_PKG Concurrent Program," and the associated executable is described as the "Executable for BIM_GEO_PKG collection program." In the documented metadata for ETRM 12.2.2, the program is explicitly marked as disabled (Enabled: No), confirming that it should not be submitted in a standard production environment.

Execution Details

The concurrent program is documented with the following execution attributes:

  • Execution Method: PL/SQL Stored Procedure
  • Argument Method: Standard
  • Executable: BIM_GEO_PKG
  • Execution Filename: BIM_GEO_PKG.Populate
  • Subroutine Name: (not specified in the metadata)

Because the execution method is a PL/SQL Stored Procedure, the program invokes the Populate procedure within the BIM_GEO_PKG package at run time. The Standard argument method means that parameter values are passed positionally in the order defined by the concurrent program definition, rather than through a token-based or descriptive flexfield substitution mechanism. The metadata lists no explicit subroutine override, so the packaged procedure identified by the execution filename governs program behavior.

How to Run

As with other Oracle EBS concurrent programs, submission would normally occur through the Submit Requests (SRS) form or an equivalent scheduling interface. The documented request set arguments describe three parameters, all sharing the seed name $SRS$.BIM_GEO_PKG and all marked with Display, Insert, and Update enabled:

  • ATTRIBUTE1 — default type YCPERIODYEAR (period year)
  • ATTRIBUTE2 — default type YCSTARTPERIOD (start period)
  • ATTRIBUTE3 — default type YCENDPERIOD (end period)

These parameters indicate that the program was designed to process geography data for a specified accounting period range, bounded by a start period, an end period, and a period year. Users selecting the program would supply or accept these values before submitting the request. It should be noted that, because the program is disabled in the documented ETRM metadata, it is neither expected nor recommended to be available for submission in a functioning environment. Its presence in the concurrent program repository is historical.

Related Objects

The program belongs to the Marketing Intelligence data collection layer, which typically interfaces with staging tables and packaged APIs that support geography and customer segmentation data. Related artifacts would generally include the BIM_GEO_PKG package specification and body, the collection and staging tables referenced by the Populate procedure, and any request sets or request groups that once contained this program. Because BIM – Marketing Intelligence is documented as obsolete, supporting interfaces, reports, and validation routines associated with this program are likewise legacy. Implementations upgrading to EBS 12.1.1 or 12.2.2 should treat BIM_GEO_PKG as a deprecated object and review any dependencies before removal during a cleanup or migration exercise.