dm_oracle Error While Executing Trial Billing (Doc ID 1357185.1)

Last updated on SEPTEMBER 27, 2013

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 and later
Information in this document applies to any platform.
Checked for relevance on 27-Sep-2013.

Symptoms

While trying to execute trial bill, the below error from DM Oracle can be seen (ORA-00936: missing expression):

select sum ( event_bal_impacts_t.amount ) from event_t ,event_bal_impacts_t
where event_t.poid_id0 in ) and ( event_bal_impacts_t.impact_type = :1
or event_bal_impacts_t.impact_type = :2 )
and event_t.poid_TYPE NOT LIKE :3 and event_t.poid_TYPE NOT LIKE :4
and event_t.poid_TYPE NOT LIKE :5 and event_t.poid_TYPE NOT LIKE :6
and event_t.poid_id0 = event_bal_impacts_t.obj_id0


which corresponds to the following search (in CM pinlog):

W Thu Jun 2 15:53:25 2011 BRM003 cm_billing:23409 cm_utils.c(129):1445 1:BRM003:<no_name>:23407:-135035200:1123:1307033604:2
CM FM->DM opcode PCM_OP_SEARCH, opflags=0x0
     # number of field entries allocated 20, used 6
0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_FLAGS INT [0] 256
0 PIN_FLD_TEMPLATE STR [0] " select X from /event where event_t.poid_id0 in (266117002536388512) and F1 LIKE V1 and F2 = V2 "
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1     PIN_FLD_POID POID [0] 0.0.0.1 /event/billing/item/transfer -1 0
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1     PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 1276316468 5
0 PIN_FLD_RESULTS ARRAY [0] allocated 20, used 2
1     PIN_FLD_ITEM_OBJ POID [0] NULL poid pointer
1     PIN_FLD_SESSION_OBJ POID [0] NULL poid pointer
D Thu Jun 2 15:53:25 2011 BRM003 cm_billing:23409 cm_child.c(115):4829 1:BRM003:<no_name>:23407:-135035200:1123:1307033604:2
     opcode db: 1(0.0.0.1), context db: 1(0.0.0.1), trans_state: 2, opcode: 7
W Thu Jun 2 15:53:25 2011 BRM003 cm_billing:23409 cm_utils.c(129):1842 1:BRM003:<no_name>:23407:-135035200:1123:1307033604:2
CM DM->FM opcode PCM_OP_SEARCH, opflags=0x0
    # number of field entries allocated 20, used 1
0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0


This error is happening during trial billing, the events/items which do not seem to exist are objects that have been created during the trial billing.

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