APEX

Hello,

I've just installed APEX 3.2 on an Oracle 9iR2 database.
I have the demo application (Application 101) installed, and am experiencing something strange.

The error is on "Page 1" (an interactive report and a dial chart). Specifically the issue seems to be with the "My Orders" region.

When running the application, I get the following:
ORA-20001: get_dbms_sql_cursor error ORA-01446: cannot select ROWID from view with DISTINCT, GROUP BY, etc.

The "My Orders" region's source is:
select
o.order_id,
o.order_timestamp,
u.user_name sales_rep,
o.order_total,
c.cust_last_name || ', ' || c.cust_first_name customer_name,
to_char(o.order_timestamp,'Month YYYY') order_month,
to_char(o.order_timestamp,'YYYY') order_year
from
demo_orders o,
demo_customers c,
demo_users u
where
o.customer_id = c.customer_id
and o.user_id = u.user_id
and (u.user_name = :APP_USER or :APP_USER = 'ADMIN')
order by o.order_total desc

The "Link Column" attributes for this region are:
Link Column => Link to Single Row View
Single Row View => Allow Exclude Null Values; Allow Displayed Columns
Uniquely Identify Rows by => ROWID
. . .

I should note that if I change the "Uniquely Identify Rows by" to the "ORDER_ID" column, then the report works as it should.
I would like to be able to use the ROWID in interactive reports, and not have to bind to primary keys.

Thanks for looking.

-Kris

Edited by: user2316919 on Dec 22, 2009 10:23 AM