Results for “submit_request”

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

Overview

APPS.BIS_REGISTRATION_SERVICE_PUB is a public PL/SQL package in Oracle E-Business Suite that provides the application programming interface for the BIS (Business Intelligence System / Intelligence) registration service. Within the Oracle EBS 12.1.1 and 12.2.2 codebase, the package acts as the programmatic entry point through which external or internal callers submit registration requests to the BIS framework. The package is declared with AUTHID CURRENT_USER, meaning that its SQL statements execute with the privileges of the invoking schema rather than the defining APPS schema, which allows controlled delegation of database access to the calling context.

The API classification is PUB, indicating that the package is intended for public consumption by other Oracle EBS modules, integration layers, and customer-written extensions. Its single documented entry point, SUBMIT_REQUEST, is designed to accept a request specification composed of a timing value and up to ten generic parameter name/value pairs, and to return an identifier that the caller can use to track or reference the submitted request. This design reflects a generic, metadata-driven registration pattern in which the package itself does not need to know the concrete semantics of the parameters being passed.

Key Procedures and Functions

The package exposes one documented procedure:

• SUBMIT_REQUEST — The sole public procedure in the package. It accepts a time value, a set of up to ten optional parameter type/value pairs, and returns a request identifier through an OUT NOCOPY parameter. Its purpose is to register a request with the BIS registration service, capturing the caller-supplied timing and parameter context, and to hand back a request ID that uniquely identifies the submitted registration. The generic parameter_type1 through parameter_type10 and parameter_value1 through parameter_value10 arguments allow the procedure to be reused across different registration scenarios without schema changes.

No functions or additional procedures are documented in the ETRM metadata for this package.

Tables Accessed

The documented metadata for APPS.BIS_REGISTRATION_SERVICE_PUB does not list any underlying tables referenced through APPS synonyms. The header excerpt available in the ETRM record shows only the package specification and the SUBMIT_REQUEST signature; the package body, which would contain the actual DML against BIS repository tables, is not reproduced in the metadata. Consequently, no specific table access can be confirmed from the supplied documentation. In practice, a registration service of this nature typically writes to BIS configuration or request-tracking tables, but such access should be verified against the installed package body rather than assumed.

Usage Notes

APPS.BIS_REGISTRATION_SERVICE_PUB is a public API and is therefore a legitimate integration surface for both Oracle-delivered functionality and customer extensions. It is typically invoked from custom PL/SQL code, concurrent program wrappers, or integration adapters that need to hand a registration request to the BIS service layer. Because the procedure returns a request identifier, callers commonly capture that value and use it to correlate downstream processing, logging, or reconciliation.

Two practical considerations apply. First, the AUTHID CURRENT_USER clause means that any schema calling the package must itself hold the necessary object and data privileges; the package does not elevate privileges on the caller's behalf. Second, because the parameter interface is generic (type/value pairs), the correct type identifiers and expected values must be obtained from the BIS implementation documentation or by inspecting the package body. Callers should not assume that any particular parameter position carries a fixed meaning. Given the package's age (the header dates to 2002), it should be treated as stable but legacy, and any use in 12.1.1 or 12.2.2 should be validated against the exact installed version of BISPARSS.pls.