Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

WHEN-NEW-ITEM-INSTANCE - on a Oracle seeded Form Vs WHEN-NEW-ITEM-INSTANCE on the same item in CUSTO

Venkata Kiran Kumar KesariMar 13 2015 — edited Mar 17 2015

I have a WHEN-NEW-ITEM-INSTANCE at the ITEM level on a Oracle seeded form / block which uses POPULATE_GROUP_WITH_QUERY with a dynamically built query (from TABLE A, column 1 and column 2) and assigning to a seeded LOV.
On the same exact form, block and item, I also have a CUSTOM.pll code which has the 'WHEN-NEW-ITEM-INSTANCE' doing the CREATE_GROUP_FROM_QUERY building a dynamic SQL query (from TABLE X, column 1 and column 2) and assigning to the same seeded LOV.

The form all the time shows up the Oracle seeded qurery results but not showing the values from the CUSTOM.pll code. Any ideas and suggestions on how to override the seeded list of values with my custom ones ?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 14 2015
Added on Mar 13 2015
9 comments
3,573 views