My Oracle Support Banner

AMM Results In Invoicing Errors (Doc ID 1365337.1)

Last updated on MAY 11, 2021

Applies to:

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

Symptoms

After the installation of AMM (Account Migration Manager) patch 12699392, and its dependent patch 10649430, invoicing fails with the error in DM.

Error in dm_oracle.pinlog:

E Fri Feb 14 10:15:57 2014 <HOSTNAME> dm:14072 dm_subr.c(141):8521 1:<HOSTNAME>: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 <HOSTNAME> dm:14072 dm_search.c(100):1080 1:<HOSTNAME>: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 <HOSTNAME> dm:14072 dm_ops.c(221):10199 1:<HOSTNAME>: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 <HOSTNAME>cm:15982 fm_inv_pol_prep_invoice.c:3626 1:<HOSTNAME>: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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.