Search Results oracle vz rx fd

The SYS.DBMS_AQ_EXP_QUEUE_TABLES package in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a specialized utility within the Oracle Advanced Queuing (AQ) framework, designed to facilitate the export of queue table metadata and data. This package is part of the DBMS_AQADM family and is primarily used in migration, backup, or replication scenarios where queue tables need to be transferred between databases or environments. Below is a detailed analysis of its functionality, use cases, and relevance in Oracle EBS.

Overview of `DBMS_AQ_EXP_QUEUE_TABLES`

The package provides procedures to export queue table definitions, including their associated queues, queue data, and metadata, into a binary format (dump files) compatible with Oracle Data Pump. This is particularly useful in Oracle EBS environments where Advanced Queuing is leveraged for asynchronous messaging, workflow notifications, or integration with external systems. Key features include:

Metadata Export: Captures queue table structures, queue properties, and dependencies.
Data Export: Optionally includes enqueued messages for replication or archival.
Cross-Database Compatibility: Ensures exported data adheres to Oracle's internal formats for seamless import.

Key Procedures and Parameters

The package includes critical procedures such as:

EXPORT_QUEUE_TABLES: Exports one or more queue tables. Parameters include:
- queue_tables: List of queue tables to export.
- directory: Oracle directory object pointing to the export location.
- file_name: Output dump file name.
- export_data: Boolean to include/exclude message data.
EXPORT_QUEUE_TABLE: Single-table variant of the above.

Use Cases in Oracle EBS

In EBS 12.1.1/12.2.2, this package is instrumental in:

Environment Cloning: Replicating queue configurations from production to test environments.
Disaster Recovery: Backing up critical queues (e.g., Workflow Notification Mailer queues).
Upgrades/Patching: Preserving queue states during system updates.

Example Scenario

To export the WF_DEFERRED_QUEUE table (used in Workflow):

BEGIN
    SYS.DBMS_AQ_EXP_QUEUE_TABLES.EXPORT_QUEUE_TABLE(
        queue_table    => 'APPS.WF_DEFERRED_QUEUE_TABLE',
        directory      => 'AQ_EXPORT_DIR',
        file_name      => 'wf_queue_export.dmp',
        export_data    => TRUE
    );
END;

Limitations and Considerations

Privileges: Requires EXECUTE on DBMS_AQ_EXP_QUEUE_TABLES and write access to the directory object.
Version Compatibility: Exported files may not be compatible across major Oracle versions.
Performance Impact: Large queues may incur significant I/O overhead during export.

Integration with EBS Modules

The package interacts with EBS components like:

Workflow: Manages deferred notifications and agent queues.
Integration Repository: Supports AQ-based interfaces.

Conclusion

SYS.DBMS_AQ_EXP_QUEUE_TABLES is a niche but critical tool for Oracle EBS administrators managing Advanced Queuing infrastructure. Its ability to serialize queue tables ensures data consistency during migrations and provides a safety net for high-availability configurations. Proper usage demands an understanding of both AQ architecture and EBS-specific queue dependencies.

