Application Of OMIPM-3-3-19-5-0 Invalidated View V_DA_GL_E_GL_SUMMARY_TXN

(Doc ID 2029905.1)

Last updated on JULY 20, 2015

Applies to:

Oracle Media Intellectual Property Management - Version to [Release 3.3.0]
Information in this document applies to any platform.


On : version, Framework

The view does not compile and gives : ORA-00918: column ambiguously defined

Although this view is not in use, it does show as invalid in the database, so a solution is needed for getting it to compile cleanly. OMIPM-3-3-19-6-0 did not fix the view.

It looks like column MASTER_ENTITY_SYS_ID comes from multiple tables and is not prefixed.
The patch log shows the view coming from the file: dev/views/adhocreports/V_DA_GL_E_GL_SUMMARY_TXN.sql

The view should be compiled successfully without any errors.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms