Workflow Process to Disable Multiple EIT/Self Service Transaction at one Go

Purpose: Restrict Employee to raise Multiple EIT Transaction at one go

 Probable Solution as said below

Step 1: Copy Seeded Workflow “Change Extra Information” and define yours

Step 2: Create Database Function 

CREATE OR REPLACE PROCEDURE xxhr_check_trans_raised (

   itemtype   IN            VARCHAR2,

   itemkey    IN            VARCHAR2,

   actid      IN            NUMBER,

   funmode    IN            VARCHAR2,

   result        OUT NOCOPY VARCHAR2)

IS

   l_cnt   NUMBER := 0;

BEGIN

   IF (funmode = 'RUN')

   THEN

      SELECT COUNT (*)

        INTO l_cnt

        FROM hr_api_transactions hat

       WHERE hat.item_key = itemkey;

     

      IF l_cnt = 1

      THEN

         result := 'COMPLETE:' || 'FAILURE';

      ELSE

         result := 'COMPLETE:' || 'SUCCESS';

      END IF;

   ELSIF (funmode = 'CANCEL')

   THEN

      NULL;

   END IF;

END xxhr_check_trans_raised;

Step 3: Alter the Workflow as show in the below screens

Step 3.1:  Create New Function in Workflow as shown in the below screen 

Step 3.2

Step 3.3: Alter the above-created workflow as shown below

Demo on how to Setup Employee Directory

How to Setup Employee Directory

Enable Approval for External Learning in OLM

External Learning Functionality is not working with approval (Internal Learner wants to have External Training) (Doc ID 1455266.1)          

Go to Workflow Builder --> Query for HR Objects

Copy Workflow “OTA_EXT_LRNG_JSP_PRC” and create Custom one “XXH_OTA_EXT_LRNG_JSP_PRC”

Double click on the above created Process and navigate to "@Review Page V4.0" Properties à Node Attributes

Set the Following Nodes

1) HR_DYNAMIC_APPROVAL_LEVEL --> Approval Level

2) HR_APPROVAL_REQ_FLAG --> Yes - Dynamic Approval

Navigate to “External Learning Entry” Process and set the following Node Attribute

Set the Following Nodes

1) HR_APPROVAL_REQ_FLAG --> Yes - Dynamic Approval

Update Function Parameters & Web HTML

Function: OTA_EXT_LEARNING_SS

User Function Name: External Learning

Type: SSWA jsp function

Form à Parameters: 

“pAMETranType=OTA&pAMEAppId=810&pProcessName=XXH_OTA_EXT_LRNG_JSP_PRC&pCalledFrom=XXH_EXTERNAL_LEARNING&pItemType=HRSSA&pFromMenu=Y&pFromiLearning=Y&pApprovalMode=Y”

Web HTML: “OA.jsp?akRegionCode=HR_CREATE_PROCESS_TOP_SS&akRegionApplicationId=800&OAFunc=XXH_EXTERNAL_LEARNING&OAPB=OTA_PRODUCT_BRANDING”

Run Request: Compile Security & Clear Cache

How to Delete a Pending-Approval Transaction from Employee Self Service

Go through the Screen showing Leaves, Pending for Approval



Enable the Following said Profile Option at Responsibility Level

Profile Name: “HR:Enable Initiator to Delete a Pending-Approval Transaction”

Navigate to Employee Self Service à All Actions Awaiting You Attention à Delete the Desired Pending for Approval Leave 

How to Enable if Responsibility Level Personalization is disabled in Self Service Page

Set the profile “FND: Personalization Seeding Mode" to "YES" at desired level

Error Displaying only Message Code and not Message Text

Function used to call Error Messages in Oracle Self Service via User Hook

hr_utility.set_message (800, 'XXX_HR_LEAVE_OVERLAP');

hr_utility.raise_error;

Run the Following Request & Bounce Apache (Bounce only if Message Text doesn't Appear after running the Request)

Navigation: System Administrator à View à Request à Submit New Request

Request Name: Generate Messages

Get Node value from Transaction Document using HR_XML_UTIL

CREATE OR REPLACE FUNCTION get_xml_node_value_f (

   p_transaction_id       IN NUMBER,

   p_desired_node_value   IN VARCHAR2,

   p_xpath                IN VARCHAR2,

   p_eo_name              IN VARCHAR DEFAULT NULL)

   RETURN VARCHAR2

AS

   l_xml_node_value   VARCHAR2 (32767) := NULL;

BEGIN

   l_xml_node_value :=

      apps.hr_xml_util.

       get_node_value (p_transaction_id       => p_transaction_id,

                       p_desired_node_value   => p_desired_node_value,

                       p_xpath                => p_xpath,

                       p_eo_name              => p_eo_name);

   RETURN l_xml_node_value;

EXCEPTION

   WHEN OTHERS

   THEN

      RETURN NULL;

END get_xml_node_value_f;

Example on how to Extract Value:

select get_xml_node_value_f(106003,'DateEnd','//PerAbsenceAttendancesEORow') from dual