How do I use FND_GLOBAL.APPS_INITIALIZE to integrate with EBS 11i security?
Eric MoeNov 11 2008 — edited Nov 12 2008Hello,
We are trying to integrate APEX with Oracle Ebusiness Suite 11i. We are trying to integrate with the HR/Payroll application which uses FND_GLOBAL.APPS_INITIALIZE to set the security context to a user, responsibility and application id which defines who the session has access to for the session. When we make the call to FND_GLOBAL.APPS_INITIALIZE in either a before header process or in the VPD security attribute, we get no data. Using the same call in SQL*PLUS we get the data expected.
Any suggestions on how to get this to work? What are we missing?
Thanks,
-Eric