My Oracle Support Banner

Unable to Add New Locales in the System (Doc ID 1144023.1)

Last updated on FEBRUARY 21, 2019

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 Oracle Communications Billing and Revenue Management (BRM) version 7.4.0.0.0, while updating an existing account to set the newly added Locale in the system, the following error is thrown:

nap(11357)> xop PCM_OP_CUST_SET_LOCALE 1 1
xop: opcode 66, flags 1
XOP "66" failed: err 46:PIN_ERR_BAD_VALUE, field 0/109:PIN_FLD_LOCALE,
loc 5:PIN_ERRLOC_FM, errclass 4:PIN_ERRCLASS_APPLICATION, rec_id 1, resvd 0
# number of field entries allocated 20, used 3
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 101813 0
0 PIN_FLD_FIELD ARRAY [0] allocated 20, used 4
1 PIN_FLD_FIELD_NUM ENUM [0] <NUMBER>
1 PIN_FLD_RESULT ENUM [0] 46
1 PIN_FLD_DESCR STR [0] "Bad value."
1 PIN_FLD_LOCALE STR [0] "hi_IN"
0 PIN_FLD_ERR_BUF ERR [0]
<location=PIN_ERRLOC_FM:5 class="PIN_ERRCLASS_APPLICATION":4 errno=PIN_ERR_BAD_VALUE:46>
<field num=PIN_FLD_LOCALE:5,109 recid=1 reserved=0 reserved2=0 time(sec:usec)=0:0>
<facility=0 msg_id=0 version=0>

Steps To Reproduce:

Consider the following scenario:

1. Add new locales to the locale_descr.en_US file

> diff locale_descr.en_US locale_descr.en_US.ORG
321,344d320
< STR
< ID = 41 ;
< VERSION = 1 ;
< STRING = "Chinese (Singapore)" ;
< HELPSTR = "zh_SG" ;
< END
< STR
< ID = 42 ;
< VERSION = 1 ;
< STRING = "Hindi (India)" ;
< HELPSTR = "hi_IN" ;
< END
< STR
< ID = 43 ;
< VERSION = 1 ;
< STRING = "Chinese ( China )" ;
< HELPSTR = "zh_CN" ;
< END
< STR
< ID = 44 ;
< VERSION = 1 ;
< STRING = "Testing ( Testing )" ;
< HELPSTR = "te_ST" ;
< END

2. Load the new locales:

> load_localized_strings -v locale_descr.en_US

3. verify new locales are loaded in the database:

SQL> select POID_ID0, DOMAIN, LOCALE, STRING_ID, STRING, HELP_STRING from strings_t where DOMAIN='Locale Descriptions - en_US' and STRING_ID like '4%';

POID_ID0   DOMAIN                         LOCALE                          STRING_ID STRING                         HELP_STRING
---------- ------------------------------ ------------------------------ ---------- ------------------------------ -----------
11311      Locale Descriptions - en_US    en_US                                  40 Spanish( Argentina )           es_AR
13046      Locale Descriptions - en_US    en_US                                   4 German( Switzerland )          de_CH
323525     Locale Descriptions - en_US    en_US                                  41 Chinese (Singapore)            zh_SG
319525     Locale Descriptions - en_US    en_US                                  42 Hindi (India)                  hi_IN
321573     Locale Descriptions - en_US    en_US                                  43 Chinese ( China )              zh_CN
320549     Locale Descriptions - en_US    en_US                                  44 Testing ( Testing )            te_ST

6 rows selected.


4. Update an existing account to set the new locale and the following errors were thrown:

> testnap
===> database 0.0.0.1 from pin.conf "userid"
nap(11357)> r testsetlocale 1
nap(11357)> d 1
# number of field entries allocated 20, used 3
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 101813 0
0 PIN_FLD_PROGRAM_NAME STR [0] "testnap"
0 PIN_FLD_LOCALES ARRAY [0] allocated 20, used 1
1     PIN_FLD_LOCALE STR [0] "hi_IN"

nap(11357)> xop PCM_OP_CUST_SET_LOCALE 1 1
xop: opcode 66, flags 1
XOP "66" failed: err 46:PIN_ERR_BAD_VALUE, field 0/109:PIN_FLD_LOCALE,
    loc 5:PIN_ERRLOC_FM, errclass 4:PIN_ERRCLASS_APPLICATION, rec_id 1, resvd 0
# number of field entries allocated 20, used 3
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 101813 0
0 PIN_FLD_FIELD ARRAY [0] allocated 20, used 4
1     PIN_FLD_FIELD_NUM ENUM [0] <NUMBER>
1     PIN_FLD_RESULT ENUM [0] 46
1     PIN_FLD_DESCR STR [0] "Bad value."
1     PIN_FLD_LOCALE STR [0] "hi_IN"
0 PIN_FLD_ERR_BUF ERR [0]
<location=PIN_ERRLOC_FM:5 class=PIN_ERRCLASS_APPLICATION:4 errno=PIN_ERR_BAD_VALUE:46>
<field num=PIN_FLD_LOCALE:5,109 recid=1 reserved=0 reserved2=0 time(sec:usec)=0:0>
<facility=0 msg_id=0 version=0>

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.