Many missing views in EHP8 (oracle 12c)

[former_member459694]

Hello,

I have installed ECC6.0 EHP8 on Windows Server 2012R2, Oracle 12c, after installation, i found there are lots of views are missing in database level, only exists in DDIC, in DB02, I can see lots of red alert indicates the views are not exists on DB, I have to create them manually one by one through SE14, I have two questions here:

1. Is there a way to batch creating the view on database level?

2. Is it a bug of EHP8? why so many views doesn't exists? I tried to search for notes but seems no one so far.

Thanks a lot.

Fresh

[Sriram2009]

Hi Fresh.

First you have to check with function consultant / ABAPer to find the reason for missing view's and then you can take the action based on the SAP Notes which already mention by Prithviraj.

Regards

SS

[Former Member]

Hi Fresh Man,

I will suggest you open a message with SAP and take their response before creating them manually.

Thanks,

Manas

[Former Member]

Hi

Check below sapnotes

2198254 - After upgrade, DB02 shows missing views in the database

1897516 - Missing tables on the database after upgrade to ERP 6.0 (ECC 6.0)

1870843 - Missing Tables and Indexes - How to edit exceptions

Regards,

Prithviraj.