My Oracle Support Banner

OPI_EDW_OPM Objects Invalid (Doc ID 2248980.1)

Last updated on APRIL 04, 2025

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

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


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