We are migrating a custom form from 11i to R12. But the form and LOVs in the fields dont return any values in R12. The custom views attached to these LOVs, return values in toad when the org is set. We think that the issue is that the org is not initialized in the form.
Can anyone help on how to resolve this?
Would it help if we used "MO_GLOBAL.SET_POLICY_CONTEXT('S',fnd_global.ORG_ID);" in the when new form instance trigger in the form.
Use following code in when-new-form- instance form level trigger
then insert following in pre-insert block level trigger
:ORG_ID := :PARAMETER.ORG_ID;