ORA- 01403: no data found ORA- 06512: at "OFSA_DBA", line 1430 Errors for CONS_DTL_XXXXX Tables Running Cash Flow Current Position for BSP (Doc ID 2147351.1)

Last updated on JUNE 26, 2024

Applies to:

Symptoms

On BSP 8.0.1, there are errors in the ofsrm debug logs in FusionApps when running current position for Total Bank.

ERROR

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 "<BSP SCHEMA>.OFSA_DBA", line 1430
ORA- 06512: at "<BSP SCHEMA>.OFSA_DBA", line 1998 ORA- 06512: at
"<BSP SCHEMA>.OFSA_SQL", line 271 ORA- 06512: at line 1 Driver
Function: drv_oci::Execute() SQL Statement: declare begin
ofsa_sql.tm_truncate_table('<BSP SCHEMA>', 'CONS_DTL_200800'); end;

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [34] - PL/ SQL EXECUTE Oracle Error: ORA-
00955: name is already used by an existing object ORA- 06512: at
"<BSP SCHEMA>.OFSA_DBA", line 1347 ORA- 06512: at "<BSP SCHEMA>.OFSA_DBA",
line 2366 ORA- 06512: at "<BSP SCHEMA>.OFSA_SQL", line 398 ORA- 06512:
at line 1 Driver Function: drv_oci::Execute() SQL Statement:
declare begin ofsa_sql.clone_all_indexes('<BSP SCHEMA>',
'CONS_DTL_200800', 'FSI_O_CONS_DETAIL_TEMPLATE', '200800'); end;

Module Logging OFS errors: (203105) Oracle drv_oci error: Disconnect: Not all ORACLE driver
copies destroyed!

It appears to have successfully imported results into Essbase but with some errors as noted.
The CONS_DTL_200800 table exists but is created with no results.
RES_DTL has data and the results appear in BSP.

The issue can be reproduced at will with the following steps:
1. Run current position for total bank

Changes

 Upgraded from BSP 6.1.

Cause

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