Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Column aliasing issue with Direct Print Option
Migrateduser
Hi All,<br />
<br />
I've developed a report and configured a Direct Print option, but the query fails to return resultset with an exception <strong class='bbc'>ORA-00918: column ambiguously defined</strong>. Query is based on woactivity & workorder, one of the column is common in both the tables. <br />
<br />
This issue is occurred only when it is configured as Direct Print, but when it is run from Run Reports it is returning result set with no issues. <br />
<br />
What I've observed is it is framing a query internally to identify the persongroup of the user running the report, but it is no aliasing the column with WORKORDER as "workorder.abccolumn"<br />
<br />
Could someone let me know, how to overcome this issue. Also please shed some light from where this extra bit of query gets build. <br />
<br />
Thanks,<br />
Suresh.
Find more posts tagged with
Comments
There are no comments yet