ALM Process Fails With 'ORA-01403: no data found' After Procedure 'ofsa_sql.tm_truncate_table' (Doc ID 2880804.1)

Last updated on OCTOBER 31, 2023

Applies to:

Symptoms

When running the ALM Processes after upgrading to ALM 8.1, you get an ORA-01403 in the Calculation Engine log:

Module Logging OFS Access module data: declare begin ofsa_sql.tm_truncate_table('<ATOMIC USER>',
'RES_DTL_365154'); end; 


Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [34] - PL/ SQL EXECUTE Oracle Error: ORA-
01403: no data found ORA- 06512: at "<ATOMIC USER>.OFSA_DBA", line 1430
ORA- 06512: at "<ATOMIC USER>.OFSA_DBA", line 1998 ORA- 06512: at
"<ATOMIC USER>.OFSA_SQL", line 271 ORA- 06512: at line 1 Driver Function:
drv_oci::Execute() SQL Statement: declare begin
ofsa_sql.tm_truncate_table('<ATOMIC USER>', 'RES_DTL_365154'); end; 

and

Module Logging OFS Access module data: declare begin ofsa_sql.tm_truncate_table('<ATOMIC USER>',
'CONS_DTL_365154'); end; 


Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [34] - PL/ SQL EXECUTE Oracle Error: ORA-
01403: no data found ORA- 06512: at "<ATOMIC USER>.OFSA_DBA", line 1430
ORA- 06512: at "<ATOMIC USER>.OFSA_DBA", line 1998 ORA- 06512: at
"<ATOMIC USER>.OFSA_SQL", line 271 ORA- 06512: at line 1 Driver Function:
drv_oci::Execute() SQL Statement: declare begin
ofsa_sql.tm_truncate_table('<ATOMIC USER>', 'CONS_DTL_365154'); end; 

As a result, the ALM Process fails to generate any results.

Cause

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