My Oracle Support Banner

R12/FV: Classification Transactions & Accountability (CTA) Process is Ending in ORA-01422: exact fetch returns more than requested number of rows (Doc ID 2827373.1)

Last updated on FEBRUARY 13, 2022

Applies to:

Oracle U.S. Federal Financials - Version 12.2.8 and later
Information in this document applies to any platform.
Classification Transactions & Accountability (CTA)
FVCTATXB: CTA Process

Symptoms

When creating manual journal entries with transactions that should be picked up by the Classification Transactions & Accountability (CTA) process, the concurrent request ends in error.

ERROR in FND Log:     
fv.plsql.FV_CTA_TRANSACTIONS.VALIDATE_AGENCY_BETC ORA-01422: exact fetch returns more than requested number of rows
fv.plsql.FV_CTA_TRANSACTIONS.EXTRACT error: ORA-01422: exact fetch returns more than requested number of rows

STEPS TO REPRODUCE:
1. Create manual journal entries as instructed in (Doc ID 1943006.1)
2. Federal Financials > run FVCTATXB: CTA Process
3. See error in the logfile

Changes

After Patch 32908194 ADD FUNDING GROUP TO, BETC, AND TAS/BETC MAPPING FORMS

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


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