My Oracle Support Banner

Reserved Words Could Cause Non-Linkable Queries in the Data Model (Doc ID 412447.1)

Last updated on MAY 08, 2020

Applies to:

Oracle Reports Developer - Version to [Release Oracle9i to 10gr2]
Information in this document applies to any platform.
This problem can occur on any platform.


A simple testcase based on the sample schema:

  1. Open Reports Builder and create a new report manually.
  2. Go to Report Editor - Data Model.
  3. Create a simple SQL Query in the Data Model like:
    select deptno from dept;
  4.  Create the second SQL Query in the Data Model using query below . Notice this second query will have a small icon in its title bar and a symbol like C/D. 

    select deptno case from emp;
  5. Try to create a Data Link (a column-to-column link) between the two columns of these queries.
  6. You get the warning message :
      "Cannot implement column link for this detail SQL query . Converting to group link"
    Press 'Yes' button.
  7. You can see the link in the Data Model, but the Property Inspector for this link shows that the parent and the child columns have not been included.


The problem cannot be reproduced in Reports 6i (6.0.8..x) .


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.