Analytics Software

Hi,

I have made one calculation column in BMM layer logical table. Below is that

EVALUATE('XXBG_PL_PROJ_ANALYSIS_AFE_PKG.GET_COMM_VALUE_PTD(%1,%2,%3,%4)', '"XXBG Projects"."AFE CostComm Fact"."AFE_ID"', '"XXBG Projects"."AFE CostComm Fact"."PERIOD"', '"XXBG Projects"."AFE CostComm Fact"."DATA_SEL"', '"XXBG Projects"."AFE CostComm Fact"."ORG_ID"')

But whenever try to run this from answers the below error appears:

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 1722, message: ORA-01722: invalid number at OCI call OCIStmtFetch. [nQSError: 17012] Bulk fetch failed. (HY000)
SQL Issued: SELECT "AFE CostComm Fact".AFE_NUMBER saw_0, "AFE CostComm Fact".AFE_DESC saw_1, "AFE CostComm Fact".COMM_THIS_PERIOD_AFE saw_2 FROM "XXBG Projects" ORDER BY saw_0, saw_1, saw_2


The XXBG_PL_PROJ_ANALYSIS_AFE_PKG.GET_COMM_VALUE_PTD is a custom database pkg.function which I am trying to use in RPD. The function return type is Number in database. But I checked in BMM layer the logical calculation field automatically saved as CHAR & says data type derives from physical sources.

Can anyone please help me to solve this issue.

Thanks