My Oracle Support Banner

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 MAY 14, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.5 and later
Information 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


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