REP-300, REP-0069 and REP-57054

Recently my client started to implement oracle contract. They noticed that custom program to print contract invoices failed with following 3 errors

REP-0300: ORACLE error occurred.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:


I tried to debug the report, ran all queries from sql developers, no issues. Added exception clauses to all the procedures that did not have any exception clause. Still it did not help. I noticed that there are very few invoices that have string value in interface_line_attribute6 column of ra_customer_trx_lines_all table. So i set interface_line_attribute6 to null for one invoice and that invoice printed fine. Then i converted rdf file to xml and searched for interface_line_attribute6 and i found it used in few procedures and in multiple queries in data model. I noticed that report is using functions in select list and interface_line_attribute6 was being passed to 2 functions. Those functions were expecting a number value, when character value was passed to those function calls, it must be generating following error but this error was not visible in report log file or trace file for report.

ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line NNNNNNNN
06502. 00000 - "PL/SQL: numeric or value error%s"


So i replaced use of ---->>>> lines.interface_line_attribute6

with following line

decode(translate(lines.interface_line_attribute6,'X1234567890','X'),null,lines.interface_line_attribute6,-1)

Interface_line_attribute6 normally points to sales order line for OM order invoices.