11i: AP: After 12c Database Upgrade, Quick Match Does Not Work, Get Error: FRM-40350: Query caused no records to be retrieved.
(Doc ID 2094783.1)
Last updated on JANUARY 03, 2023
Applies to:
Oracle Payables - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]Information in this document applies to any platform.
Symptoms
In Oracle eBusiness Suite (EBS) release 11.5.10.2, in the Accounts Payables (AP) invoice workbench, when using the Quick Match process to match an invoice to a purchase order (PO), no records are retrieved.
The 'Match to Purchase Orders' form does not return any record and throws this message:
FRM-40350: Query caused no records to be retrieved.
It is expected, that the Quick Match should return a result.
Steps to reproduce
The issue is reproduced with the following steps:
1. In the AP Invoice Workbench, Quick Match to Purchase Order (PO) # NNNNNN.
2. Enter invoice data.
3. Click Match.
4. The 'Match to Purchase Orders' form does not return any record and throws the above message.
Workaround
In 'Find Purchase Orders for Matching' form, search for Purchase Order # NNNNNN.
Result returned.
Select the result and click 'Match'. No issues.
Changes
1. Linux upgrade from Oracle Linux 5.6 to Oracle Linux 7.1 on DB server
2. Upgrade of database from 11.2.0.3 to 12c
3. Patches applied:
- EBS - 10350522 12539637 16289505 20621314 14707975
- Database - 19393542 19627012 20204035 20903906 21359755 21555660 21830241
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 |