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 laterInformation in this document applies to any platform.
Symptoms
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: 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:
- Log into Oracle Applications with a user name with Employee Full Name same as other, in the same Organization, and using a Payables responsibility.
- Open the Invoice Workbench screen
(N) Invoices > Entry > Invoices - Query the Invoice to approve.
- Click on the [Actions..] button
- In the "Invoice Actions" popup window, select/check option "Force Approval" and click [OK]
- You get the ERROR.
Here is a screen shot of the issue reproduced:
Changes
Applied <Patch: 32768426>
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 |
Changes |
Cause |
Solution |
References |