FVBEINTB The Budget Execution Transactions Import Process fails with ORA-01422 exact fetch returns more than requested number of rows. (Doc ID 2036897.1)

Last updated on DECEMBER 07, 2015

Applies to:

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

Symptoms

On : 12.2.3 version, Federal Setup

When attempting to run FVBEINTB module: Budget Execution Transactions Import Process the following error occurs.

ERROR
------------
ORA-01422: exact fetch returns more than requested number of rows :When others error while validating expire/cancel date for treasury symbol


FND_LOG_MSGS
------------------
fv.plsql.FV_BE_INT_PKG.MAIN. ------------------------------------------------
fv.plsql.FV_BE_INT_PKG.MAIN. START VALIDATING REC#: 14840253
fv.plsql.FV_BE_INT_PKG.MAIN. VALIDATING SET OF BOOKS ID: 1
fv.plsql.FV_BE_INT_PKG.MAIN. VALIDATING GL DATE: 08-JUN-15
fv.plsql.FV_BE_INT_PKG.MAIN. VALIDATING BUDGET LEVEL ID: 4
fv.plsql.FV_BE_INT_PKG.MAIN. VALIDATING BUDGET USER: 26612
fv.plsql.FV_BE_INT_PKG.MAIN. VALIDATING BUDGET USER ACCESS : 26612 Budget
Level Id => 4
fv.plsql.FV_BE_INT_PKG.MAIN. VALIDATING FUND VALUE: 08028520151DA0
fv.plsql.FV_BE_INT_PKG.MAIN. Validating Treasury Symbol date for fund value: 08028520151DA0
fv.plsql.FV_BE_INT_PKG.validate_tsymbol_date.final_exception ORA-01422: exact
fetch returns more than requested number of rows :When others error while
validating expire/cancel date for treasury symbol
fv.plsql.FV_BE_INT_PKG.validate_tsymbol_date ORA-01422: exact fetch returns
more than requested number of rows :WHEN OTHERS ERROR
         while validating expire/cancel date for treasury symbol
fv.plsql.FV_BE_INT_PKG.reset_control_status RESETTING STATUS IN THE CONTROL
TABLE
fnd.src.process.fdpwrt.fdpwrt.log_write **Ends**
fnd.src.process.fdpwrt.fdpwrt.log_write ORA-01422: exact fetch returns more
than requested number of rows :When others error while validating
expire/cancel date for treasury symbol
fnd.src.process.fdpwrt.fdpwrt.log_write
+---------------------------------------------------------------------------+


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into Federal Financials.
2. Run FVBEINTB module: Budget Execution Transactions Import Process.

Cause

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 hundreds of Community platforms