Search Results insert_rows_sr




Overview
Explore in AI Chat

Overview

POA_PORTAL_POPULATE_C is an Oracle Applications (APPS) PL/SQL package that supports the Procurement Operations Analysis (POA) portal reporting framework within Oracle E-Business Suite. Its principal business function is to gather, transform, and stage procurement transaction data drawn from operational purchasing, receiving, supplier performance, and payables sources into the summary and distribution tables that underlie the POA portal dashboards and analytical reports. In effect, the package acts as an Extraction-Transformation-Load (ETL) utility, moving granular transactional records into aggregated structures that can be queried efficiently by portal users.

The package is classified as OTHER under the ETRM/API taxonomy, indicating that it is not a public application programming interface intended for customer extension but rather an internal utility invoked by scheduled concurrent programs or seed data processes. The header comment (poaporss.pls 120.0) dates the source to 2005, consistent with the 11i/12.0 lineage carried forward into 12.1.1 and 12.2.2 with minimal change.

Key Procedures and Functions

The package exposes nine documented procedures, several of which share a common signature pattern of start and end dates, an out count of rows processed, and a success flag:

  • POPULATE_POA — The primary orchestration routine, accepting an Errbuf and Retcode pair suitable for concurrent program invocation. It drives the end-to-end refresh of POA data.
  • POPULATE_POA_FII — A parallel orchestration routine focused on the FII (federal/investment indicator or similar) data set, again using Errbuf/Retcode.
  • INSERT_ROWS_PD — Loads purchase distribution (PO distribution) rows for a date range and quarter.
  • INSERT_ROWS_SR — Populates rows associated with supplier-related or service-receipt processing for the specified start and end dates. This is the procedure targeted by the search term "insert_rows_sr".
  • INSERT_ROWS_CM — Inserts rows for the corresponding commodity/material dimension.
  • INSERT_ROWS_SP — Inserts supplier performance rows.
  • INSERT_ROWS_RCV — Inserts receiving transaction rows.
  • INSERT_ROWS_CROSS — Inserts cross-dimensional (fact-to-dimension) rows.
  • TRUNCATE_TABLES — Clears staging/summary tables before a refresh, taking a numeric p_type selector and returning a success flag.

Tables Accessed

The package reads from EDW dimension and fact synonyms (EDW_ITEMS_M, EDW_LOOKUP_M, EDW_ORGANIZATION_M, EDW_TIME_M, EDW_TRD_PARTNER_M) to resolve item, lookup, organization, time-period, and trading-partner attributes. It sources transactional and summary data from FII_AP_OP_INDICATOR_SUMMARY, FII_AP_TRANS_BACKLOG_SUMMARY, POA_EDW_PO_DIST_F, POA_EDW_RCV_TXNS_F, and POA_EDW_SUP_PERF_F. Target structures written by the insert and truncate routines include POA_PORTAL_FII_SUMMARY, POA_PORTAL_PDIST, POA_PORTAL_PDIST1, POA_PORTAL_PDIST2, and POA_PORTAL_RCPT_SUM. These targets are the presentation-layer tables queried by the portal.

Usage Notes

POA_PORTAL_POPULATE_C is designed for scheduled execution, typically through a concurrent program that calls POPULATE_POA or POPULATE_POA_FII with the standard Errbuf and Retcode parameters. The detailed INSERT_ROWS_* procedures are generally called internally by the orchestration routines rather than directly. Because the package is referenced by zero other packages, it functions as a top-level data-population driver rather than a reusable library. Customizations should avoid direct modification; customers requiring incremental loads should consider invoking the documented procedures through their own concurrent program definitions. Refreshes should be run within a maintenance window, since TRUNCATE_TABLES clears staging data before reload.