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

Last updated on MARCH 19, 2019

Applies to:

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

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