My Oracle Support Banner

R12: AP: Payments Workbench Error: ORA-01403 No Data Found (Doc ID 1303129.1)

Last updated on APRIL 27, 2023

Applies to:

Oracle Financials for the Americas - Version 12.0.3 and later
Oracle Payables - Version 12.0.3 to 12.1.3 [Release 12.0 to 12.1]
Oracle Payables - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.
Form:APXPAWKB.FMB - Payment Workbench


The purpose of this note is to explain steps in diagnosing and troubleshooting the ORA-01403 database error in the EBS Payables module, payment workbench.  This note attempts to step the reader through all known setup issues as well as known bugs that can cause this error to occur. 

"ORA-01403 No Data Found" errors in Payments Workbench


Troubleshooting Steps

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
Troubleshooting Steps
      1) Payment Entry
      2) Void / Refund / Reissue
      3) Querying Payments
      4) Invoice Selection
      5) Opening Form
      6) Downloading/Exporting to Excel

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