After Upgraded to R12, When Querying Transaction Types, Error: APP-FND-01564: ORACLE Error 942 In FDFGVD
(Doc ID 2277483.1)
Last updated on FEBRUARY 09, 2018
Applies to:
Oracle Receivables - Version 12.0.0 and laterInformation in this document applies to any platform.
Symptoms
After upgrading from 11i to R12, the error occur when trying to review the Transaction types
Steps to Reproduce
- Upgrade from 11i to R12
- Open Transaction Types window, Receivables Manager -> Setup ->Transactions - >Transaction Types.
- F11 and ctrl+F11
- the following error arise
APP-FND-01564: ORACLE error 942 in FDFGVD
Cause: FDFGVD failed due to ORA-00942: table or view does not exist.
The SQL statement being executed at the time of the error was: SELECT LOOKUP_CODE,MEANING VALUE, MEANING DESCRIPTION, NVL('N', 'N'), NVL(TO_NUMBER(NULL), -1), NULL,
NVL('Y', 'Y'), NVL(TO_CHAR(TO_DATE(NULL), 'J'), 0), NVL(TO_CHAR(TO_DATE(NULL), 'J'), 0) FROM AX_LOOKUPS AX_LOOKUPS WHERE ( LOOKUP_TYPE = 'AX_YES_NO') AND LOOKUP_CODE = :X and was executed from the file &ERRFILE.
Cause: FDFGVD failed due to ORA-00942: table or view does not exist.
The SQL statement being executed at the time of the error was: SELECT LOOKUP_CODE,MEANING VALUE, MEANING DESCRIPTION, NVL('N', 'N'), NVL(TO_NUMBER(NULL), -1), NULL,
NVL('Y', 'Y'), NVL(TO_CHAR(TO_DATE(NULL), 'J'), 0), NVL(TO_CHAR(TO_DATE(NULL), 'J'), 0) FROM AX_LOOKUPS AX_LOOKUPS WHERE ( LOOKUP_TYPE = 'AX_YES_NO') AND LOOKUP_CODE = :X and was executed from the file &ERRFILE.
Changes
Upgrade to R12
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 |