Skip to Main Content

APEX

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!

Session PK 'Reset to Null'

Charles ANov 4 2009 — edited Nov 7 2009
Hello All,
I have a Form that has Four Items that are able to Search/Filter record data. Once Search button is selected based on any Four Item Values selected, record data is populated. Can also select Previous and Next buttons to scroll through record data populated from Search/Filter.
My problem is that the Session for the Primary Key is "Reset to Null" when Search is selected. So I am not able to Pass Item Values using a button that redirects to another page by 'Set These Items, With These Values' or by using the 'URL Target'. The Search button is calling a JavaScript function, no 'Submit as'.
But once I add
javascript:doSubmit('SEARCH')
to the Search button. The Session has the current Primary Key Value. The Form is rendered/submitted but this makes my Form lose functionality like scrolling through records using the Previous and Next buttons. The 4 Items that are Search/Filterable lose focus to there 'Null Display Value' also. Can anyone assist me in finding another solution to capture the Value of my Primary Key? So I can Pass Item Values to another page to create child table data based on the Foreign Key, thanks ahead of time.
This post has been answered by ATD on Nov 7 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 5 2009
Added on Nov 4 2009
14 comments
3,821 views