WORLD OF ESSENCE: SQL for getting current session User Person Number in Oracle HCM Cloud environment

Monday, April 13, 2020

SQL for getting current session User Person Number in Oracle HCM Cloud environment

Sample SQL Query (You can modify as required):

-----------------------------------

SELECT DISTINCT PAPF.PERSON_NUMBER
FROM PER_ALL_PEOPLE_F PAPF
WHERE PAPF.PERSON_ID = (SELECT NVL(HRC_SESSION_UTIL.GETUSER_PERSONID,-1) FROM DUAL)

No comments:

Post a Comment

Welcome to the World Of Essence

Total 9+ years of experience as an ERP Techno Functional Consultant, out of which 8+ years of experience in Oracle PeopleSoft HCM and 5+ years of experience in Oracle Fusion HCM Cloud and over 2 years of experience in Informatica Cloud. Have experience working in Implementation, Solution Design and Delivery, Troubleshooting (Support) and Upgrade Project. Have worked in diverse areas of Oracle HCM Cloud, Oracle Integration Cloud (OIC), Oracle Analytics Cloud, Informatica Cloud and PeopleSoft HCM System.

Have hands on experience in Oracle HCM Cloud Core HR and Security Module in Release 10, 11, 12, 13, 18, 19, 20,21. Demonstrated ability to effectively work independently and collaboratively to accomplish assignments with minimal supervision and effectively co-ordinate between offshore and onsite teams. Was involved in end to end implementation and supported environments which include Requirements definition, Solution design and Documentation. Development, Testing and coordinating UAT with the client, taking a sign-off and ensuring project deliverables are successfully implemented as per the timelines. Have excellent Communication, Analytical, Interpersonal and Presentation skills.

WORLD OF ESSENCE

Monday, April 13, 2020

SQL for getting current session User Person Number in Oracle HCM Cloud environment

No comments:

Post a Comment

How to get rid of "Exception during RestAction" error from Employee Self Service functionality while submitting Absence

Total Pageviews

Followers