3 Replies Latest reply on Sep 16, 2017 4:46 PM by Samya-Sourav - Senior Support Engineer -Oracle

    ORA-31061: XDB error: special char to escaped char conversion failed.


      We are using plsql package to generate an xml excel output using BI publisher to retrieve invoice details . The program is completing in error for one particular invoice date with the above error. We have almost 36k invoice line on that day.

      How to find out which invoice line has the special/junk characters in invoice line description column.

      Tried using this "REGEXP_REPLACE(nvl(AR_INVOICE_SQL_FUNC_PUB.get_description(trxl.customer_trx_line_id ), trxl.description), '[[:cntrl:]]', ',')  description" to replace the special character but the issue still persists.

      Please provide any pointers for the above issue.


      Thanks in advance,