ALM Deterministic Process Fails With 'ORA-04063: package body "<atomic>.OFSA_DBA" has errors' (Doc ID 2774177.1)

Last updated on APRIL 21, 2023

Applies to:

Symptoms

On 8.0.5 version, ALM Deterministic process failed with ORA errors in process log.

ERRORS

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [12] - ofetch(),
ofen() SQL Function: [4] -
SELECT Oracle Error: ORA- 04063: package body "<atomic>.OFSA_DBA" has
errors ORA- 06508: PL/ SQL: could not find program unit being
called: "<atomic>.OFSA_DBA" ORA- 06512: at "<atomic>.OFSA_SQL", line 114
Driver Function: drv_oci::FetchNext() SQL Statement:
select ofsa_sql.table_exists('RES_DTL_XXXXXX')
from dual

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [34] - PL/ SQL EXECUTE Oracle Error: ORA-
04063: package body "<atomic>.OFSA_DBA" has errors ORA- 06508: PL/
SQL: could not find program unit being called: "<atomic>.OFSA_DBA"
ORA- 06512: at "<atomic>.OFSA_SQL", line 248 ORA- 06512: at line 1
Driver Function: drv_oci::Execute() SQL Statement: declare begin
ofsa_sql.tm_clone_table('<atomic>', 'FSI_O_RESULT_DETAIL_TEMPLATE',
'RES_DTL_XXXXXX', 0, '1024', '1024', 'XXXXXX', 'TM', '1', '105',
'20'); end;

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [34] - PL/ SQL EXECUTE Oracle Error: ORA-
04063: package body "<atomic>.OFSA_DBA" has errors ORA- 06508: PL/
SQL: could not find program unit being called: "<atomic>.OFSA_DBA"
ORA- 06512: at "<atomic>.OFSA_SQL", line 301 ORA- 06512: at line 1
Driver Function: drv_oci::Execute() SQL Statement: declare begin
ofsa_sql.drop_table('<atomic>', 'RES_DTL_XXXXXX'); end;

Changes

Data from atomic schema of ALM has been moved from other environment, for debugging purposes.

Cause

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