My Oracle Support Banner

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

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
Goal
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.