My Oracle Support Banner

Invalid Objects in SOA Schemas (Doc ID 2370657.1)

Last updated on OCTOBER 19, 2023

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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