materialized view Created without outer join though in line logical view has outer join
Hello,
Upgrading from 12.1.3 to 12.2.8 in this process we found that few materialized are not querying data,
After investigating Inline view has Outer joins and MV not framed with Outer joins
1.Following :
Developing and Deploying Customizations in Oracle E-Business Suite Release 12.2 (Doc ID 1577661.1)
2.Create a new Materialized View
3.Run the following script to check MV.
$AD_TOP/sql/ADZDSHOWMV MVIEW_NAME - Show materialized view information and related objects.
4.Below is the output:
 MV Objects
=========================================================================
OBJECT_NAMEÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â OBJECT_TYPEÂ Â Â Â Â Â Â Â Â Â Â Â STATUSÂ Â Â Â DESCRIPTION
------------------------------ ----------------------- ---------- -----------------
XXITRON_TEST_MVÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â MATERIALIZED VIEWÂ Â Â Â Â Â VALIDÂ Â Â Â Â Materialized View
XXITRON_TEST_MVÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â TABLEÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â VALIDÂ Â Â Â Â Container Table
XXITRON_TEST_MV#Â Â Â Â Â Â Â Â Â Â Â Â Â Â VIEWÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â VALIDÂ Â Â Â Â Logical View