AMM Results In Invoicing Errors (Doc ID 1365337.1)

Last updated on AUGUST 20, 2015

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.4.0.1.0 [Release 7.4.0]
Information in this document applies to any platform.
***Checked for relevance on 04-Aug-2013***

Symptoms

After the installation of AMM patch 12699392, and its dependant patch 10649430, invoicing fails with the error in DM.

Error in dm_oracle.pinlog:

E Fri Feb 14 10:15:57 2014 machine dm:14072 dm_subr.c(141):8521 1:machine:testnap:15979:1:953:1312268676:1
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:

D Fri Feb 14 10:15:57 2014 machine master_cm:15982 fm_inv_pol_prep_invoice.c:3626 1:machine:testnap:15979:1:953:1312268676:1create_dir_info
# number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_ERR_BUF ERR [0]
<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.

Scenario:

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

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