When Accessing List Of Values Accrual Reconciliation Report Shows Error APP-FND-01564: ORACLE error 942 in FDFGVD
(Doc ID 2653519.1)
Last updated on MARCH 28, 2020
Applies to:
Oracle Purchasing - Version 11.5.10.2 and laterInformation in this document applies to any platform.
Symptoms
On : 11.5.10.2 version, Accounting related
While attempting to run Accrual Reconciliation Report, it completes with the below error :
ERROR
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 GL_CODE_COMBINATIONS_KFV.CODE_COMBINATION_ID,GL_CODE_COMBINATIONS_KFV.CONCATENATED_SEGMENTS VALUE, GL_CODE_COMBINATIONS_KFV.CONCATENATED_SEGMENTS 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 GL_CODE_COMBINATIONS_KFV,PO_ACCRUAL_ACCOUNTS_TEMP_ALL WHERE ( PO_ACCRUAL_ACCOUNTS_TEMP_ALL.ACCRUAL_ACCOUNT_ID =GL_CODE_COMBINATIONS_KFV.CODE_COMBINATION_ID AND EXISTS ( SELECT 1 FROM CST_ORGANIZATION_DEFINITIONS WHERE CST_ORGANIZATION_DEFINITIONS.OPERATING_UNIT =PO_ACCRUAL_ACCOUNTS_TEMP_ALL.ORG_ID AND CST_ORGANIZATION_DEFINITIONS.OPERATING_UNIT =:b1 AND GL_CODE_COMBINATIONS_KFV.CHART_OF_ACCOUNTS_ID =CST_ORGANIZATION_DEFINITIONS.CHART_OF_ACCOUNTS_ID ) ) AND GL_CODE_COMBINATIONS_KFV.CONCATENATED_SEGMENTS = :X and was executed from the file &ERRFILE.
STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
1. Navigate to Purchasing Responsibility
2. Run the Accrual Reconciliation Report
3. It shows the above error while accessing list of Values
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 |
Cause |
Solution |
References |