Package Body ''Scm_admin.Jr_reg_io'' Has Errors After Database Server Upgrade (Doc ID 353815.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Repository - Version: 9.0.4.6
This problem can occur on any platform.

Symptoms

Oracle Repository Object Navigator returns the folowing errors
while trying to check out any source file:
ORA-04063: ORA-04063: package body "SCM_ADMIN.JR_REG_IO" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"SCM_ADMIN.JR_REG_IO"
ORA-06512: at "SCM_ADMIN.JR_FOLDER", line 535
ORA-06512: at "SCM_ADMIN.JR_OBJECT_VERSION", line 251
ORA-06512: at "SCM_ADMIN.SDD_FILES_AR", line 4
ORA-04088: error during execution of trigger 'SCM_ADMIN.SDD_FILES_AR' has
errors
Package body "SCM_ADMIN.JR_REG_IO" has Status "INVALID"


Changes

For security reasons the UTL_FILE  in SYS of the database was set to private instead of Public

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms