Mviews in 12c database-ERP

[Satish]

Dear erman,

Thanks for all the support you provide.I need some clarification on materialized view creation.We have gone through the note I'd which you have provided earlier.

What we understand is we can create a custom mview using "evaluate using current edition" clause in 12c database instead of creating logical View and then deriving implementation query using a procedure.

Pls correct me if i am wrong

[Satish]

Also we wanted to know if we can create mview in apps schema.
Thanks erman

[ErmanArslansOracleBlog]

Yes, "evaluate using current edition" lets you avoid special development procedures ..

As the relevant MOS document says:

 Customers on Oracle Database 12.1 or later can use this approach to create custom materialized views, and in doing so, can avoid the special development procedures described immediately below; instead, they can review the subsequent section, Creating and Changing Custom Materialized Views on Oracle Database 12c.

[ErmanArslansOracleBlog]

As for your question -> "Also we wanted to know if we can create mview in apps schema. "

My answer is follow the document!

Developing and Deploying Customizations in Oracle E-Business Suite Release 12.2 (Doc ID 1577661.1)

"the MV definition is applied in the APPS schema."

[Satish]

Thanks erman,we have created mview in apps schema