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 APRIL 04, 2025
Applies to:
Oracle Public Sector Financials - Version 12.2 and laterOracle General Ledger - Version 12.2 and later
Information in this document applies to any platform.
GLXIQFUN.fmb
APP-FND-01564:
ORA-01422
Symptoms
On : 12.2.5 version, Setup forms and programs
ACTUAL BEHAVIOR
---------------
Duplicate code combination each with a different code combination id (CCID) are created for summary accounts for different ledgers.
EXPECTED BEHAVIOR
-----------------------
There should not be any duplicate code combinations.
STEPS
-----------------------
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.
Changes
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.
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 |