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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.