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

Last updated on AUGUST 24, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 to 7.3.1.0.1 [Release 7.3.1]
Information in this document applies to any platform.

Symptoms

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 machine1 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   

 

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

It is in the scenario you get the failure.

Cause

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