My Oracle Support Banner

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

Last updated on AUGUST 26, 2020

Applies to:

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


On Billing and Revenue Management (BRM) version, Account Sync module:

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


* installed PS19 (Patch Set 19)
* installed the dm_ifw_sync with the command:

          ./ create -l PIN07/PIN07@PINdatabase

* ran this grants with system user:

grant execute on databasems_lock to PIN07;
grant execute on databasems_aq to PIN07;
grant execute on databasems_aqadm to PIN07;
grant execute on databasems_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 database with several schemas like pin, pin01, pin02… pin07 and each environment has account synchronization configured. That means there are multiple AQs (Advanced Queues) 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?


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

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