This discussion is archived
0 Replies Latest reply: Nov 28, 2012 6:21 AM by 927506 RSS

Change in an LOV query of Sales Order Form not working

927506 Newbie
Currently Being Moderated
Hi,

I wish to change the the Order Type (in the Sales Header) displayed in the Sales Order Form when viewed from a particular Responsibility.(11i Instance)
To be specific only certain order types should be displayed in the LOV when the User tries to create Order from that Responsibility.
In that process I created an FP with Action --> Builtin -->Create Record Group From Query

Then in Property-->Object Type-->LOV and Target Object -->ORDER_TYPE Value-->Name of my Query Group

I downloaded the Sales Order Form and modified the Query of the Group keeping the columns selected and the view used same and added in the Group I created.

But it didn't work out.

I tried out by changing my Target Object to SRV_ORDER_TYPE and its corresponding query from the Oracle Form.

But still it didn't work.

Please tell me where I'm going wrong.
Am I not choosing the correct target record group LOV?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points