Oracle eBusiness Suite Technical Reference 12.1.1
SYNONYM: PUBLIC.oracle/sqlj/runtime/Oracle 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:oracle/sqlj/runtime/Oracle, status:VALID,
Oracle eBusiness Suite Technical Reference 12.2.2
SYNONYM: PUBLIC.oracle/sqlj/runtime/Oracle 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:oracle/sqlj/runtime/Oracle, status:VALID,
JAVA CLASS: SYS.oracle/sqlj/runtime/Oracle 12.1.1
owner:SYS, object_type:JAVA CLASS, object_name:oracle/sqlj/runtime/Oracle, status:VALID,
JAVA CLASS: SYS.oracle/sqlj/runtime/Oracle 12.2.2
owner:SYS, object_type:JAVA CLASS, object_name:oracle/sqlj/runtime/Oracle, status:VALID,
Lookup Type: PO_CLM_EXHIBIT_NUMBER 12.2.2
product: PO - Purchasing , meaning: PO_CLM_EXHIBIT_NUMBER , description: PO Clm Exhibit Numbers ,
File: Oracle E-Business Tax Logical Data Model R12.pdf 12.1.1
product: ZX - E-Business Tax , size: 93.47 KBytes , file_type: PDF Diagram ,
File: Oracle E-Business Tax Logical Data Model R12.pdf 12.2.2
product: ZX - E-Business Tax , size: 93.47 KBytes , file_type: PDF Diagram ,
PACKAGE: SYS.DBMS_AQ_EXP_QUEUE_TABLES 12.2.2
APPS.GHR_PAY_CAPS dependencies on STANDARD 12.2.2
APPS.GHR_PAY_CAPS dependencies on STANDARD 12.1.1
PACKAGE: SYS.DBMS_AQ_EXP_QUEUE_TABLES 12.1.1
PACKAGE: SYS.DBMS_FILE_GROUP_DECL 12.1.1
Concurrent Program: RXARINVR 12.1.1
execution_filename: ARRX_C_TRX.TRANSACTION_REGISTER , product: AR - Receivables , user_name: RX Transaction Register , description: RX Transaction Register , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXARRCFR 12.2.2
execution_filename: ARRX_C_TRX.RECEIPT_FORECAST , product: AR - Receivables , user_name: RX Receipt Forecast , description: RX Receipt Forecast , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXARRCRG 12.1.1
execution_filename: ARRX_C_RC.RECEIPT_REGISTER , product: AR - Receivables , user_name: RX Receipt Register , description: RX Receipt Register , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: FVRXLODR 12.2.2
execution_filename: FV_SETUP_PKG.LOAD_RX_REPORTS , product: FV - Federal Financials , user_name: Load RX Reports , description: Load RX Reports , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXARACRC 12.2.2
execution_filename: ARRX_C_RC.ACTUAL_RECEIPT , product: AR - Receivables , user_name: RX Actual Receipt , description: RX Actual Receipt , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXGLCKJ 12.2.2
execution_filename: GLRX_JOURNAL_COVER_PKG.JOURNALS_CHECK , product: GL - General Ledger , user_name: RX Journals Check Report , description: RX Journals Check Report , argument_method: Standard , enabled: No , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXARSLRG 12.1.1
execution_filename: ARRX_C_TRX.SALES_REGISTER , product: AR - Receivables , user_name: RX Sales Register , description: RX Sales Register , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXARINVC 12.1.1
execution_filename: ARRX_C_TRX.TRANSACTION_CHECK , product: AR - Receivables , user_name: RX Transaction Check , description: RX Transactions Check , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXARINVR 12.2.2
execution_filename: ARRX_C_TRX.TRANSACTION_REGISTER , product: AR - Receivables , user_name: RX Transaction Register , description: RX Transaction Register , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXAPPYAC 12.2.2
execution_filename: aprx_c_py.payment_actual_run , product: AP - Payables , user_name: RX: Actual Payment , description: RX version of Actual Payment Report , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXARARRG 12.1.1
execution_filename: ARRX_C_RC.AR_APPL_REC_REGISTER , product: AR - Receivables , user_name: RX-only: Applied Receipts Register , description: RX-only: Applied Receipts Register , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXAROTHR 12.1.1
execution_filename: ARRX_C_OTH.AR_OTH_REC_APP , product: AR - Receivables , user_name: Rx Other Receipt Applications Report , description: Rx-only: Other Receipt Applications Report , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXARARRG 12.2.2
execution_filename: ARRX_C_RC.AR_APPL_REC_REGISTER , product: AR - Receivables , user_name: RX-only: Applied Receipts Register , description: RX-only: Applied Receipts Register , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXARUNAR 12.2.2
execution_filename: ARRX_C_UNAPP.AR_UNAPP_REC_REGISTER , product: AR - Receivables , user_name: RX Unapplied and Unresolved Receipts Register , description: RX-only: Unapplied and Unresolved Receipts Register , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXGLGNJ 12.2.2
execution_filename: GLRX_JOURNAL_COVER_PKG.JOURNALS_GENERAL , product: GL - General Ledger , user_name: RX Journals Report , description: RX Journals Report , argument_method: Standard , enabled: No , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXARSLRG 12.2.2
execution_filename: ARRX_C_TRX.SALES_REGISTER , product: AR - Receivables , user_name: RX Sales Register , description: RX Sales Register , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXARMTRG 12.2.2
execution_filename: ARRX_C_RC.AR_MISC_TRX_REGISTER , product: AR - Receivables , user_name: RX Miscellaneous Transaction Register , description: RX Miscellaneous Transaction Register , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: FVRXLODR 12.1.1
execution_filename: FV_SETUP_PKG.LOAD_RX_REPORTS , product: FV - Federal Financials , user_name: Load RX Reports , description: Load RX Reports , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXARACRC 12.1.1
execution_filename: ARRX_C_RC.ACTUAL_RECEIPT , product: AR - Receivables , user_name: RX Actual Receipt , description: RX Actual Receipt , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXGLGNJ 12.1.1
execution_filename: GLRX_JOURNAL_COVER_PKG.JOURNALS_GENERAL , product: GL - General Ledger , user_name: RX Journals Report , description: RX Journals Report , argument_method: Standard , enabled: No , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXAPPYRG 12.1.1
execution_filename: aprx_c_py.payment_register_run , product: AP - Payables , user_name: RX: Payment Register , description: RX version of Payment Register , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXGLVCJ 12.1.1
execution_filename: GLRX_JOURNAL_COVER_PKG.JOURNALS_DAY , product: GL - General Ledger , user_name: RX Journals Day Report , description: RX Journals Day Report , argument_method: Standard , enabled: No , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXGLVCJ 12.2.2
execution_filename: GLRX_JOURNAL_COVER_PKG.JOURNALS_DAY , product: GL - General Ledger , user_name: RX Journals Day Report , description: RX Journals Day Report , argument_method: Standard , enabled: No , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXARMTRG 12.1.1
execution_filename: ARRX_C_RC.AR_MISC_TRX_REGISTER , product: AR - Receivables , user_name: RX Miscellaneous Transaction Register , description: RX Miscellaneous Transaction Register , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXAPPYAC 12.1.1
execution_filename: aprx_c_py.payment_actual_run , product: AP - Payables , user_name: RX: Actual Payment , description: RX version of Actual Payment Report , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXGLDBJ 12.2.2
execution_filename: GLRX_JOURNAL_COVER_PKG.JOURNALS_DAY , product: GL - General Ledger , user_name: RX Journals Day Report , description: RX Journals Day Report , argument_method: Standard , enabled: No , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXARRCRG 12.2.2
execution_filename: ARRX_C_RC.RECEIPT_REGISTER , product: AR - Receivables , user_name: RX Receipt Register , description: RX Receipt Register , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXARRCFR 12.1.1
execution_filename: ARRX_C_TRX.RECEIPT_FORECAST , product: AR - Receivables , user_name: RX Receipt Forecast , description: RX Receipt Forecast , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXARINVC 12.2.2
execution_filename: ARRX_C_TRX.TRANSACTION_CHECK , product: AR - Receivables , user_name: RX Transaction Check , description: RX Transactions Check , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXGLCKJ 12.1.1
execution_filename: GLRX_JOURNAL_COVER_PKG.JOURNALS_CHECK , product: GL - General Ledger , user_name: RX Journals Check Report , description: RX Journals Check Report , argument_method: Standard , enabled: No , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXAPPYRG 12.2.2
execution_filename: aprx_c_py.payment_register_run , product: AP - Payables , user_name: RX: Payment Register , description: RX version of Payment Register , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: FARXPRG 12.2.2
execution_filename: FARXPRG , product: OFA - Assets , user_name: FARXPRG , description: Purge RX Interface Data , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: RXGLDBJ 12.1.1
execution_filename: GLRX_JOURNAL_COVER_PKG.JOURNALS_DAY , product: GL - General Ledger , user_name: RX Journals Day Report , description: RX Journals Day Report , argument_method: Standard , enabled: No , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXARUNAR 12.1.1
execution_filename: ARRX_C_UNAPP.AR_UNAPP_REC_REGISTER , product: AR - Receivables , user_name: RX Unapplied and Unresolved Receipts Register , description: RX-only: Unapplied and Unresolved Receipts Register , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXAROTHR 12.2.2
execution_filename: ARRX_C_OTH.AR_OTH_REC_APP , product: AR - Receivables , user_name: Rx Other Receipt Applications Report , description: Rx-only: Other Receipt Applications Report , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: RXFACAP 12.1.1
execution_filename: FARX_C_CP.CAP , product: OFA - Assets , user_name: RXFACAP , description: RX: Capitalizations Report , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,