OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Query Mode

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

Query Mode [message #462405]

Thu, 24 June 2010 02:39

lokeshsurana
Messages: 212
Registered: April 2010
Location: India

Senior Member

Respected Sir,
I have one trouble regarding application form query mode..
Scenario..
There is Master Detail block relationship
in master block there is two fields which are mandatory
at detail block also two fields are mandatory

as i press ctrl+f11 for going in Query mode it shows error as...
FRM:-40202 field must be entered is showing

after that if i put values in mandatory fields and then query mode then
first save changes window is coming and then at detail block only one record it showing...

Can you suggest me what and where i did some wrong entry

Please

Thank You

Report message to a moderator

Re: Query Mode [message #462433 is a reply to message #462405]

Thu, 24 June 2010 04:32

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Quote:

i press ctrl+f11 for going in Query mode

I think in Oracle Applications Ctrl+F11 is to Execute Query and F11 is to go into Query Mode.
If you are following the same, provide the exact steps for reproducing the issue.

By
Vamsi

Report message to a moderator

Re: Query Mode [message #462435 is a reply to message #462433]

Thu, 24 June 2010 04:38

lokeshsurana
Messages: 212
Registered: April 2010
Location: India

Senior Member

steps:
1.opening form
2.press f11
--at this point it throws error field must be entered
3.i am inserting mandatory field
4. again press ctrl+f11
at this point it goes to query mode
5 . as i put %A% and pressing ctrl+f11

it throwing error as Press CTRL+F11 to execute query...
not getting whats the actual problem....

Report message to a moderator

Re: Query Mode [message #462436 is a reply to message #462435]

Thu, 24 June 2010 04:41

lokeshsurana
Messages: 212
Registered: April 2010
Location: India

Senior Member

@vamsi kasina
can i send you the fmb file can you just check out once......

Report message to a moderator

Re: Query Mode [message #462437 is a reply to message #462436]

Thu, 24 June 2010 04:47

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Is that a custom form? Otherwise name the fmb.
Try using menu Edit -> Run -> Enter Query and Run (NOT using F11 or Ctrl+F11).
Get the screenshots.

By
Vamsi

[Updated on: Thu, 24 June 2010 04:49]

Report message to a moderator

Re: Query Mode [message #462444 is a reply to message #462437]

Thu, 24 June 2010 05:08

lokeshsurana
Messages: 212
Registered: April 2010
Location: India

Senior Member

Yes It is Custom Form....

I stuck in two problems...
1. Query Mode
2. Record History Sad

Please find Attachment..

Attachment: error.jpg
(Size: 726.09KB, Downloaded 934 times)

Report message to a moderator

Re: Query Mode [message #462452 is a reply to message #462444]

Thu, 24 June 2010 05:27

lokeshsurana
Messages: 212
Registered: April 2010
Location: India

Senior Member

I am attaching custom.fmb

Please find Attachment....

Attachment: CUSTOM.fmb
(Size: 276.00KB, Downloaded 1236 times)

Report message to a moderator

Re: Query Mode [message #462463 is a reply to message #462452]

Thu, 24 June 2010 06:02

lokeshsurana
Messages: 212
Registered: April 2010
Location: India

Senior Member

@vamsi kasina

Sir, You get my problem..?
You checked attachments.....please......

I debug the form also but not getting where is wrong............

Report message to a moderator

Re: Query Mode [message #462465 is a reply to message #462463]

Thu, 24 June 2010 06:12

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Please don't call me as 'sir'.
I'm busy now. Will check your fmb later.

Meanwhile you can check the following.
1. Did you modify any triggers related to execute-query?
2. You didn't answer my question in the other thread related to record history.

By
Vamsi

Report message to a moderator

Re: Query Mode [message #462471 is a reply to message #462465]

Thu, 24 June 2010 06:56

lokeshsurana
Messages: 212
Registered: April 2010
Location: India

Senior Member

ok....
for record history...

i just write code on when-new-item-instance trigger......

I did not get in other stuff to set record history
is their need to register the tables...?

Please look on my form once....

i am waiting for solution...

Report message to a moderator