My Oracle Support Banner

Contact Center: Signature Of Package "SYS.DBMS_SQL" Has Been Changed (Doc ID 741648.1)

Last updated on FEBRUARY 06, 2022

Applies to:

Oracle Customer Care - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

In Contact Center - Invoices tab:

When attempting to capture Payments or see the Transaction Details , the following error occurs:

ERROR
ORA-04062: signature of package SYS.DBMS_SQL has been changed.
FRM-40735-WHEN-BUTTON-PRESSED trigger raised unhandled exception.

WHAT IS WORKING
This works when accessed from Accounts Receivables.


EXPECTED FUNCTIONALITY
Agent to be able to capture Payment or create Invoice Disputes.

-- Steps To Reproduce:
(R) Service
(N) Customer Manage > Contact Center
- Invoices Tab
- Select an Invoice
- Click on Payment Details o Transaction Details buttons.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.