Bill Set Limit Reports Error When Trying To Change The Credit Limit Of An Account In The Secondary DB (Doc ID 408674.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.0.0.0.1 to 7.0.0.0.1 [Release 7.0.0]
HP 9000 HP-UX 11.0 (32 bit)
Microsoft Windows (32-bit)
Oracle Solaris on SPARC (32-bit)
Checked for relevance on 24-Jan-2010
*** Checked for relevance on 05-27-2015 ***


Symptoms

Facing problems when trying to change a resource credit limit of an account in the secondary db.

 

The problem happens in the following steps:

1. input flist as:

# number of field entries allocated 20, used 3
0 PIN_FLD_POID           POID [0] 0.0.0.2 /account 617273 0
0 PIN_FLD_PROGRAM_NAME    STR [0] "testnap"
0 PIN_FLD_LIMIT         ARRAY [4000122] allocated 20, used 5
1     PIN_FLD_CREDIT_LIMIT DECIMAL [0] 7
1     PIN_FLD_CREDIT_FLOOR DECIMAL [0] NULL pin_decimal_t ptr
1     PIN_FLD_CREDIT_THRESHOLDS    INT [0] 0
1     PIN_FLD_BAL_GRP_OBJ    POID [0] 0.0.0.2 /balance_group 2948927 2
1     PIN_FLD_ELEMENT_ID      INT [0] 4000122

2. execute opcode PCM_OP_BILL_SET_LIMIT in Testnap, as:

nap(3965)> xop PCM_OP_BILL_SET_LIMIT 0 1

3. It reports error in DM, error as:

E Mon Aug 22 16:24:142005  infranet  dm:2978  dm_subr.c(93):2074 1:infto2d:<no_name>:3965:1:106:1119609805:1
        ORACLE error: do_sql_update: OCIStmtExecute: code 1732, op 32
        =ORA-01732: data manipulation operation not legal on this view
E Mon Aug 22 16:24:14 2005  infranet dm:2978  dm_ops.c(104):2100 1:infto2d:<no_name>:3965:1:106:1119609805:1
        OP_WFLDS do_sql_update "update config_t set poid_rev = poid_rev + 1, mod_t = :mod_t   where poid_id0 = :poid_id0", x=1, id 201
E Mon Aug 22 16:24:14 2005  infranet dm:2978  dm_back.c(12):1295 
1:infto2d:<no_name>:3965:1:106:1119609805:1
      DMbe #6: process_op: op 5, err 43

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