ORA-00913: too many values & ORA-01403: no data found Errors while Executing T2T in Direct Load Mode
(Doc ID 2544056.1)
Last updated on JULY 29, 2024
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.5 and laterInformation in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Symptoms
On 8.0.5 version, ORA errors are received in log while executing T2T in Direct Load mode:
Task itself is successful. All the source records are successfully loaded as per log information:
Log Message here 1: Mon 04 Mar 2019 11:47:17 AM IST||DEBUG||Back from loader: rows loaded ->1849
Log Message here 1: Mon 04 Mar 2019 11:47:17 AM IST||DEBUG||Back from loader: rows rejected->0
Same T2T is executing successfully when Batch or Bulk load mode is used for the same data.
ERRORS
ORA-01403: no data found
ORA-00913: too many values
STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
1. Run T2T in Direct load mode.
2. Check T2T log for errors.
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 |