Last updated on AUGUST 20, 2015
Applies to:Oracle Communications Billing and Revenue Management - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 7.4.0]
Information in this document applies to any platform.
***Checked for relevance on 04-Aug-2013***
After the installation of AMM patch 12699392, and its dependant patch 10649430, invoicing fails with the error in DM.
Error in dm_oracle.pinlog:
ORACLE error: do_sql_mr_select: PINStmtExecute: code 907, op 0=ORA-00907: missing right parenthesis
E Fri Feb 14 10:15:57 2014 machine dm:14072 dm_search.c(100):1080 1:machine:testnap:15979:1:953:1312268676:1
dm_search_rflds: do_sql_mr_select failed select /*+ index(bill_t) */ poid_DB, poid_ID0, poid_TYPE, poid_REV, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV, bill_no, parent_DB, parent_ID0, parent_TYPE, parent_REV from bill_t where bill_t.POID_DB is NOT NULL and ( ( parent_id0 = 0 ) connect by prior parent_id0 = bill_t.poid_id0 start with ( bill_t.poid_ID0 = :1 and bill_t.account_obj_ID0 = :2 ) )
E Fri Feb 14 10:15:57 2014 machine dm:14072 dm_ops.c(221):10199 1:machine:testnap:15979:1:953:1312268676:1
op_search_and_bulk_act: dm_search_rflds() failed: err=0(PIN_ERR_NONE)
Error in cm.pinlog:
# number of field entries allocated 20, used 2
0 PIN_FLD_POID POID  0.0.0.1 /search -1 0
0 PIN_FLD_ERR_BUF ERR 
<location=PIN_ERRLOC_DM:4 class=UNKNOWN:0 errno=PIN_ERR_STORAGE:43>
<field num=opsflds:0,0 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
<facility=0 msg_id=0 version=0>
It seems like dm_oracle does not support "start with .. connect by" and "union all" clauses.
1. Install AMM and patch 12699392 and its dependant patch 10649430.
2. Run invoicing
Note: null_poid_db_check is set in dm_oracle/pin.conf
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