My Oracle Support Banner

CTAS Fails with ORA-07445 [evaopn3()+272] With 'VIEW PUSHED PREDICATE' in Execution Plan (Doc ID 2957206.1)

Last updated on OCTOBER 06, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

NOTE: In the images, examples and document that follow, user details, cluster names, hostnames, directory paths, filenames, etc. represent a fictitious sample (and are used to provide an illustrative example only). Any similarity to actual persons, or entities, living or dead, is purely coincidental and not intended in any manner.


On 11.2.0.4 version with application related to EBS 12.1.3,

when attempting to execute Create Table As Select (CTAS) on customized objects related to objects MRP_PLAN_WO_END_DEMAND_V4
and MRP_PLANS_V in EBS
,

the following error occurs:

 

Changes

 

Cause

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
Symptoms
Changes
Cause
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.