Search Results terr_miss_acc_param

Overview

AST_OFL_TERR_MISS_ACC_PARAM is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that belongs to the Oracle Assets (FA/AST) product family. Its name suggests a diagnostic role: it reports on territory (territory assignment) records that are missing associated account parameters, a condition that commonly arises during the assignment of accounting flexfield distributions to asset locations, employees, or territories. The package is a small, self-contained utility declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer, and it contains only three procedures with no public functions. Its embedded header comment ($Header: astrtnps.pls 115.7 2002/02/07) indicates it is a long-standing component of the Oracle Assets code line, unchanged in structure across releases. In ETRM classification it is tagged as API classification OTHER, confirming it is not a formal business API but an internal reporting or diagnostic helper.

Key Procedures and Functions

Three procedures are documented in the package specification:

• TERR_MISS_ACC_PARAM — The principal procedure of the package and the entry point for its core logic. It drives the identification and reporting of territory records for which account parameter information is absent. As the package's namesake routine, it encapsulates the diagnostic query and output generation.
• HEADER — A presentation helper that emits the report's header section. Consistent with Oracle's server-side HTML toolkit conventions, this typically opens the output page and renders the title and introductory markup.
• FOOTER — A complementary presentation helper that emits the report's closing section, closing markup emitted by the header routine and terminating the output stream.

No parameter lists are documented for any of these procedures; per the ETRM metadata they are declared without arguments. No private functions or additional overloads are recorded.

Tables Accessed

The package references four objects through APPS synonyms: DUAL, HTF, HTP, and OWA_UTIL. DUAL is the standard Oracle single-row utility table, used here for lightweight expression evaluation. HTF and HTP are the Hypertext Function and Hypertext Procedure packages that generate HTML output from PL/SQL, and OWA_UTIL is the Oracle Web Agent utility package used for HTML escaping, printing, and related server-side rendering tasks. Notably, the metadata records no direct references to Assets base tables such as FA_ADDITIONS or FA_BOOKS; the data retrieval logic is therefore encapsulated in the TERR_MISS_ACC_PARAM procedure, which likely queries Assets territory and account parameter tables at runtime. The heavy reliance on HTP/HTF/OWA_UTIL confirms the package's purpose is to render a diagnostic web page rather than to perform data maintenance.

Usage Notes

Given its HTML-generation dependencies and diagnostic character, AST_OFL_TERR_MISS_ACC_PARAM is typically invoked from the Oracle Applications Framework or from a standalone PL/SQL session in which output is directed to a browser via the Oracle HTTP Server (mod_plsql) or the Oracle E-Business Suite's embedded web listener. In EBS 12.1.1 (mod_plsql on Oracle HTTP Server) and 12.2.2 (Oracle WebLogic Server with the PL/SQL cartridge), server-side packages such as this render their output directly to the response stream. Administrators and support analysts would call AST_OFL_TERR_MISS_ACC_PARAM.TERR_MISS_ACC_PARAM when investigating missing account parameter assignments on territories; the HEADER and FOOTER procedures are called internally by the main routine and are not intended for independent invocation. Because it is classified as OTHER rather than a supported API, it should not be called from custom concurrent programs or integrations without analysis, as its signature is not guaranteed across patches. It is referenced by zero other packages, confirming it sits at the leaf of the dependency tree and serves purely as an end-point diagnostic utility.