OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Forms behaves strange (Oracle11i,windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Forms behaves strange [message #522805]

Wed, 14 September 2011 01:10

fayas
Messages: 23
Registered: August 2011
Location: bangalore

Junior Member

Hi all,
I have developed a new for form in 6i and deployed in front end 11i.It is Query find window.the functionality of the form is that we search for an order number in the first screen and press button(search button).Then in the next screen it pulls headers information(deal number,currecy code, org_id etc) for the order number and also line level adjustments.In the second screen line level adjustments comes from diffirent table and header info order from other table..
Now, the problem when search for the order number..It pulls information for some orders number and for some other order number its not pulling data it shows blank screen,even though the orders has data in the back end..
I have attached the screen of the form for better understanding.
Please refer to the attachment for better understanding
Please help me to solve this issue..
please reply ASAP

Thanks in advance,
fayaz

Attachment: Forms.pdf
(Size: 173.42KB, Downloaded 1940 times)

Report message to a moderator

Re: Forms behaves strange [message #522806 is a reply to message #522805]

Wed, 14 September 2011 01:14

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What does the "search" button do? How exactly do you retrieve data?

Report message to a moderator

Re: Forms behaves strange [message #522808 is a reply to message #522806]

Wed, 14 September 2011 01:19

fayas
Messages: 23
Registered: August 2011
Location: bangalore

Junior Member

i have used a when button pressed trigger

IF :SO_QF.ORDER_NUMBER IS NULL
THEN
MESSAGE('No results rendered when invalid SO Number searched ');
MESSAGE('No results rendered when invalid SO Number searched ');
RAISE FORM_TRIGGER_FAILURE;
else
:parameter.G_query_find := 'TRUE';
app_find.find('EMCINT_ORD_HEADERS_ALL');
:parameter.G_query_find := 'FALSE';

END if;

Report message to a moderator