Results for “get_session_process_id”

16 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FUN_RULE_UTILITY_PKG is an Oracle EBS Application Object Library package owned by the APPS schema and classified as an "OTHER" API. It resides in the Oracle Subledger Accounting / Financials rule framework and provides a shared library of utility routines that support rule generation and rule maintenance activities. The package is defined with AUTHID CURRENT_USER, meaning its database calls execute with the privileges of the invoking session rather than the definer, which is consistent with its role as a low-level helper that queries session and application metadata. The script header (FUNXTMRULGENUTS.pls, version 120.1) dates the source to 2006, with authorship attributed to Amulya Mishra. In both 12.1.1 and 12.2.2, the package retains this utility role, and the ETRM metadata documents roughly twenty-four procedures and functions. Ten other packages reference it, indicating that it is a dependency of the broader rule-engine codebase rather than an end-user-facing API. The user's search term, get_session_process_id, corresponds to the function that returns the operating-system process identifier of the current database session.

Key Procedures and Functions

The documented entry points fall into three functional groups.

Tables Accessed

The package works against a mix of application tables and engine internals.

  • FUN_RULE_DETAILS, FUN_RULE_OBJECTS_B — the natural-language rule definition and rule object tables that the duplicate-rule and sequence helpers operate upon.
  • FND_APPLICATION, FND_LANGUAGES, FND_LOOKUP_VALUES — AOL reference data used to resolve schema names, application identifiers, and lookup meanings.
  • HZ_RELATIONSHIP_TYPES and SO_LOOKUPS — Trading Community and Order Management lookup sources consulted by the lookup-meaning helper.
  • V$SESSION and V$PROCESS — dynamic performance views used by GET_SESSION_PROCESS_ID to identify the calling session's server process.
  • PLITBLM, DBMS_SQL, DBMS_UTILITY, UTL_FILE — supporting built-ins and packages rather than tables, used for dynamic SQL, parsing of delimited strings, and file operations within the utility routines.

Usage Notes

FUN_RULE_UTILITY_PKG is a back-end utility and is not normally invoked directly by end users. Its most common consumer is the rule generation engine and the forms, concurrent programs, and custom extensions that create or duplicate financial rules, all of which need a reliable way to stamp audit columns, resolve schema and application metadata, or obtain a session's process ID for logging and troubleshooting. Because of the declared purity of GET_SESSION_PROCESS_ID, PL/SQL developers may safely call it from SQL statements and from restricted contexts, which is useful when diagnostics must capture the OS process behind a session. The package is available in both 12.1.1 and 12.2.2; the 12.2 online-patching model does not alter its signature, though the underlying V$SESSION and V$PROCESS columns it depends on remain subject to the standard DBA grants required for APPS.