My Oracle Support Banner

R12: AP/IBY/POS: Suppliers Created Via API Cause Format Payment Instructions to Fail with "java.sql.SQLException: ORA-31061: XDB error: special char to escaped char conversion failed" (Doc ID 2974422.1)

Last updated on OCTOBER 31, 2023

Applies to:

Oracle Payments - Version 12.0.0 and later
Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to format a payment batch the following error occurs for suppliers created via API

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

To run a Payment Process Request (PPR):

  1. From a Payables Responsibility go to Payments -> Entry -> Payments Manager
  2. Click on "Submit a Single Payment Process Request"
  3. Fill out the information and click submit

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.