Error 'ORA-00942: table or view does not exist' and 'FRM-40505: ORACLE error: unable to perform query' Happen when Attempting to Query PO or Supplier in Receipts (RCVRCERC) Form
(Doc ID 2548429.1)
Last updated on SEPTEMBER 06, 2021
Applies to:
Oracle Inventory Management - Version 12.2.6 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.6 version, Receiving Functions
When attempting to search PO or supplier in Receipts form after upgraded from 11i to R12.2.6,
the following error occurs.
ERROR
-----------------------
ORA-00942: table or view does not exist
FRM-40505: ORACLE error: unable to perform query
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Upgraded from 11i to R12.2.6.
2.Login EBS Application>Receiving>Receipts.
3.Query using Purchase Order number or Supplier information, then get below error:
ORA-00942: table or view does not exist
FRM-40505: ORACLE error: unable to perform query
4.Close the window and try to search again by using data range or item, then no error happens.
Changes
Upgrade from 11i to R12.2.6
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 |