APEX

Hi, I'm new to APEX and while building my first app have hit this error: ORA-00001: unique constraint (APEX_030200.WWV_FLOW_WORKSHEET_COLUMNS_UK2) violated Error creating region.

This occurs when I try to add an Interactive Report region to a new page. I am pasting some sql that I created in the Query Builder. If I paste the sql into a new SQL Report it works ok! I just want the Interactive Report features available.

During the interactive report creation I have to chose the "Uniquely Identify Rows by" and the default is "ROWID", if I leave this then the above error occurs, if I select "Unique Column" and enter my primary key from the sql I get an error: "The report query needs a unique key to identify each row. The supplied key cannot be used for this query. Please define a unique key column. ORA-00904: "CONID": invalid identifier" If I then surround my primary key with quotes "conid" I then get the error at the top of this thread.

I am new to sql/oracle and have apparently made mistakes with my table design by using mixed case names for columns, not sure if this is adding to my problems!

My sql is as follows:

select "CS_CONTRACT"."conid" as "conid",
"CS_CONTRACT"."conEmpNo" as "conEmpNo",
"CS_PERSON"."perSname" as "perSname",
"CS_PERSON_1"."perSname" as "perSname",
"CS_DATA"."dtText" as "dtText"
from
"CS_DATA" "CS_DATA",
"CS_PERSON" "CS_PERSON_1",
"CS_PERSON" "CS_PERSON",
"CS_CONTRACT" "CS_CONTRACT"
where "CS_CONTRACT"."CONPERSON"="CS_PERSON"."perid"(+)
and "CS_CONTRACT"."conPOadmin"="CS_PERSON_1"."perid"(+)
and "CS_CONTRACT"."conSkill"="CS_DATA"."dtid"(+)

Any Help would be much appreciated

Thanks