My Oracle Support Banner

FM_RATE_GET_CANDIDATE_DISCLIST_GET_OBG_AUDIT_DATA Gives Error ORA-01427 Single-row Subquery Returns (Doc ID 1520820.1)

Last updated on MARCH 22, 2019

Applies to:

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


When a service has two /au_ordered_balance_group objects having different au_parent_obj_id0, following error occurs:

  E Thu Sep 13 11:20:44 2012  sun64z23  dm:21345  dm_subr.c(121):7810 1:sun66z08:BrmConnectionPool:0:pool-10-thread-1:151:1347528044:0   
         ORACLE error: do_sql_mr_select: PINStmtExecute: code 1427, op 0   
         =ORA-01427: single-row subquery returns more than one row   
  E Thu Sep 13 11:20:45 2012  sun64z23  dm:21345  dm_search.c(92):1049 1:sun66z08:BrmConnectionPool:0:pool-10-thread-1:151:1347528044:0
         dm_search_rflds: do_sql_mr_select failed select  distinct  poid_DB, poid_ID0, poid_TYPE, poid_REV, au_parent_obj_DB, au_parent_obj_ID0,
         au_parent_obj_TYPE, au_parent_obj_REV, effective_t from au_ordered_balgroup_t   where au_ordered_balgroup_t.service_obj_ID0 = :1  
         and au_ordered_balgroup_t.effective_t >= (select max( au_ordered_balgroup_t.effective_t ) from au_ordered_balgroup_t where
         au_ordered_balgroup_t.service_obj_ID0 = :2 and au_ordered_balgroup_t.effective_t <= :3 group by au_parent_obj_id0)

It is in the scenario:

Calling the opcode PCM_OP_SUBSCRIPTION_ORDERED_BALGRP to create, to delete, and finally to create an ordered_balgroup for a service, there are 3 records in au_orederd_balgroup_t for the same service and account but with different au_parent_obj_id0.





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.