Call Form (FND_FUNCTION.EXECUTE) - Session Issue
1.I am calling a custom form from OEXOEORD form using FND_FUNCTION.EXECUTE function with SESSION_FLAG parameter as 'N'.
2..After i call the custom form, i am querying for some inventory items based on some dates in custom form and inserting into the global temporary table which reserves the rows per session.
3.I have a button in custom form called 'Export'.This export button will call "Exit_Form" built in to close the custom form and bring back the focus to standard OEXOEORD form and displays the items in this form.
The issue i had here was,When i click on export button in custom form, the rows in global temporary table are lost eventhough the session id in custom form and standard form is same.However, when i dont click the export button and just click on standard form without closing the custom form, i can see the records in global temp table.