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 laterInformation in this document applies to any platform.
Symptoms
Multiple Database objects are showing as invalid in the SOA DB?
-------------------- ----------------------- ------------------------------ ---------- ----------------- -----------------
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 |