Search Results populate_poa_fii




Overview
Explore in AI Chat

Overview

APPS.POA_PORTAL_POPULATE_C is a PL/SQL package that supports the Procurement Operations Analysis (POA) portal within Oracle E-Business Suite. Its principal business role is to consolidate procurement transaction data into the summary and fact tables that back the POA portal dashboards and analytics. The package performs extract, transform, and load (ETL) style population routines: it moves data from operational purchasing and receiving sources, together with Oracle Procurement Intelligence / Enterprise Data Warehouse (EDW) staging structures, into portal-facing summary tables such as POA_PORTAL_PDIST, POA_PORTAL_RCPT_SUM, and POA_PORTAL_FII_SUMMARY. Based on the header (`poaporss.pls`) and the object naming, the package belongs to the Oracle Purchasing (PO) schema family and is intended for internal, scheduled execution rather than interactive transactional use.

Key Procedures and Functions

APPS.POA_PORTAL_POPULATE_C exposes nine documented procedures. Each performs a distinct slice of the portal population, generally scoped by a start date, end date, and (where applicable) a quarter, and returns a processing count and a success indicator.

  • POPULATE_POA — Top-level driver that orchestrates population of the POA portal data set; returns error buffer and return code information suitable for concurrent program invocation.
  • POPULATE_POA_FII — Driver for the Financial Intelligence (FII) portion of the portal population; returns error buffer and return code information.
  • INSERT_ROWS_PD — Inserts purchasing distribution (spend/distribution) rows for the given date range and quarter.
  • INSERT_ROWS_SR — Inserts supplier-related summary rows for the given date range.
  • INSERT_ROWS_CM — Inserts contract management related rows for the given date range.
  • INSERT_ROWS_SP — The procedure referenced by the search term “insert_rows_sp”; inserts summary/performance rows (supplier performance oriented) for the specified date range, returning a row count and success status.
  • INSERT_ROWS_RCV — Inserts receiving transaction rows for the given date range, feeding receipt summaries.
  • INSERT_ROWS_CROSS — Inserts cross-dimensional or cross-reference rows combining procurement facts for the date range.
  • TRUNCATE_TABLES — Accepts a numeric type parameter and truncates the relevant portal staging/summary tables prior to reload, returning a success status.

Tables Accessed

The package reads from EDW dimension and fact structures and writes to portal summary repositories. Documented source references include EDW_ITEMS_M, EDW_LOOKUP_M, EDW_ORGANIZATION_M, EDW_TIME_M, and EDW_TRD_PARTNER_M (the item, lookup, organization, time, and trading-partner dimensions). Transactional source fact tables include POA_EDW_PO_DIST_F (purchasing distributions), POA_EDW_RCV_TXNS_F (receiving transactions), and POA_EDW_SUP_PERF_F (supplier performance). FII sources include FII_AP_OP_INDICATOR_SUMMARY and FII_AP_TRANS_BACKLOG_SUMMARY. Output targets include POA_PORTAL_PDIST, POA_PORTAL_PDIST1, POA_PORTAL_PDIST2, POA_PORTAL_RCPT_SUM, and POA_PORTAL_FII_SUMMARY. All are accessed through APPS synonyms.

Usage Notes

POA_PORTAL_POPULATE_C is not intended for direct end-user invocation. It is typically executed by scheduled concurrent programs that first call TRUNCATE_TABLES and then the INSERT_ROWS_* procedures, or by the higher-level POPULATE_POA and POPULATE_POA_FII drivers. The date-range and quarter parameters allow incremental or periodic refreshes of the portal. Because the package is documented as referenced by zero other packages, customization should treat it as a leaf-level utility invoked from concurrent program definitions or external orchestration rather than from application APIs. Oracle EBS 12.1.1 and 12.2.2 share the same documented signature; the file version string (120.0) indicates the package has remained stable since its original release.