Search Results isc_dbi_book_sum2_f_c




Overview
Explore in AI Chat

Overview

ISC_DBI_BOOK_SUM2_F_C is an APPS-owned PL/SQL package that forms part of the Oracle E-Business Suite Demand Planning and Order Promising infrastructure, specifically the data-collection and fact-loading layer used by the Integrated Supply Chain (ISC) DBI (Demand/Business Intelligence) schema. The package name associates it with the ISC_BOOK_SUM2_F family of tables — summarized "booking" facts drawn from the sales-order and service-order streams. Its role is to materialize and refresh aggregated fact data that feeds Oracle Demand Planning and related Supply Chain Intelligence dashboards.

The package is classified as OTHER, meaning it is not a published open API; it is an internal implementation object that the application calls during data collection. The ETRM documentation records a status of VALID in both the 12.1.1 and 12.2.2 codelines, indicating the object remains supported and has not been superseded by a later collection mechanism. It depends only on SYS.STANDARD, and no other package references it, confirming that it is invoked directly by concurrent programs rather than through a programmatic call chain.

Key Procedures and Functions

The documented interface exposes five procedures and functions. Their names indicate the classic extract-transform-load pattern used by DBI collection packages:

  • LOAD_FACT — the primary entry point that populates the summary fact table from staging and operational sources. It is the procedure a collection concurrent program calls to build the book-summary data set.
  • UPDATE_FACT — performs incremental maintenance on already-loaded fact rows, reconciling changed or late-arriving records without a full rebuild.
  • LOAD_SALES_FACT — loads the sales-credit dimension of the fact, drawing on sales-credit and sales-representative sources to attribute bookings correctly.
  • UPDATE_SALES_FACT_DUMMY — a placeholder or no-op style routine retained for interface compatibility; its name suggests it exists to satisfy a caller signature rather than to transform data.
  • GET_CUST_PRODUCT_LINE_ID — a lookup function resolving the customer/product-line identifier used to key fact rows.

Tables Accessed

The package reads and writes through APPS synonyms. Staging and target tables include ISC_TMP_BOOK_SUM2 (temporary working set), ISC_BOOK_SUM2_F (the loaded summary fact) and ISC_CURR_BOOK_SUM2 (current-period summary). Sales attribution draws on ISC_SALES_CREDITS_F, JTF_RS_SALESREPS and JTF_RS_SRP_GROUPS for representative and group hierarchies. Organizational context comes from HR_ORGANIZATION_INFORMATION, calendar context from FII_TIME_DAY, and item context from MTL_SYSTEM_ITEMS_B through ENI_OLTP_ITEM_STAR. AR_SYSTEM_PARAMETERS_ALL supplies ledger and currency setup; ISC_SERVICE_BOOK_SUM2 provides the service-order counterpart. Collection control and diagnostics use BIS_OBJ_DEPENDENCY, BIS_OBJ_PROPERTIES and ISC_DBI_CHANGE_LOG to track what changed.

Usage Notes

ISC_DBI_BOOK_SUM2_F_C is not called from Oracle Forms or from customer-written code; it executes inside the DBI collection concurrent programs that refresh Demand Planning fact tables. Administrators typically trigger it via the standard collection request set, which sequences LOAD_FACT before UPDATE_FACT and the sales-fact routines. Because the package is Other-classified and unsupported for direct invocation, customizations should target the collection program rather than the package. Changes to AR_SYSTEM_PARAMETERS_ALL or ISC_DBI_CHANGE_LOG processing can affect its results, so it is important to confirm the change log is populated and that the item star is current before running a collection.