EBS Customizations (MOSC)

MOSC Banner

Record Group Query statement not customizable on R12.

edited Feb 4, 2010 8:51PM in EBS Customizations (MOSC) 7 commentsAnswered
 Hi All,

I am doing a forms customization for Apps R12. I am using Forms Builder version 10.1.2.0.2.

What I need is to customize is the LOV ITEMS on the form OEXOEORD.frm for Oder Management Module. Based on the client requirement I need to modify the Record Group Query statement so that the LOV ITEMS returns only certain items. I have successfully modified the sql statement and tested it using SQL developer and it does what is expected.

I have successfuly compiled the new form(XXOEXOEORD), registered it on the apps, created a function to run the form and created a Menu to run the new form. Problem is, when I run  my new form(on apps front end), the results that comes from the LOV ITEMS are not what I expected. It is as if the Record Group query statement is still firing the old one. Just to make sure I was in the correct place, I swaped around the field items and that customization happens as expected. It is only the SQL statement that seems to be firing the old

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center