Invalid Objects in SOA Schemas

(Doc ID 2370657.1)

Last updated on MARCH 12, 2018

Applies to:

Oracle SOA Suite - Version 12.2.1.1.0 and later
Information in this document applies to any platform.

Symptoms

Multiple Database objects are showing as invalid in the SOA DB? 

OWNER OBJECT_TYPE OBJECT_NAME STATUS CREATED LAST_DDL_TIME

-------------------- ----------------------- ------------------------------ ---------- ----------------- -----------------
BMCRC PACKAGE BODY P$REPORT INVALID 11-SEP-2017 10:22 05-OCT-2017 17:44
SOA_SOAINFRA PACKAGE BODY TRS_BPEL INVALID 22-AUG-2017 00:43 05-OCT-2017 17:44
SOA_SOAINFRA PACKAGE BODY TRS_DEC INVALID 22-AUG-2017 00:43 05-OCT-2017 17:44
SOA_SOAINFRA PACKAGE BODY TRS_FAB INVALID 22-AUG-2017 00:43 05-OCT-2017 17:44
SOA_SOAINFRA PACKAGE BODY TRS_HWF INVALID 22-AUG-2017 00:43 05-OCT-2017 17:44
SOA_SOAINFRA PACKAGE BODY TRS_MED INVALID 22-AUG-2017 00:43 05-OCT-2017 17:44
SOA_SOAINFRA PACKAGE BODY TRS_SOA INVALID 22-AUG-2017 00:43 05-OCT-2017 17:44

 

Changes

The utl_recomp package was used to recompile invalid DB objects, but they still show as invalid after this was run successfully

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