JQL SQL conversion in when running an Enquiry

Hello T24ALL,

I've this error after running an LD L L (with @ID LK LD...)
[ERROR] 2016-12-16 09:46:30,770 [EX_117801658] DATABASE - SSELECT FBNK.LD.LOANS.AND.DEPOSITS$NAU WITH @ID LIKE "'LD'..." : Failed to execute statement : 'SELECT RECID FROM "FBNK_LD_LOANS_AND_D000" WHERE TO_NUMBER(RECID) LIKE ? ORDER BY RECID' ORA-01722: invalid number

Is accept that the problem is coming from the TO_NUMBER oracle function. I tried it with TT, FT the TO_NUMBER is not invocated and the Enquiries are running properly. The issue is happening also when it's ran from Browser.

Framework: TAFJ SP3
DB: Oracle12C
AS: JBOSS

Regards.

Hi
Maybe because (in my system at least) TT and FT have "L" formatting for @ID in the dictionary and LD has "25R". "R" formatting is usually interpreted as a numeric in T24.

Just tried with 25L, not it's not working...

You corrected the dictionary directly?

Yes, In a local environment, but it's not a real solution as for each rebuild of the SS the actual data are getting back

Hi
I didn't say it might be a real solution :))) The real solution would be to force Temenos to admit that it's their error; SS should be corrected by them.

Problem Solved, related to the TAFJ Version ...