Wednesday, April 1, 2020

SQL for getting the Delivery Option details for HCM Extracts in Oracle HCM Cloud environment

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

SELECT 
                PEDT.DEFINITION_NAME
               ,PEDT.DESCRIPTION
               ,PEDOB.BASE_DELIVERY_OPTION_NAME
               ,PEDOB.DATE_TO
               ,PEDOB.DATE_FROM
               ,PEDOB.DELIVERY_TYPE
               ,PEDOB.BIP_REPORT_NAME
               ,PEDOB.BIP_TEMPLATE_NAME
               ,PEDOB.OUTPUT_TYPE
               ,PEDOB.OUTPUT_NAME
               ,PEDOB.OUTPUT_DIRECTORY_NAME
               ,PEDOB.FILTER_NODE
               ,PEDOB.BURSTING_NODE
               ,PEDOB.LEGISLATION_CODE
               ,PEDOB.MANDATORY_FLAG
               ,PEDODP.OPTION_TYPE
               ,PEDODP.OPTION_VALUE
FROM PER_EXT_DEFINITIONS_TL PEDT, PER_EXT_DELIVERY_OPTIONS_B PEDOB
 , PER_EXT_DELIVERY_OPTION_DTLS PEDODP
WHERE PEDT.DEFINITION_NAME LIKE '<pass the HCM Extract Name>'
AND       PEDT.EXT_DEFINITION_ID                   =    PEDOB.EXT_DEFINITION_ID
AND       PEDOB.EXT_DELIVERY_OPTION_ID   =    PEDODP.EXT_DELIVERY_OPTION_ID

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...