My Oracle Support Banner

Materialized Views Must Not Depend On PLSQL Packages Or Functions: Apps.MRP_COMPANY_USERS_SN (Doc ID 2862198.1)

Last updated on SEPTEMBER 13, 2023

Applies to:

Oracle Materials Requirement Planning - Version 12.2 and later
Oracle Advanced Supply Chain Planning - Version 12.2 and later
Information in this document applies to any platform.

Goal

The customer is upgrading EBS from 12.1.3 to 12.2, before "Enabling Online Patching". Run the Online Patching Enablement - Readiness Reports ADZDPMAN.sql

IN SECTION-5:
MANUAL FIX: Materialized Views must not depend on PLSQL Packages or Functions
Owner MV Name Reference Owner Reference Object Name Reference Object Type
------------------------------ ------------------------------ -------------------- ------------------------------ ---------------------
APPS MRP_COMPANY_USERS_SN APPS FND_DATE PACKAGE

The customer is using MRP, ASCP, CP, so <Note 1982380.1> does not apply.

How should the customer resolve this violation?
 

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


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