Search Results dbms_reco_script_int

Overview

DBMS_RECO_SCRIPT_INT is an Oracle-supplied internal PL/SQL package owned by the SYS schema and shipped as part of the core database technology stack. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, it forms part of the recoverable script infrastructure — a low-level framework that underpins Oracle Streams, Advanced Queuing, and related replication and messaging components that EBS relies upon for data propagation, event handling, and certain concurrent processing activities. The "_INT" suffix denotes that the package is intended for internal consumption by other Oracle database packages rather than for direct invocation by application developers or end users. Its status of VALID in the ETRM reference indicates that the object is compiled and operational in the documented environment.

This package does not implement any EBS-specific business logic. Instead, it provides internal plumbing that supports the recoverable script mechanism, which allows long-running or multi-step database operations to be recorded, restarted, or recovered in a consistent manner. EBS applications benefit indirectly: whenever features built on Streams, AQ, or recoverable script processing are exercised, DBMS_RECO_SCRIPT_INT contributes to the underlying execution and recovery logic.

Key Procedures and Functions

The ETRM metadata for this object documents zero public procedures or functions. This is consistent with its classification as an internal package: its callable units are not part of a supported, documented API surface. Any program units contained within the package are consumed by other Oracle-supplied packages and are subject to change without notice across database patch levels or releases.

Because no documented entry points exist, no parameter lists should be assumed, and no procedure or function should be invoked directly. Developers seeking recoverable script functionality should use the higher-level, documented wrapper package, DBMS_RECOVERABLE_SCRIPT, which the ETRM metadata shows referencing DBMS_RECO_SCRIPT_INT.

Tables Accessed

The ETRM excerpt does not enumerate any tables accessed by DBMS_RECO_SCRIPT_INT, and no tables are documented through APPS synonyms. Internally, packages of this family typically operate against SYS-owned repository tables that persist recoverable script state — such as script definitions, execution checkpoints, and completion status — so that interrupted operations can be resumed or cleaned up. These underlying objects reside in the SYS schema and are not exposed to the APPS schema for direct querying or modification.

From an EBS configuration and support perspective, no application tables are read or written by this package. Its persistence footprint remains within the database dictionary and internal Streams/AQ metadata, and it does not alter EBS transactional or setup data.

Usage Notes

DBMS_RECO_SCRIPT_INT is never invoked from an Oracle EBS form, concurrent program, or supported customization. It is called internally by other SYS packages. The ETRM dependency data shows that it is referenced by three packages: DBMS_RECOVERABLE_SCRIPT, DBMS_RECO_SCRIPT_INVOK, and DBMS_STREAMS_RPC. It in turn references STANDARD (the base PL/SQL package always present in an Oracle database) and its own body.

For EBS administrators and developers, the practical guidance is straightforward:

Do not call DBMS_RECO_SCRIPT_INT directly from custom code; it is unsupported for that purpose.
Do not attempt to modify or recompile the package manually; doing so can invalidate dependent Streams and AQ components and may require a database restart or recompilation of the dependent package hierarchy.
If the package becomes INVALID, standard remediation is to recompile the dependent SYS packages (for example, DBMS_RECOVERABLE_SCRIPT and DBMS_STREAMS_RPC) rather than the internal package in isolation.
When troubleshooting Streams, AQ, or recoverable script errors in EBS 12.1.1 or 12.2.2, treat this object as an internal dependency and focus diagnostics on the documented caller, DBMS_RECOVERABLE_SCRIPT.

In summary, DBMS_RECO_SCRIPT_INT is a supporting SYS package whose relevance to EBS is indirect, providing the internal machinery on which recoverable script and Streams processing depend.

