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 SEPTEMBER 07, 2016

Applies to:

Oracle Application Install - 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 MSC_CL_PULL 69,903 0 PACKAGE BODY 36660.96258 41169.70169 2012-09-17:16:50:26 INVALID N N N 2

APPS 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 RLM_RD_SV 72,511 0 PACKAGE BODY 36660.99382 41169.7026 2012-09-17:16:51:45 INVALID N N N 2
APPS RLM_EXTINTERFACE_SV 72,519 0 PACKAGE BODY 36660.99405 41169.70171 2012-09-17:16:50:28 INVALID N N N 2

APPS 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 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 ASO_SECURITY_INT 214,980 0 PACKAGE BODY 37554.7872 41169.70433 2012-09-17:16:54:14 INVALID N N N 2
APPS 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 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 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

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