Dm Oracle Error During Item Allocation For Line Transfer Accounts (Doc ID 470618.1)

Last updated on MARCH 03, 2008

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.0 to 7.3
This problem can occur on any platform.

Symptoms

When attempting to do a item allocation for line transfer accounts having ordered balance group.
the following error occurs in dm_oracle.pinlog.

ORACLE  error: do_sql_mr_select: OCIStmtExecute: code 1427, op -1
            =ORA-01427: single-row subquery returns more than one row
    E Sat Sep 22 04:08:37 2007  vfnzh311  dm:10320  dm_search.c(79):935 1:machine1:xxxx :28244:13:120055:1190390917:2072
            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_balgro 
    up_t where au_ordered_balgroup_t.service_obj_ID0 = :2  and au_ordered_balgroup_t.effective_t <= : 
    3 group by au_parent_obj_id0) ) and au_ordered_balgroup_t.poid_db = :4  
    

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