Failed While Enqueueing: Error ORA-01422: Exact Fetch Returns More Than Requested Number Of Rows (Doc ID 1677834.1)

Last updated on MAY 29, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 and later
Information in this document applies to any platform.

Goal

On : BRM 7.4.0.19.0 version, Account Sync

During billing, there is a failure from the dm_ifw_sync module.


Scenario:

* installed PS19
* installed the dm_ifw_sync with the command:

          ./pin_ifw_sync_oracle.pl create -l PIN07/PIN07@PINDB

* ran this grants with system user:

grant execute on dbms_lock to PIN07;
grant execute on dbms_aq to PIN07;
grant execute on dbms_aqadm to PIN07;
grant execute on dbms_lock to PIN07;
grant select on sys.gv_$aq to PIN07;

* ran billing for an account with product and discount with forward event and found this error in cm.pinlog:


* In this server where the issue is witnessed, there are several BRM environments.  There is a DB with several schemas like pin, pin01, pin02… pin07 and each environment has account synchronization configured. That means there are multiple AQs configured for each BRM instance, all with the same name ( for example, BRM_AQ).

What is the reason for the error and how can we resolve?
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms