My Oracle Support Banner

GTAS Activity Balance Creation Process Fails With 'ORA-01422: exact fetch returns more than requested number of rows' (Doc ID 2253671.1)

Last updated on MARCH 04, 2019

Applies to:

Oracle U.S. Federal Financials - Version 12.1.3 and later
Information in this document applies to any platform.
GTAS

Symptoms

NOTE: In the images below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Activity Balance Creation has the following error

----------------------------
Start Process loop:
source: Payables cat: Purchase Invoices
reference1: 2: 3: 5:12345 7: 1234567
je batch id:12345 header id: 123456 line num: 2
je from sla flag Y
account: 12345.01.01 fund: X000.0000.4161M sgl: 12345 amount: 12.37
Begin fv.plsql.FV_GTAS_GL_PKG.GET_USSGL_ACCT
Account num: 12345.01.01 does not exist in gtas attributes. Using sgl account num: 12345
Begin: fv.plsql.FV_GTAS_GL_PKG.GET_TP_ATTRIBUTES
Begin
fv.plsql.FV_GTAS_GL_PKG.GET_PARTY_INFO_R12-When others error: ORA-01403: no data found
**Ends**
fv.plsql.FV_GTAS_GL_PKG.GET_PARTY_INFO_R12-When others error: ORA-01403: no data found
+---------------------------------------------------------------------------+

 

Changes

 

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.