OPI_EDW_OPM Objects Invalid (Doc ID 2248980.1)

Last updated on MARCH 28, 2017

Applies to:

Oracle Process Manufacturing Systems - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

Could you please validate why those below objects are invalid after the patch applied
Patch : 25023844

Errro in below packages :
Body 22 4 PL/SQL: ORA-00942: table or view does not exist

Reason: Can not find this object referenced in the below packages.

edw_local_instance@edw_apps_to_wh



OWNER OBJECT NAME OBJECT TYPE CREATED ON LAST DDL
APPS OPI_EDW_OPMCOGS_F_C PACKAGE BODY 02-AUG-2015 04:32:36 24-FEB-2017 07:48:15
APPS OPI_EDW_OPM_JOB_DETAIL_F_C PACKAGE BODY 02-AUG-2015 04:32:36 24-FEB-2017 07:48:15
APPS OPI_EDW_OPMINV_DAILY_STAT_F_C PACKAGE BODY 02-AUG-2015 04:32:53 24-FEB-2017 07:48:15
 

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