Customer Center Does Not Consider International Characters For Status Change Notes (Doc ID 1609381.1)

Last updated on DECEMBER 27, 2013

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

On BRM 7.4 PS18 Service and Account status change screen, in Customer Center, have a Notes textbox, which automatically limits the length of the text the user can introduce. This also has a label indicating the quantity of characters left.

This logic does not consider non ASCII characters, which may be MULTI BYTE. The user receives an ambiguous message.

Snippet of cm.pinlog
----------------------------
# number of field entries allocated 20, used 1
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 262503 11
D Wed Mar 5 00:00:00 2014 xxxx cm:14611 cm_utils_trans.c(15):422 1:OBISIGNA-AR2:CustomerCenter:0:AWT-EventQueue-0:62:1383855126:0
fm_utils_trans_commit returning
E Wed Mar 5 00:00:00 2014 xxxx cm:14611 fm_cust_status.c:1124 1:OBISIGNA-AR2:CustomerCenter:0:AWT-EventQueue-0:62:1383855126:0
op_cust_set_status error

E Wed Mar 5 00:00:00 2014 xxxx cm:14611 cm_child.c(116):4674 1:OBISIGNA-AR2:CustomerCenter:0:AWT-EventQueue-0:62:1383855126:0
op PCM_OP_CUST_SET_STATUS returned an error

W Wed Mar 5 00:00:00 2014 xxxx cm:14611 cm_child.c(116):4715 1:OBISIGNA-AR2:CustomerCenter:0:AWT-EventQueue-0:62:1383855126:0
CM output flist: opcode PCM_OP_CUST_SET_STATUS
# number of field entries allocated 3, used 2
0 PIN_FLD_POID POID [0] 0.0.0.1 /error_poid 262503 0
0 PIN_FLD_ERR_BUF ERR [0]

 

Snippet of dm_oracle.pinlog
---------------------------------------
E Wed Mar 5 00:00:00 2014 xxxxx dm:14343 dm_subr.c(146):2021 1:OBISIGNA-AR2:CustomerCenter:0:AWT-EventQueue-0:62:1383855126:0
ORACLE error: do_sql_select: PINStmtExecute: code 1406, op 0
=ORA-01406: fetched column value was truncated

E Wed Mar 5 00:00:00 2014 xxxx dm:14343 dm_do_ops.c(94):2526 1:OBISIGNA-AR2:CustomerCenter:0:AWT-EventQueue-0:62:1383855126:0
ERROR OP_ROBJ: do_sql_select("select poid_DB, poid_ID0, poid_TYPE, poid_REV, created_t, mod_t, read_access, write_access, aac_access, aac_package, aac_promo_code, aac_serial_num, aac_source, aac_vendor, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV, bal_grp_obj_DB, bal_grp_obj_ID0, bal_grp_obj_TYPE, bal_grp_obj_REV, close_when_t, effective_t, item_poid_list, laststat_cmnt, last_status_t, login, name, next_item_poid_list, object_cache_type, passwd, passwd_expiration_t, passwd_status, profile_obj_DB, profile_obj_ID0, profile_obj_TYPE, profile_obj_REV, service_id, status, status_flags, subscription_obj_DB, subscription_obj_ID0, subscription_obj_TYPE, subscription_obj_REV, type from service_t where poid_id0 = :1") FAILED err=1(PIN_ERR_NO_MEM)
E Wed Mar 5 00:00:00 2014 xxxx dm:14343 @(#)$Id: dm_audit.c /cgbubrm_7.3.2.rwsmod/8 2013/01/17 00:57:40 ssajjans Exp $:3515 1:OBISIGNA-AR2:CustomerCenter:0:AWT-EventQueue-0:62:1383855126:0
audit_expanded_object: op_robj() failed, 43
E Wed Mar 5 00:00:00 2014 xxxx dm:14343 @(#)$Id: dm_audit.c /cgbubrm_7.3.2.rwsmod/8 2013/01/17 00:57:40 ssajjans Exp $:3320 1:OBISIGNA-AR2:CustomerCenter:0:AWT-EventQueue-0:62:1383855126:0
audit_object_create: audit_expanded_object failed, err 43
E Wed Mar 5 00:00:00 2014 xxxx dm:14343 dm_if_oracle.c(177):7477 1:OBISIGNA-AR2:CustomerCenter:0:AWT-EventQueue-0:62:1383855126:0
TRANS_COMMIT: audit_object "commit" failed, err=98(PIN_ERR_AUDIT_COMMIT_FAILED)
E Wed Mar 5 00:00:00 2014 xxxx dm:14343 dm_back.c(31):1440 1:OBISIGNA-AR2:CustomerCenter:0:AWT-EventQueue-0:62:1383855126:0
DMbe #0: process_op: op 14(PCM_OP_TRANS_COMMIT), err 98(PIN_ERR_AUDIT_COMMIT_FAILED)

 

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