My Oracle Support Banner

R12: AP/IBY: Format Payment Instructions With Text Output using US NACHA CCDP Format Fails with "Caused by: oracle.xdo.parser.v2.XPathException: Cannot convert - to number" (Doc ID 2946122.1)

Last updated on JUNE 29, 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.


When trying to format a Payment Process Request (PPR) using the "US NACHA CCDP" format the "Format Payment Instructions with Text Output" program fails with:

Caused by: oracle.xdo.parser.v2.XPathException: Cannot convert - to number.
Error: an error occurred during formatting. Please verify the template is valid.
oracle.apps.iby.exception.PSException: Internal Error to Payment Server:

To setup a Payment Process Profile to use the "US NACHA CCDP" format

  1. From a payables responsibility navigate to Setup -> Payment -> Payment Administrator -> Payment Process Profiles
  2. Click on the "Create" button
  3. Fill in all the information needed and for format choose "US NACHA CCDP"
  4. Save

To setup a supplier bank such that it will cause the error when formatting:

  1. From a payables responsibility navigate to Suppliers -> Entry
  2. Query up a supplier
  3. Click on the update icon
  4. Click on Banking Details
  5. Set the "Select Account Assignment Level" pull down to "Site"
  6. Enter in a site name
  7. Click "Go"
  8. Click "Create"
  9. Enter a valid "Bank Name"
  10. Check the "Create New Branch" radio button
  11. Enter a branch name
  12. Enter in a non-numeric branch number (e.g A123)
  13. Enter in an Account Number, Name, and Currency

To create an invoice:

  1. From a payables responsibility navigate to Invoices -> Entry -> Invoices
  2. Fill in the header information using the supplier created with the non-numeric bank branch
  3. Be sure remit-to bank account field is populated with the bank account with the non-numeric bank branch.
  4. Fill in the line details
  5. Click "Actions"
  6. Check the "Validate" checkbox
  7. Click "Go"

To submit a Payment Process Request (PPR):

  1. From a payables responsibility navigate to Payments -> Entry -> Payment Manager
  2. Click on "Submit Single Payment Process Request"
  3. Fill out all the information on the various tabs, on the "Payment Attributes" tab be sure to choose the Payment Process Profile created to use the "US NACHA CCDP" format


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

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