Hi All,
Can you please look at the issue we are facing with "DB session initialization PL/SQL code". It is causing issues with VPD. Details are below.
I have plsql code for VPD under security => Database Session. As per my understanding both initialization and cleanup codes are expected to work during every page load. However, the initialization code is not running in case if there is a validation failure. If the form has a validation failure(after processing or while submitting the page) then the page will be throwing the error. During this process the initialization code is not running. This result in the fields derived from the VPD don't work the way expected.
Based on my understanding and the testing performed, the initialization PLSQL code is not running in case if there is a validation failure during page submit. Only the cleanup code is running in this scenario. Request you to look at this and help us. Please let me know if I am missing something or doing something wrong here.
Please let me know if you need any further information needed on this.
Appreciate your support,
Kalesh.