Search Results isc_book_sum2_f




Overview
Explore in AI Chat

Overview

ISC_BOOK_SUM2_F is a concurrent program that belongs to the Supply Chain Intelligence (ISC) product family within Oracle E-Business Suite. The program's documented user-facing name is Update Order Management Base Summary, and its functional description is Update Bookings Summary 2 Fact. As the naming suggests, the program is responsible for populating and refreshing a bookings summary fact object within the Supply Chain Intelligence dimensional model, consolidating order management booking data into an aggregated form suitable for analytics and reporting.

It is important to note that ISC — Supply Chain Intelligence — is flagged as obsolete in the ETRM metadata for both 12.1.1 and 12.2.2. Supply Chain Intelligence was an early-generation embedded analytics and data warehousing offering that was eventually superseded by Oracle Business Intelligence (OBIEE) based Supply Chain and Order Management analytics. The concurrent program nevertheless remains registered with Enabled: Yes, which means the executable definition is still present and submittable in the concurrent manager even though the surrounding product line is no longer actively supported.

Execution Details

The program is executed as a PL/SQL Stored Procedure using the standard execution method. The documented executable name is ISC_BOOK_SUM2_F, and the execution file is ISC_DBI_BOOK_SUM2_F_C.update_fact. This identifies the packaged procedure update_fact inside the PL/SQL package ISC_DBI_BOOK_SUM2_F_C as the actual entry point invoked by the concurrent manager.

The argument method is Standard, which means parameters, if any, are passed positionally in the conventional Oracle concurrent program manner rather than through a token-based or descriptive-flexfield argument scheme. Because the program is a fact-update collection routine rather than an interactive report, its execution is largely deterministic: it reads from the upstream staging and summary sources, computes the aggregated bookings measures, and writes the results into the summary 2 fact structure.

How to Run

Users submit ISC_BOOK_SUM2_F through the standard Submit Requests (SRS) window, selecting Update Order Management Base Summary from the list of available concurrent programs, or by name under the ISC application responsibility. Because the program is a data refresh routine, it is typically scheduled rather than run ad hoc, either as part of a nightly batch chain or as a dependent request following the staging loads that feed the bookings summary.

Where parameters are exposed, they generally scope the collection — for example, by operating unit, organization, or date range — so that the fact refresh can be limited to the incremental change set. Administrators should confirm the parameter list on the concurrent program definition in the target instance before scheduling, since obsolete ISC objects sometimes retain placeholder parameters that no longer influence behavior.

Related Objects

As a member of the Supply Chain Intelligence bookings collection, ISC_BOOK_SUM2_F is commonly chained with the staging and summary programs that populate its source tables, and with sibling fact-update programs covering other booking or order summary objects. It writes to the ISC DBI summary fact structures accessed by the corresponding ISC bookings dashboards and reports.

Because ISC is marked obsolete, organizations on 12.1.1 or 12.2.2 should treat this program as a legacy object. Any maintenance or troubleshooting effort should first establish whether the program is still referenced by an active batch schedule; if not, it can be disabled to reduce concurrent manager overhead without functional impact.