Results for “create_icx_session”
12 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
BIS_ICX_SECURITY_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite. As indicated by the _PVT suffix and the AUTHID CURRENT_USER declaration, it is an internal implementation package rather than a public API intended for direct customer invocation. Its documented purpose is to simulate an ICX (Oracle Applications Framework / Self-Service) login and return the session artifacts that the EBS framework normally generates during an interactive user sign-on. Specifically, the package produces the session identifier, cookie value, cookie name, transaction identifier, database connection name, web agent, framework agent, and language code associated with a synthesized session.
The package header carries a revision marker of 115.4 dated 2002/11/20, with initial creation attributed to user amkulkar on 02-25-00. This long-lived lineage confirms the object has been carried forward largely unchanged from the earliest 11i releases into the 12.1.1 and 12.2.2 code lines, where it remains part of the BIS (Business Intelligence System / Daily Business Intelligence) product family.
Key Procedures and Functions
The ETRM metadata documents a single program unit within this package:
- CREATE_ICX_SESSION — The sole documented procedure. Its stated function is to simulate an ICX login and return the resulting session_id, cookie_value, and transaction id. The signature accepts an input user identifier plus optional context selectors for responsibility application, responsibility, security group, menu, function, and page. It returns, by output parameter, the session identifier, cookie value, cookie name, transaction identifier, database connection name, the APPS web and framework agents, the language code, and a standard EBS return-status block (status, message data, message count). Because the procedure is internal, the return-status convention mirrors the FND-style diagnostic pattern used throughout EBS private packages.
Tables Accessed
The package resolves two objects through APPS synonyms:
- FND_LANGUAGES — The Oracle Applications installed-languages table. It is queried to derive the language code returned in the output parameter set, ensuring the simulated session carries a valid NLS language context.
- V$NLS_PARAMETERS — The dynamic performance view exposing current NLS session settings. It is read to capture the active NLS environment so the synthesized session is consistent with the database session under which the package executes.
No other tables are documented as referenced. The package is also documented as being referenced by one other package, reflecting its role as a shared internal utility within the BIS/ICX security layer.
Usage Notes
Because BIS_ICX_SECURITY_PVT is a private package, it is not intended for direct invocation from forms, concurrent programs, or customer-written code. It is invoked internally by the BIS product code, and by the one dependent package identified in the metadata, whenever a programmatic ICX session must be established without an interactive browser sign-on — for example, when generating or scheduling Daily Business Intelligence content that requires an authenticated framework context. The output values (session_id, cookie_value, cookie_name, transaction_id, and the agent strings) are the same tokens the EBS middle tier would otherwise manage, allowing downstream code to reuse standard framework plumbing.
For Oracle EBS 12.1.1 and 12.2.2, the object remains physically present in the APPS schema and is covered by the standard EBS patching and editioning model. Developers should treat the package as sealed: customization or direct calls risk breaking the dependent BIS component, and any required session simulation should be pursued through supported public APIs rather than this private unit. The naming similarity to commercial asset-management or cyber-security vendors has no bearing on the package's function; it is purely an EBS internal security utility.
-
PACKAGE: APPS.APP_SESSION 12.1.1
-
PACKAGE: APPS.APP_SESSION 12.2.2
-
PACKAGE: APPS.APP_SESSION 12.2.2
-
PACKAGE: APPS.APP_SESSION 12.1.1