Application Of OMIPM-3-3-19-5-0 Invalidated View V_DA_GL_E_GL_SUMMARY_TXN
Last updated on JULY 20, 2015
Applies to:Oracle Media Intellectual Property Management - Version 22.214.171.124 to 126.96.36.199 [Release 3.3.0]
Information in this document applies to any platform.
On : 188.8.131.52 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