Wednesday, April 1, 2020

SQL for getting the ID value of Payroll Configuration Group (Threading Name) for running HCM Extracts in Oracle HCM Cloud environment

Sample SQL Query (You can modify as required):
-----------------------------------

SELECT 
                TO_CHAR(ACTION_PARAM_GROUP_ID) , ACTION_PARAM_GROUP_ID
FROM FUSION.PAY_ACTION_PARAM_GROUPS
WHERE ACTION_PARAM_GROUP_NAME = <pass the Threading Name here>

No comments:

Post a Comment

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

 After RedWood is being applied, while navigating to Add Absence functionality under Me tab, if it is throwing an Rest error, then follow th...