Load_pin_beid Truncates The Resource Name If A Numerical Value Is Added In The End (Doc ID 1662657.1)

Last updated on DECEMBER 04, 2015

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.

Goal

When loading beid, the load_pin_beid utility truncates the resource name and fills the PIN_FLD_VALIDITY_IN_DAYS field with a bad value, when the resource name ends with numerical digits.

For example :

Consider the following resource definition in the pin_beid file :

1000111 0       0       0.000000        0.000000        0.000000        GPRS  VOLUM   *       2       0       0       10 MB FREE FEB 2010

After loading this resource using load_pin_beid, the result is that :

select name,validity_in_days from config_beid_balances_t where rec_id =1000111;

Actual
---------
"10 MB FREE FEB"  "2010"

Expected
---------
"10 MB FREE FEB 2010"  "366"

Note : In the resource definition , if the name is "10 MB FREE FEB2010"  instead of "10 MB FREE FEB 2010", then the result is correct.

Solution

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