Search Results aso_bi_util_pvt

Overview

ASO_BI_UTIL_PVT is a private PL/SQL utility package in the Oracle EBS Order Capture (ASO) module family, designated with the PVT (private) API classification and owned by the APPS schema. Its header, bearing the version string asovbildutls.pls 120.0, dates from May 2005, and the package is declared AUTHID CURRENT_USER, meaning that all unqualified references resolve under the privileges of the invoking session rather than the package owner. Consistent with the "BI" and "UTIL" naming, the package provides shared infrastructure services rather than business transactions. Its responsibilities span three areas: administrative maintenance of database objects (initialization, truncation, statistics gathering) and currency conversion rate resolution. The package is referenced by four other packages within the application, confirming its role as a low-level dependency in the Order Capture data-processing chain. Because it is a private package, Oracle does not publish it as a supported extension point; customizations should not call it directly without assessing upgrade impact.

Key Procedures and Functions

• INIT — The initialization routine. It determines the schema owner and default tablespace so that subsequent operations can qualify object names correctly.
• TRUNCATE_TABLE — Accepts a table name and truncates the identified table, providing a controlled mechanism for clearing staging or interim data.
• ANALYZE_TABLE — Accepts a table name and gathers statistics (analyzes) that table, supporting the Cost Based Optimizer for the collections this package and its callers manipulate.
• GET_CLOSEST_RATE_SQL — A function, declared PARALLEL_ENABLE, that was the focus of the user's search. It resolves a currency conversion rate (returning NUMBER) between a from-currency and to-currency as of a given conversion date, with a conversion type optionally supplied. The x_max_roll_days parameter governs how far the lookup may roll backward from the requested date to locate the most recent applicable rate — the "closest rate" behavior that gives the function its name. It is intended for use in SQL statements rather than purely procedural code, given its PARALLEL_ENABLE attribute.

Tables Accessed

The ETRM metadata excerpt does not enumerate the base tables referenced by this package. However, the function's semantics necessarily involve the daily currency conversion rate table used by General Ledger and Order Capture, typically GL_DAILY_RATES accessed through an APPS synonym. The truncate and analyze procedures operate dynamically on table names passed at runtime, so their target objects are not fixed in the metadata. No confirmed direct references are documented.

Usage Notes

ASO_BI_UTIL_PVT is invoked internally by the four dependent packages rather than through a standalone Oracle Forms screen or concurrent program. GET_CLOSEST_RATE_SQL is designed for embedding in SQL, where its PARALLEL_ENABLE declaration allows parallel query execution — useful when resolving rates across large order or quote result sets. The administrative procedures are typically called during data loads, interface runs, or maintenance windows to purge and analyze staging tables. On Oracle EBS 12.1.1 and 12.2.2, the source is identical; 12.2.x merely relocates the file system under the online patching editioning model. Because the package is private and its header has been stable since 2005, developers should treat it as sealed internal infrastructure and avoid direct dependencies in custom code.