Search Results local_same_as_remote

Overview

ISC_EDW_BOOK_SUM1_F_C is a PL/SQL package body in the APPS schema that supports the Oracle EBS Supply Chain Intelligence (ISC) operational data store, specifically the Booking Summary fact build process. It belongs to the ISI/ISC family of extract, transform, and load packages that populate the Enterprise Data Warehouse (EDW) staging and fact tables from transactional order data. The package encapsulates the "Book Summary1" collection logic, which aggregates order booking activity into a summary fact structure used by Supply Chain Intelligence dashboards and reports. The body declares global state variables — g_errbuf and g_retcode for concurrent manager error reporting, g_row_count for row-level auditing, and date-range globals (g_push_from_date, g_push_to_date, g_push_from_booked_date, g_push_to_booked_date) that parameterize the extraction window. Header comments indicate an origin date of 2003 with version 115.14. The package is classified under ETRM as OTHER rather than a standard public API, consistent with its role as an internal collection program.

Key Procedures and Functions

The documented entry point is PUSH, the main driving procedure that executes the Booking Summary fact load. Although the excerpt truncates before the PUSH declaration, the surrounding private constructs clarify its supporting machinery. Three private helpers are visible:

• TRUNCATE_STG — resolves the ISC schema name via FND_INSTALLATION.GET_APP_INFO and dynamically truncates the staging table ISC_EDW_BOOK_SUM1_FSTG using EXECUTE IMMEDIATE, providing a clean slate for each collection run.
• DELETE_STG — removes staging rows whose COLLECTION_STATUS is 'LOCAL READY' and whose INSTANCE matches the local instance code, keeping only unprocessed rows relevant to the current node.
• LOCAL_SAME_AS_REMOTE — returns a BOOLEAN indicating whether the local instance code equals the remote instance code fetched from edw_local_instance@edw_apps_to_wh over the database link. This governs whether the local collection should proceed or defer to the warehouse node.

Tables Accessed

The package reads and writes the following documented objects:

• EDW_LOCAL_INSTANCE — provides the local instance code used by DELETE_STG and LOCAL_SAME_AS_REMOTE.
• ISC_EDW_BOOK_SUM1_FSTG — the staging table truncated and filtered prior to extraction.
• ISC_TMP_BOOK_SUM1 and ISC_TMP_BOOK_SUM1_S — temporary working tables that hold intermediate booking summary results during PUSH processing.
• OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL — Order Management source tables supplying booking header and line transaction data that the fact build summarizes.
• DUAL — used for scalar and control-flow evaluations.

Usage Notes

ISC_EDW_BOOK_SUM1_F_C is not invoked from EBS forms; it is executed by the Supply Chain Intelligence collection framework, typically as a concurrent program or subordinate call within the EDW fact-build chain. Administrators run it during scheduled overnight collections that refresh Booking Summary facts in the ISC operational data store. The LOCAL_SAME_AS_REMOTE check confirms whether the local instance is the designated warehouse instance before performing local staging operations, ensuring distributed deployments do not double-collect. Because the package is classified OTHER, it carries no supported public API contract and should be considered internal; customizations should not call it directly but rather extend the supported collection programs. Reviewers tracing the "local_same_as_remote" reference should understand it as a private guard function, not a standalone utility.