Restricting DFF Values (Value Set) Based on Form Values

Hi All,

There is interesting option I came across recently (Thanks to Venkat) to restrict DFF value based on Main Form Value,

Lets say, Based on Qualification (Oracle HRMS) I wanted to restrict sub Qualification at the DFF. Hence say if we select Qualification in main screen as "Master Degree" based on this automatically ,SUb Qualification DFF should restrict

Here while creating value set for Sub Qualification (Table Type) use :BLOCK.FIELD_VALUE, this will solve easily our requirement.

Example:

WHERE
AND TO_NUMBER(ATTRIBUTE1)=:QUALIFICATION.QUALIFICATION_ID

"Team Work" More We Less Me.

Clicking Appraisals via Manager Self-Service Errors Out With An error has occured while contacting the Knowledge Integration Servlet

SOLUTION

1.   Manager Self-Service
2.   Appraisals
3.   Personalize Page
4.   Select Complete View
5.   Click Expand All
6.   Content Container: Info Online
7.   Personalize icon
8.   Rendered False
9.   Apply
10. Return to Application
11. Clear the cache
     Functional Administrator - Core Services - Caching Framework - Global Configuration - Clear All Cache
12. Retest
13. Migrate to other environments

Please note that the same issue occurs with the navigation path below:

1. Manager Self-Service
2. Performance Management
3. Click on 'Go to Task' for Appraisal task

"Team Work" More We Less Me.

Restricting Absence Type LOV in Oracle Self Service

Oracle has given easy way to handle absence type LOV in SSHR.

Using Seeded package “HR_ABSENCE_RESTRICTED” we can achieve this by returning absence attendance type Id.

Below is sample code, where based on Responsibility how we can restrict absence types.

CREATE OR REPLACE PACKAGE BODY APPS.hr_absence_restricted

AS

   /* $Header: peabrest.pkb 120.0.12010000.4 2010/03/18 10:25:49 ghshanka noship $ */

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

   -- |----------------------< absences_restricted >--------------------------|

   -- Added by Sameer Patil

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

   --

   FUNCTION absences_restricted (selected_person_id   IN VARCHAR2,

                                 login_person_id      IN VARCHAR2)

      RETURN VARCHAR2

   IS

      l_count                 NUMBER;

      l_responsibility_name   VARCHAR2 (2000);

   BEGIN

      l_responsibility_name := fnd_profile.VALUE ('RESP_NAME'); -- added by Sameer Patil

      IF l_responsibility_name LIKE '%Employee%Self%'

      THEN

         --D.M ('After IF ');

         RETURN '2116’; -- Say '2116’ is Unpaid Leave

      ELSIF l_responsibility_name LIKE '%Manager%Self%'

      THEN

       RETURN ‘1019’; -- Say ‘1019’ is Unpaid Leave

      ELSE

         RETURN '-1';                                  -- do not return null..

      END IF;

   END absences_restricted;

--

END hr_absence_restricted;

/

"Team Work" More We Less Me.