Unable To Process Deposits (Doc ID 1446746.1)

Last updated on JULY 28, 2017

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

1. Ran pin_deposit to process an authorization that had a transaction ID which contained "V68" string (for example T1,V68,0)

2. DM_ORACLE gave the following error:

E Sun Mar 18 14:10:34 2012  sbkcomappp14  dm:1682  dm_ops.c(228):7477 1:sbkcomappp14:testnap:15054:-135878432:7:1332094234:1
      op_search_and_bulk_act: too many args (68) in args list (limit 32)



3. It appeared that the "V68" as part of this search initiated by pin_deposit was interpreted as a search argument by DM_ORACLE:

0 PIN_FLD_POID           POID [0] 0.0.0.1 /search/pin -1 0
0 PIN_FLD_FLAGS           INT [0] 0
0 PIN_FLD_TEMPLATE        STR [0] "select X from /event/billing/charge/cc where F1 = V1 and poid_id0 = ( select obj_id0 from event_billing_charge_t where trans_id = 'U1,V68,0' and command = 2 ) "
0 PIN_FLD_ARGS          ARRAY [1] allocated 20, used 1
1     PIN_FLD_POID           POID [0] 0.0.0.1 /event -1 0
0 PIN_FLD_RESULTS       ARRAY [0] allocated 20, used 3
1     PIN_FLD_POID           POID [0] NULL poid pointer
1     PIN_FLD_CC_INFO       ARRAY [*]     NULL array ptr
1     PIN_FLD_CHARGE       SUBSTRUCT [0] allocated 20, used 1
2         PIN_FLD_BILL_OBJ       POID [0] NULL poid pointer



The problem was specific to the alphabet "V".
An alternate search like below from pin_deposit would actually solve the problem.

0 PIN_FLD_POID           POID [0] 0.0.0.1 /search/pin -1 0
0 PIN_FLD_FLAGS           INT [0] 0
0 PIN_FLD_TEMPLATE        STR [0] "select X from /event/billing/charge/cc where F1 = 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/charge/cc -1 0
0 PIN_FLD_ARGS          ARRAY [2] allocated 20, used 1
1     PIN_FLD_CHARGE       SUBSTRUCT [0] allocated 20, used 1
2 PIN_FLD_TRANS_ID STR [0] "U1,V68,0"
0 PIN_FLD_ARGS          ARRAY [3] allocated 20, used 1
1     PIN_FLD_CHARGE       SUBSTRUCT [0] allocated 20, used 1
2 PIN_FLD_COMMAND ENUM [0] 2
0 PIN_FLD_RESULTS       ARRAY [0] allocated 20, used 3
1     PIN_FLD_POID           POID [0] NULL poid pointer
1     PIN_FLD_CC_INFO       ARRAY [*]     NULL array ptr
1     PIN_FLD_CHARGE       SUBSTRUCT [0] allocated 20, used 1
2         PIN_FLD_BILL_OBJ       POID [0] NULL poid pointer

Changes

 

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