After Upgrading From R12.1.1 To R12.1.3, There Are Some Invalid Objects on ASO, RLM, OPI, MSC..etc How to Fix this ?
(Doc ID 1493063.1)
Last updated on NOVEMBER 18, 2022
Applies to:
Oracle Applications DBA - Version 12.1.3 to 12.1.3 [Release 12.1]Information in this document applies to any platform.
Goal
Got many invalid objects after the upgrade from R12.1.1 to R12.1.3
OWNER OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_TIME TIMESTAMP STATUS TEMPORARY GENERATED SECONDARY NAMESPACE EDITION_NAME
APPS OWNER MSC_CL_PULL 69,903 0 PACKAGE BODY 36660.96258 41169.70169 2012-09-17:16:50:26 INVALID N N N 2
APPS OWNER RLM_MANAGE_DEMAND_SV 72,507 0 PACKAGE BODY 36660.99378 41169.7017 2012-09-17:16:50:27 INVALID N N N 2
APPS OWNER RLM_RD_SV 72,511 0 PACKAGE BODY 36660.99382 41169.7026 2012-09-17:16:51:45 INVALID N N N 2
APPS OWNER RLM_EXTINTERFACE_SV 72,519 0 PACKAGE BODY 36660.99405 41169.70171 2012-09-17:16:50:28 INVALID N N N 2
APPS OWNER ASO_QUOTE_HEADERS_PVT 92,681 0 PACKAGE BODY 36661.69 41169.70522 2012-09-17:16:55:31 INVALID N N N 2
APPS OWNER ASO_OPP_QTE_PUB 182,206 0 PACKAGE BODY 37406.90164 41169.70492 2012-09-17:16:55:05 INVALID N N N 2
APPS OWNER ASO_SECURITY_INT 214,980 0 PACKAGE BODY 37554.7872 41169.70433 2012-09-17:16:54:14 INVALID N N N 2
APPS OWNER ASO_QUOTE_PUB_W 215,001 0 PACKAGE BODY 37554.78971 41169.70466 2012-09-17:16:54:43 INVALID N N N 2
APPS OWNER ISC_EDW_BOOK_SUM1_F_C 185,038 0 PACKAGE BODY 37406.99205 39905.38465 2009-04-02:09:13:54 INVALID N N N 2
APPS OWNER OPI_EDW_OPMINV_DAILY_STAT_F_C 185,117 0 PACKAGE BODY 37407.00105 39905.37238 2009-04-02:08:56:14 INVALID N N N 2
Solution
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
| Goal |
| Solution |
| References |