PACKAGE: SYS.DBMS_RECO_SCRIPT_INT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_RECO_SCRIPT_INT, status:VALID,
PACKAGE: SYS.DBMS_RECO_SCRIPT_INT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_RECO_SCRIPT_INT, status:VALID,
PACKAGE BODY: SYS.DBMS_RECO_SCRIPT_INT 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_RECO_SCRIPT_INT, status:VALID,
PACKAGE BODY: SYS.DBMS_RECO_SCRIPT_INT 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_RECO_SCRIPT_INT, status:VALID,
PACKAGE: SYS.DBMS_STREAMS_ADV_ADM_UTL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_STREAMS_ADV_ADM_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_RECOVERABLE_SCRIPT 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_RECOVERABLE_SCRIPT, status:VALID,
PACKAGE: SYS.DBMS_RECO_SCRIPT_INT 12.1.1
PACKAGE: SYS.DBMS_STREAMS_ADV_ADM_UTL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_STREAMS_ADV_ADM_UTL, status:VALID,
PACKAGE: SYS.DBMS_RECOVERABLE_SCRIPT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_RECOVERABLE_SCRIPT, status:VALID,
PACKAGE: SYS.DBMS_RECO_SCRIPT_INT 12.2.2
PACKAGE: SYS.DBMS_RECOVERABLE_SCRIPT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_RECOVERABLE_SCRIPT, status:VALID,
PACKAGE BODY: SYS.DBMS_RECOVERABLE_SCRIPT 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_RECOVERABLE_SCRIPT, status:VALID,
PACKAGE BODY: SYS.DBMS_RECO_SCRIPT_INVOK 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_RECO_SCRIPT_INVOK, status:VALID,
PACKAGE BODY: SYS.DBMS_RECO_SCRIPT_INVOK 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_RECO_SCRIPT_INVOK, status:VALID,
TABLE: SYS.RECO_SCRIPT_ERROR$ 12.1.1
owner:SYS, object_type:TABLE, object_name:RECO_SCRIPT_ERROR$, status:VALID,
TABLE: SYS.RECO_SCRIPT_ERROR$ 12.2.2
owner:SYS, object_type:TABLE, object_name:RECO_SCRIPT_ERROR$, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS_RPC 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_RPC, status:VALID,
TABLE: SYS.RECO_SCRIPT_PARAMS$ 12.1.1
owner:SYS, object_type:TABLE, object_name:RECO_SCRIPT_PARAMS$, status:VALID,
TABLE: SYS.RECO_SCRIPT_PARAMS$ 12.2.2
owner:SYS, object_type:TABLE, object_name:RECO_SCRIPT_PARAMS$, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS_RPC 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_RPC, status:VALID,
TABLE: SYS.RECO_SCRIPT$ 12.1.1
owner:SYS, object_type:TABLE, object_name:RECO_SCRIPT$, status:VALID,
TABLE: SYS.RECO_SCRIPT$ 12.2.2
owner:SYS, object_type:TABLE, object_name:RECO_SCRIPT$, status:VALID,
TABLE: SYS.RECO_SCRIPT_BLOCK$ 12.1.1
owner:SYS, object_type:TABLE, object_name:RECO_SCRIPT_BLOCK$, status:VALID,
TABLE: SYS.RECO_SCRIPT_BLOCK$ 12.2.2
owner:SYS, object_type:TABLE, object_name:RECO_SCRIPT_BLOCK$, status:VALID,
PACKAGE BODY: SYS.DBMS_RECO_SCRIPT_INT 12.1.1
PACKAGE: SYS.DBMS_STREAMS_ADM_UTL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_STREAMS_ADM_UTL, status:VALID,
PACKAGE: SYS.DBMS_STREAMS_ADM_UTL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_STREAMS_ADM_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_RECO_SCRIPT_INT 12.2.2
PACKAGE: SYS.DBMS_LOGREP_UTIL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_LOGREP_UTIL, status:VALID,
PACKAGE: SYS.DBMS_LOGREP_UTIL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_LOGREP_UTIL, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
PACKAGE: SYS.DBMS_SYS_ERROR 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_SYS_ERROR, status:VALID,
PACKAGE: SYS.DBMS_SYS_ERROR 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_SYS_ERROR, status:VALID,
SYS.DBMS_RECO_SCRIPT_INVOK dependencies on DBMS_RECO_SCRIPT_INT 12.1.1
SYS.DBMS_RECO_SCRIPT_INT dependencies on DBMS_RECO_SCRIPT_INT 12.2.2
SYS.DBMS_RECOVERABLE_SCRIPT dependencies on DBMS_RECO_SCRIPT_INT 12.2.2
SYS.DBMS_RECO_SCRIPT_INT dependencies on DBMS_RECO_SCRIPT_INT 12.1.1
SYS.DBMS_RECOVERABLE_SCRIPT dependencies on DBMS_RECO_SCRIPT_INT 12.1.1
SYS.DBMS_STREAMS_RPC dependencies on DBMS_RECO_SCRIPT_INT 12.2.2
SYS.DBMS_STREAMS_RPC dependencies on DBMS_RECO_SCRIPT_INT 12.1.1
SYS.DBMS_RECO_SCRIPT_INVOK dependencies on DBMS_RECO_SCRIPT_INT 12.2.2
PACKAGE: SYS.DBMS_ASSERT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_ASSERT, status:VALID,
PACKAGE: SYS.DBMS_ASSERT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_ASSERT, status:VALID,
PACKAGE: SYS.DBMS_STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_STANDARD, status:VALID,
PACKAGE: SYS.DBMS_STANDARD 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_STANDARD, status:VALID,
PACKAGE: SYS.STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,