Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create block from many tables

NZKNov 12 2013 — edited Nov 14 2013

Dear All

I want to create a table using many tables. (ie. Like sales summary by salesperson). To do that I created a Data Block using the view;It works fine only if it is used by only one user. If it is used by couple of user the form hangs because each user give different parameters (ie Date Range or Salespersons). The same issue comes even if I try to insert into a table.


To overcome this issue i tried it using From Clause Query in the Data Block. When I run the Form using From Clause query it needs a Primary Key.

How to overcome this issue?


Thank you in advance.


NZK

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 12 2013
Added on Nov 12 2013
7 comments
969 views