Decimal Conversion Error. PowerBuilder supports only 18 digits

Hi,

I have been struggling with this error for a while now,

I have a window with multiple DataWindows in a tab object.

whenever I look up any value I get the attached error. When I click ok I get the other attached system error

The system error refers to this:

This.il_sqldbcode = sqldbcode

This.is_sqlerrtext = this.of_ParseSqlErrText(sqlerrtext)

Choose Case buffer

Case Delete!

ls_ApprovalType = This.Object.approval_type.Delete.Original [row]

Case Filter!

ls_ApprovalType = This.Object.approval_type.Filter.Original [row]

Case Primary!

ls_ApprovalType = This.Object.approval_type.Primary.Original [row] // LINE 14

End Choose

I had a look at the dw_otherdetail and all decimal fields are either type decimal(0) or decimal(2) I looked directly at the database tables and there are no values with a lot of decimal places. plus it happens for all of my searches.

I also tried to use the debugger but everything stops when the error is thrown and it wont let me go through and analyse the debug data.

Any help is greatly appreciated. Feel free to let me know if I need to provide more details on anything, not really sure where I should be looking...

I am using powerbuilder 12.5 Classic Database is an ORA ORACLE connection.