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:

Symptoms

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:

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

Cause

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