My Oracle Support Banner

R12: AP: ORA-01403: No Data Found FRM-40735 When Force Approval of Invoice by User Whose Full name is Same As Other User of the Same Organization (Doc ID 2886603.1)

Last updated on JULY 29, 2022

Applies to:

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


When a user, whose employee full name is duplicate, tries to Force Workflow Approval an Invoice via the Invoice Workbench, the following error raises:

ORA:01403: no data found
FRM-40735: DO_FORCE_APPROVAL trigger raised unhandled exception ORA-01422

ORA-1422: "exact fetch returns more than requested number of rows"
  // *Cause: The number specified in exact fetch is less than the rows returned.
  // *Action: Rewrite the query or change number of rows requested

FRM-40735 and ORA-01403 when Force Workflow Approval of a Payable Invoice.

The Force Approval requester is a user whose employee full name is duplicate within the same Organization.


Steps to reproduce:

  1. Log into Oracle Applications with a user name with Employee Full Name same as other, in the same Organization, and using a Payables responsibility.
  2. Open the Invoice Workbench screen
    (N) Invoices > Entry > Invoices
  3. Query the Invoice to approve.
  4. Click on the [Actions..] button
  5. In the "Invoice Actions" popup window, select/check option "Force Approval" and click [OK]
  6. You get the ERROR.

Here is a screen shot of the issue reproduced:


Applied <Patch: 32768426>


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.