You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI - Double to string conversion

edited Mar 13, 2018 6:17PM in Reporting and Analytics for HCM 5 comments

Content

I am creating a report having a column for "Initialized Balance". I need to show '-' if value is null otherwise show the value.

When I use like this IFNULL(CAST("Workforce Management - Accrual Real Time"."Incremental Plan"."Initialized Balance" as char(10)), '-') 

I am getting following error when there is a value. If  there is no value in the column and if it is null, it works. Please advise.

 

 
oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLException: java.io.IOException: execute query failed[nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 25137, message: ORA-25137: Data value out of range at OCI call OCIStmtFetch. [nQSError: 17012] Bulk fetch failed.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!