My Oracle Support Banner

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 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.
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!


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