Search Results aso_bi_qot_lin_main_c




Overview
Explore in AI Chat

Overview

The concurrent program ASO_BI_QOT_LIN_MAIN_C is an Oracle E-Business Suite executable that belongs to the ASO - Order Capture product family. It is exposed to end users under the user-facing name Incremental Collection of Quote Lines Transaction. As the name implies, the program is responsible for collecting quote line transactions and populating the associated fact data used by the Order Capture business intelligence and analytics layer.

The program is documented as enabled (Enabled: Yes), which indicates that it is available for submission in a standard EBS environment on both 12.1.1 and 12.2.2. Its purpose is to incrementally gather quote line activity so that downstream reporting, dashboards, and analytical structures reflect current quotation data without requiring a full rebuild of the underlying fact tables. The "incremental" designation is significant: rather than reprocessing the entire quote line population, the program is designed to identify and collect only those transactions that have changed or been created since the previous collection run.

Execution Details

The documented execution method for this concurrent program is PL/SQL Stored Procedure, with an Argument Method of Standard. The executable name is recorded as ASO_BI_QOT_LIN_MAIN_C, and the underlying execution filename is ASO_BI_POPULATE_FACTS.Populate_Lines_Fact. This indicates that the concurrent program effectively invokes the Populate_Lines_Fact procedure within the ASO_BI_POPULATE_FACTS package.

Because the execution method is a PL/SQL stored procedure rather than an external script or host program, the program runs entirely within the database tier. The Standard argument method means that any parameters defined for the program are passed using the conventional Oracle concurrent manager argument mechanism, and that the program does not rely on a token-based or custom argument scheme.

How to Run

Users and administrators typically submit this program through the standard Submit Request (SRS) window, navigating via Requests > Run or through the responsibility-specific concurrent program submission path. Because it is an ASO - Order Capture program, it is generally launched from a responsibility that includes Order Capture or related quoting functionality, or from a system administrator responsibility for diagnostic and scheduled execution.

Specific parameters are not enumerated in the documented metadata beyond the fact that a Standard argument method applies. In practice, collection programs of this type commonly accept parameters such as a date range or a set of organization or operating unit identifiers to scope the incremental extract. Administrators should consult the program's parameter list in the SRS form for the authoritative set of arguments before scheduling recurring runs. The program is well suited to being scheduled as a recurring concurrent request so that quote line fact data remains current.

Related Objects

  • ASO_BI_POPULATE_FACTS — the PL/SQL package containing the Populate_Lines_Fact procedure invoked by this executable.
  • Quote line base tables — the ASO quote and quote line transaction tables from which data is collected.
  • BI fact and staging tables — the target structures populated by the collection process for analytical reporting on quote lines.
  • Companion collection programs — other ASO_BI collection executables covering quote headers and related transaction entities, which are typically run alongside this program to maintain a consistent analytical data set.