I need some help with the items and values in one Apex-Application:
I have a selected List-Item(P101_UMGEBUNG) on the Login-page (Page 101) in my application (next to Username and Passwort).
After this item has been selected from the presentet list and the button "Login" has pressed, I want to use this item value as part of different select statements on the other pages e.g in reports on Page 4 like this:
"select * from mytable where environment =:P101_UMGEBUNG;"
The select statement fails, it dosent return any row. It turns out that the value that I just chose from the list is not being saved in session state, so of course the select statement fails. I'm determining this by clicking on the session menu item on the developer bar - the item itself shows up, but the Item value is blank:
What would cause a chosen List-value to not end up in session state, and how can I make sure it gets there?
I testet different solutions (pl/sql processes, javascript dynamic actions and brances) that I found here in other discussions and with google, but maybe im doing something wrong,
Have someone a solution for this problem and could explain it in detail?