Search Results poa_report_util




Overview
Explore in AI Chat

Overview

APPS.POA_REPORT_UTIL is a PL/SQL utility package (API classification: UTIL) that supports the reporting and analytical infrastructure of Oracle Procurement. Its primary purpose is to assemble and manage the runtime parameters, view-by criteria, and formatted output required by Procurement reporting tools, most notably the Oracle Procurement Analytics (POA) reporting framework. The package constructs reporting date ranges, view-by selections, hidden form fields, and derived cost and supplier attributes that drive report rendering and query execution.

The package is owned by the APPS schema and holds a VALID status. It reports no inbound dependencies from other PL/SQL packages, indicating that it is primarily an end-point utility invoked directly by reporting components rather than a shared library consumed by other APIs. Its dependencies include APPS.BIS_COMMON_UTILS, APPS.BIS_RESPONSIBILITY_PVT, and APPS.BIS_UTILITIES_PUB, all members of the Oracle Business Intelligence System (BIS) family of utilities that provide common reporting and responsibility-resolution services. Because these foundational packages are widely used across EBS reporting, POA_REPORT_UTIL inherits their session, security, and formatting conventions.

Key Procedures and Functions

The ETRM documentation records 42 documented procedures and functions for this package. The documented members fall into recognizable functional groups:

This grouping reflects the package's role as a parameter- and dimension-preparation layer for procurement analytics reports.

Tables Accessed

Through APPS synonyms, the package references the following tables:

  • AK_REGIONS — Oracle Application Framework region metadata used when building view-by regions and form layout context.
  • BIS_LEVELS — BIS hierarchy level definitions supporting drill-down and level-based view-by construction.
  • FND_USER — resolves the current application user identity for responsibility and personalization context.
  • MTL_CATEGORIES_KFV — category key flexfield values used for commodity and category dimension builders.
  • MTL_SYSTEM_ITEMS_KFV — item key flexfield values supporting item-related builders such as BUILD_HIDDENITEM and BUILD_SUPPLIERITEM.
  • PER_ALL_PEOPLE_F — person/employee data used to resolve buyers and agents for savings reporting dimensions.
  • PO_AGENTS — purchasing agent assignments used in buyer-based builders.

Additional references to DBMS_SQL, HTF, HTP, and PLITBLM confirm that the package uses dynamic SQL construction and Oracle HTML-related output utilities, consistent with its role in generating report content and query fragments.

Usage Notes

POA_REPORT_UTIL is typically invoked by Procurement Analytics report forms and their supporting concurrent programs rather than by external custom code. Because it is referenced by no other packages, it should be regarded as an internal reporting utility: callers within the POA reporting framework invoke its builders to populate form fields, LOVs, and report parameters at runtime.

Customizations should avoid direct modification of this package. Oracle-supplied utility packages of this class are commonly patched during EBS upgrades and one-off patches; local edits can be overwritten. When extending procurement reporting, prefer wrapping documented procedures or creating dependent custom packages that call the public builders, treating POA_REPORT_UTIL as a stable parameter-construction service.