Unable To Edit Fields In Suspense Manager (Doc ID 1592138.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

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

Symptoms

Unable to Edit fields in Suspense manager :

Not able to edit fields in Suspense manager in schema 2.
However it can be seen that in Schema 1 it can be edited .

When one compares the logs of both schema 1 & 2.

It can be seen in schema 2, internally it is calling fm_bglock_make_template , but in schema 1, it is not calling that.

it tries to find below data from database and not able to find it, hence the following errors are seen


0 PIN_FLD_POID POID [0] 0.0.0.2 /account 2 0
0 PIN_FLD_LOCK_INFO SUBSTRUCT [0] allocated 20, used 2
1 PIN_FLD_TEMPLATE STR [0] "select X from /balance_group where F1 = V1 order by bal_grp_t.poid_id0 "
1 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
2 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.2 /account 2 0

Query it executes in database : select * from bal_grp_t where account_obj_id0= 2 order by bal_grp_t.poid_id0;

But data that is present in database is select * from bal_grp_t where account_obj_id0= 1 order by bal_grp_t.poid_id0;
===
Cm log:

E Fri Jun 28 17:06:06 2013 ukne27sr-vf cm:14493 fm_suspense_edit_usage.c:733 1:ACN2TSCDC:UnknownProgramName:0:Thread-9:4451:1372433204:0
  fm_suspense_update_suspended_usage error
E Fri Jun 28 17:06:06 2013 ukne27sr-vf cm:14493 fm_suspense_edit_usage.c:415 1:ACN2TSCDC:UnknownProgramName:0:Thread-9:4451:1372433204:0
  fm_suspense_edit_usage error
E Fri Jun 28 17:06:06 2013 ukne27sr-vf cm:14493 fm_suspense_edit_usage.c:158 1:ACN2TSCDC:UnknownProgramName:0:Thread-9:4451:1372433204:0
  op_suspense_edit_usage error
 E Fri Jun 28 17:06:06 2013 ukne27sr-vf cm:14493 cm_child.c(119):4669 1:ACN2TSCDC:UnknownProgramName:0:Thread-9:4451:1372433204:0
  op PCM_OP_SUSPENSE_EDIT_USAGE returned an error
  
  
  
DM log:

E Fri Jun 28 16:58:27 2013 ukne27sr-vf dm:28301 dm_back.c(31):1440 1:ACN2TSCDC:UnknownProgramName:0:Thread-8:4451:1372432746:0
  DMbe #15: process_op: op 5(PCM_OP_WRITE_FLDS), err 3(PIN_ERR_NOT_FOUND)
E Fri Jun 28 17:06:05 2013 ukne27sr-vf dm:28301 dm_search.c(108):3725 1:ACN2TSCDC:UnknownProgramName:0:Thread-9:4451:1372433204:0
  Lock tried on a non-existent object!
  Lock Cmd-> select poid_DB, poid_ID0, poid_TYPE, poid_REV from bal_grp_t where bal_grp_t.account_obj_ID0 = :1 order by bal_grp_t.poid_id0 for update of bal_grp_t.poid_id0 ,BindValues-> :1=2,
E Fri Jun 28 17:06:06 2013 ukne27sr-vf dm:28301 dm_ops.c(243):10497 1:ACN2TSCDC:UnknownProgramName:0:Thread-9:4451:1372433204:0
  op_search_and_bulk_act: dm_search_rflds() failed: err=0(PIN_ERR_NONE)
W Fri Jun 28 17:06:06 2013 ukne27sr-vf dm:28301 dm_do_ops.c(97):240 1:ACN2TSCDC:UnknownProgramName:0:Thread-9:4451:1372433204:0
  do_lockobj_with_template: op_search_and_bulk_act failed
W Fri Jun 28 17:06:06 2013 ukne27sr-vf dm:28301 dm_ops.c(243):4215 1:ACN2TSCDC:UnknownProgramName:0:Thread-9:4451:1372433204:0
  op_wflds: do_lockobj_with_template failed
E Fri Jun 28 17:06:06 2013 ukne27sr-vf dm:28301 dm_back.c(31):1440 1:ACN2TSCDC:UnknownProgramName:0:Thread-9:4451:1372433204:0
  DMbe #15: process_op: op 5(PCM_OP_WRITE_FLDS), err 3(PIN_ERR_NOT_FOUND)

 

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