This content has been marked as final. Show 5 replies
After upgrading the rpd from 22.214.171.124 to 126.96.36.199.4 the default values in init blocks gets appended by a character 'd' even though the dynamic variable is of nature integer and not varchar. Has anyone faced this issue and found any resolution?
I'm fighting the same issue right now. Working a SR with Oracle, will update this if / when we find a resolution.
Hi Scott, Did u get an update from Oracle on character "d" issue?
Please let me know. Even we are facing the same issue.
For this issue, Development had suggested to upgrade to 188.8.131.52.7, after which our issue got resolved.
Oracle (FINALLY) got back to me with a fix - but not to upgrade to 184.108.40.206.7 (which fixed the earlier posters issue, I'll have to try it).
Instead, they suggested changing the SQL from something like:
select max(fiscal_year) from blah
select cast(max(fiscal_year) as number(4,0)) from blah
the number(4,0) means to return no decimal places, which then appears to make OBIEE behave properly.
Hope this helps,