There are a couple of possibilities here. 1. Create a new custom.pll event 'WHEN-NEW-FORM-INSTANCE' by adding execute_query.
2. Are you executing the query after the value is passed? (i.e. when_new_block_instance -- set_block_property ('XX', default_where,'where customer_number = RCU_CUSTOMER_NUMBER'); execute_query;)
Dig Deeper on Oracle E-Business Suite
Related Q&A from Carol Francum
Is there any script or tool by which I can identify all the prerequisite patches for any given apps patch? Continue Reading