EBS 12.1.3 materialized view logs on Oracle EBS seeded tables

[sravan]

HI

EBS is on 12.1.3 .Can we  create materialized view logs on Oracle EBS seeded tables.

I found below for 12.2  but couldnt find any related document for 12.1.3

On an editioned database 12.2 environment, a materialized view (MV) definition currently may not reference editioned objects. This is known limitation of 12.2 environment (see below).

Follow the indication from below note , Section 1.4.3.5: Materialized Views, to create such materialized views:


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

Regards
Sravan
 

REFERENCES

[ErmanArslansOracleBlog]

EBS 12.2 is different.. We have Edition based redefition there.. In EBS 12.1.3 , we don't use that. So we "don't have that" EBR-related restriction in EBS 12.1.3..

"That" restriction -> Is It Supported To Create Materialised View Logs On Oracle HR Base Tables? (Doc ID 2322661.1)

[sravan]

So this means there is no restriction in 12.1.3 to  enable Materialized View Logs on  seeded tables

[ErmanArslansOracleBlog]

Seems so.
Give me some time.. I will make a research on this and I will update this thread.

[ErmanArslansOracleBlog]

Here is my last update.
It will work.. I mean you can put mv logs on standard tables in Ebs 12.1.3.

However, it will not be supported by Oracle, as it is a pure custom thing.