Show data in an embedded page developed in Oracle Apex and embedded in SAAS using SAAS security
Elaborating our requirement here:-
1)We have embedded a page developed in Oracle APEX in Oracle HCM.
2)We want to show data in the Oracle APEX page according to the data roles that the user has in Oracle SAAS.
3)Our central user repository is a non Oracle product(i.e not IDCS).So we have created an app there and use APEX Social Sign On for authentication. Hence,user is not asked to login when redirecting to APEX page.
We want to achieve something like the internal api calls we do from the APEX page should follow the data access of the logged in user in Oracle SAAS.