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 3.3.19.0 to 3.3.19.0 [Release 3.3.0]
Information in this document applies to any platform.

Symptoms

On : 3.3.19.0 version, Framework

ACTUAL BEHAVIOR
---------------
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


EXPECTED BEHAVIOR
-----------------------
The view should be compiled successfully without any errors.

Cause

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