PeopleSoft Session Logs Out When Clicking on Prompt Using a View from HCM Tables

Question

Issue Details:

* The prompt works with other tables, but when using the custom View, the session signs out.
* The View pulls data from HCM tables, and security settings for these tables are properly configured.
* We verified that there are no errors in the SQL query when executed directly in SQL Developer.
* No explicit session timeout warnings appear before the logout occurs.
* Web Profile session timeout values have been checked and are appropriately set.

User_A7VIB · Answer

Thank you for the information

MandeepGupta · Answer

Hi @User_A7VIB ,

Welcome to the Oracle Analytics community.

This community is dedicated to specifically to Oracle analytics. I can see your query is specific to Peoplesoft, so please raise it on customer connect —> people soft category:

PeopleSoft — Cloud Customer Connect

Thanks.