Home » Applications » Oracle Fusion Apps & E-Business Suite » How to list records in form (Oracle Apps 12i)
How to list records in form [message #549029] Tue, 27 March 2012 10:59 Go to next message
maggy_ashee
Messages: 70
Registered: May 2007
Member
Hi Guys,

I got to list some records in Oracle form (with scroll bar, something like reports). Please advice.

Output should be as below.

Order Number date status name end_date
123 23-jan-2001 approved sam 25-jan-2001
253 28-jan-2002 approved pam 30-jan-2002
213 29-jan-2001 approved kam 30-jan-2001
.
.
.
.
.

Thx
Re: How to list records in form [message #549030 is a reply to message #549029] Tue, 27 March 2012 11:01 Go to previous messageGo to next message
cookiemonster
Messages: 13915
Registered: September 2008
Location: Rainy Manchester
Senior Member
What's wrong with just querying the records with the default query functionality?
Re: How to list records in form [message #549036 is a reply to message #549030] Tue, 27 March 2012 11:27 Go to previous messageGo to next message
maggy_ashee
Messages: 70
Registered: May 2007
Member
I can see only one record at at time. however i need a list... Please advice!
Re: How to list records in form [message #549041 is a reply to message #549036] Tue, 27 March 2012 12:04 Go to previous messageGo to next message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
The most obvious way is to create a data block, based on a table. Its layout should be "tabular" (NOT "form"). Run the form, press <Execute query>.
Re: How to list records in form [message #549047 is a reply to message #549029] Tue, 27 March 2012 12:48 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
maggy_ashee wrote on Tue, 27 March 2012 11:59
Hi Guys,

I got to list some records in Oracle form


Define "some." But in any case you need to do what cookiemonster and Littlefoot suggest.
Re: How to list records in form [message #549162 is a reply to message #549029] Wed, 28 March 2012 06:56 Go to previous messageGo to next message
maggy_ashee
Messages: 70
Registered: May 2007
Member
Hi Guys,

Thanks for your inputs!

I have created a data block with tabular layout. I have multiple records to be returned. I tried using select, it failed saying exact fetch returns more than one row. Should I write a cursor and loop it or is there any setup in Property pallete which can list multiple records. Please advice.
Re: How to list records in form [message #549181 is a reply to message #549162] Wed, 28 March 2012 07:37 Go to previous messageGo to next message
cookiemonster
Messages: 13915
Registered: September 2008
Location: Rainy Manchester
Senior Member
Again - what's wrong with the default query functionality?
If you don't know how it works read up on it in form builder help. Start with the topics on query processing and execute_query.
Re: How to list records in form [message #549182 is a reply to message #549162] Wed, 28 March 2012 07:41 Go to previous messageGo to next message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
maggy_ashee wrote on Wed, 28 March 2012 13:56
I have created a data block with tabular layout.


This is ALL you need to do, nothing else.

Now run the form and push <Execute query> button on the toolbar.
Re: How to list records in form [message #549241 is a reply to message #549182] Thu, 29 March 2012 01:54 Go to previous message
maggy_ashee
Messages: 70
Registered: May 2007
Member
I was missing execute_query, as below. Thanks for your advice Littlefoot, cookiemonster and
joy_division.

go_block('block_name');
execute_query;
Previous Topic: create accounting error
Next Topic: universal work queue crashes
Goto Forum:
  


Current Time: Mon Mar 18 23:11:00 CDT 2024