GLXIQFUN.fmb : Funds Inquiry error: APP-FND-01564: ORACLE error 1422 in FDFGCD when Viewing Duplicate Summary Account
Last updated on MAY 02, 2018
Applies to:Oracle Public Sector Financials - Version 12.2 and later
Oracle General Ledger - Version 12.2 and later
Information in this document applies to any platform.
On : 12.2.5 version, Setup forms and programs
Duplicate code combination each with a different code combination id (CCID) are created for summary accounts for different ledgers.
There should not be any duplicate code combinations.
The issue can be reproduced at will with the following steps:
1. Go to General ledger Responsibility
2. Setup > Account > Combination
When querying account in Funds Inquiry following error appears 'FDFGCD failed due to ORA-01422: exact fetch returns more than requested number of rows.
Create two summary templates for the same code combination and chart of accounts (COA) for two different ledgers. This creates two code combinations with different CCID and template ID, one for each ledger in the same COA.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms