Search Results bism_export_reader

Overview

BISM_EXPORT_READER is a read-side PL/SQL package body owned by the APPS schema. It belongs to the BISM (Business Intelligence System Management / Business Intelligence System Manager) family of utilities, which provide the E-Business Suite an export and metadata transport mechanism for moving object definitions and configuration records between environments and into external repositories. Where the companion package BISM_EXPORT performs the write side of the export operation, BISM_EXPORT_READER exposes the consumer-side interface that extracts and removes staged export records maintained in the BISM repository.

The package is documented in the ETRM metadata as an "OTHER" classification object rather than a public API, indicating it is an internal utility called by the BISM export framework rather than an interface intended for direct customer invocation. Its status is recorded as VALID in 12.1.1 and 12.2.2, confirming that it is a delivered, supported database object in both release levels.

Key Procedures and Functions

Three documented program units are exposed by the package body:

• GET_OBJECT — Retrieves a single export object from the BISM export repository. It provides the read accessor used by the export framework to pull back a previously staged record, either for downstream transformation, transmission, or verification.
• DELETE_OBJECT — Removes a single export object from the repository, typically invoked after a record has been successfully consumed or transmitted, providing record-level cleanup.
• DELETE_OBJECTS — Performs the same removal operation at set level, purging a group of export objects in a single call. This is the batch counterpart to DELETE_OBJECT and is used to clear the staging area efficiently without row-by-row processing.

The ETRM documentation does not record parameter signatures for these units, so their exact argument lists should be confirmed against the deployed package specification before use.

Tables Accessed

The package references two tables through APPS synonyms:

• BISM_EXPORT — The principal repository table. GET_OBJECT reads records from it, while DELETE_OBJECT and DELETE_OBJECTS remove records from it. This table holds the export object definitions staged by the BISM export process.
• DUAL — The standard Oracle single-row utility table, used for trivial SELECT operations such as assignment, date or sequence evaluation, or existence checks within the package logic.

No other application tables are recorded in the dependency metadata.

Usage Notes

Invocation of BISM_EXPORT_READER is primarily indirect. The package depends on BISM_EXPORT and on itself, and the metadata states it is not referenced by any other database object in the ETRM inventory, meaning callers are found in the Oracle Forms layer, concurrent program registrations, or the BISM export runtime rather than in other PL/SQL packages. Typical invocation scenarios include:

• Export concurrent programs that read staged records from BISM_EXPORT and purge them once processed.
• Oracle EBS Forms, particularly within the BISM administration responsibilities, where a user action triggers retrieval or deletion of export objects.
• Custom integration code built by implementers who need programmatic access to the BISM export staging table.

Because the package is classified as OTHER and is not a published API, direct calls should be treated cautiously. Customers and integrators should avoid modifying the delivered package body, since patching or upgrades may replace it, and any extension should be implemented in a separate custom wrapper. The absence of documented parameter lists further reinforces that the package specification from the live instance must be inspected before it is referenced in custom code.