GLXIQFUN.fmb : Funds Inquiry error: APP-FND-01564: ORACLE error 1422 in FDFGCD when Viewing Duplicate Summary Account
(Doc ID 2373267.1)
Last updated on FEBRUARY 03, 2019
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.
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