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.

Query to get Vacancy Details in Oracle Apps - iRec

Query to get Vacancy Details in Oracle iRec

SELECT name vacancy_name,
       attribute1 requestition_number,
       hr_general.decode_organization (BUSINESS_GROUP_ID) business_group,
       (SELECT name
          FROM per_all_positions
         WHERE position_id = paa.position_id AND ROWNUM = 1),
       hr_general.DECODE_JOB (job_id),
       hr_general.DECODE_GRADE (grade_id) grade,
       hr_general.decode_organization (ORGANIZATION_ID),
       hr_general.decode_location (LOCATION_ID),
       date_from,
       date_to,
       Status,
       (SELECT ppf.full_name || '(' || ppf.employee_number || ')'
          FROM per_all_people_f ppf, fnd_user fu
         WHERE     TRUNC (SYSDATE) BETWEEN effective_start_date
                                       AND effective_end_date
               AND ppf.person_id = fu.employee_id
               AND fu.user_id = paa.CREATED_BY)
          created_by,
       (SELECT ppf.full_name || '(' || ppf.employee_number || ')'
          FROM per_all_people_f ppf
         WHERE     TRUNC (SYSDATE) BETWEEN effective_start_date
                                       AND effective_end_date
               AND ppf.person_id = MANAGER_ID)
          manager,
       position_id
  FROM PER_ALL_VACANCIES paa

Stay Tuned for more updates.


"Team Work" More We Less Me.

FNDLOAD in Oracle ERP

To FNDLOAD Request groups

FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_REP_GROUP.ldt REQUEST_GROUP REQUEST_GROUP_NAME="GROUP_NAME" APPLICATION_SHORT_NAME="PER"

FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_REP_GROUP.ldt


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


To FNDLOAD Concurrent Programs

FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_ORACLE_INTERFACE_PROG.ldt PROGRAM APPLICATION_SHORT_NAME="XXCUST" CONCURRENT_PROGRAM_NAME="XX_CUSTOM_ORACLE_INTERFACE_PROG"

FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_ORACLE_INTERFACE_PROG.ldt


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


To FNDLOAD Oracle Descriptive Flexfields

$FND_TOP/bin/FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_PO_REQ_HEADERS_DFF.ldt DESC_FLEX APPLICATION_SHORT_NAME=PER DESCRIPTIVE_FLEXFIELD_NAME='PO_REQUISITION_HEADERS'

$FND_TOP/bin/FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XX_PO_REQ_HEADERS_DFF.ldt

FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_FND_COMMON_LOOKUPS_DFF.ldt DESC_FLEX APPLICATION_SHORT_NAME=FND DESCRIPTIVE_FLEXFIELD_NAME='FND_COMMON_LOOKUPS'

FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_PA_EXPENDITURE_TYPES_DESC_FLEX_DFF.ldt DESC_FLEX APPLICATION_SHORT_NAME=PA DESCRIPTIVE_FLEXFIELD_NAME='PA_EXPENDITURE_TYPES_DESC_FLEX'

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


To FNDLOAD Oracle Menus

$FND_TOP/bin/FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct CUS_PER_MENU.ldt MENU MENU_NAME="CUS_PER_MENU"

$FND_TOP/bin/FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD $FND_TOP/patch/115/import/afsload.lct CUS_PER_MENU.ldt


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

FND Messages to download a single message

FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_CUS_MESSAGE.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME='PER' MESSAGE_NAME=XX_ICX_POR_LIFECYCLE_PAY_TIP

FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_CUS_MESSAGE_OO.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME='PER'


FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_CUS_MESSAGE_OO.ldt


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

Lookup values

FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD aflvmlu.lct XX_LOOKUP_LDT.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME ='PER' LOOKUP_TYPE="XX_LOOKUP_LDT"

FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD aflvmlu.lct XX_LOOKUP_LDT.ldt

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

Responsibility

FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct XX_RESP_NAME.ldt FND_RESPONSIBILITY RESP_KEY="XX_RESP_NAME"


FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct XX_RESP_NAME.ldt


----------------------------------------------------------------------------------------------------------------------------
Forms personalizations

FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_PERWSHRG.ldt FND_FORM_CUSTOM_RULES function_name="PERWSHRG-404"

FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_HZ_ARXCUDCI_STD.ldt FND_FORM_CUSTOM_RULES function_name="HZ_ARXCUDCI_STD"

FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_AP_APXVDMVD.ldt FND_FORM_CUSTOM_RULES function_name="AP_APXVDMVD"


FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_PERWSHRG.ldt

FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_HZ_ARXCUDCI_STD.ldt

FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_AP_APXVDMVD.ldt

Write me for any more clarification.

Stay tuned !!!!!

"Team Work" More We Less Me.

Welcome to Oracle Self Learning!

Oracle Payroll - GL  Interface query.

SELECT gl.*
  FROM pay_payroll_actions ppa,
       pay_assignment_actions paa,
       pay_costs pcv,
       gl_interface gl
 WHERE     ppa.payroll_action_id = 201496               -- for costing process
       AND ppa.action_type = 'C'
       AND pcv.transfer_to_gl_flag = 'Y'
       AND ppa.payroll_action_id = paa.payroll_action_id
       AND paa.assignment_action_id = pcv.assignment_action_id
       AND gl.user_je_source_name = 'Payroll'
       AND pcv.ASSIGNMENT_ACTION_ID = 1275993 -- for costing process
       AND gl.reference22 = TO_CHAR (pcv.cost_allocation_keyflex_id)

Team Work More "We" Less "Me"

How to change Employee Number Generation from Manual to Automatic in Oracle HRMS

Changing Employee number generation from Manual to automatic without affecting current employee numbers unchanged. 

Attach concurrent program : "Change Person Numbering to Automatic" to your responsibility.
And run the program with parameter as Employee.

This will automatically change Business Group Info value of Employee Generation from Manual to automatic, So new employee will be given there employee number automatically.

Technically this program creates an entry at per_number_generation_controls with BG and next value.

Sameer Patil
"Team Work" More We Less Me.                                                                                                                                                                                                                                                                             

Approval in OTL (Oracle Time and Labor)

>Approval in OTL, 1) Created or modify existing fast formula, And create Time Entry Rules, OTL Application Developer => Time Entry Rules

2) Now Create Approval Style, OTL Application Developer => Approval => Approval Style

Formulas, Approver Finder Formulas, OA Custom OTL Time Entry Approval for Line Manager /* ****************************************************************** Formula Name : HXC_OVERRIDE_APPROVER_WF_PERSON Description : Implement approval workflow person Contexts : None Explanation : Formula gets the override approver based on the timecard id and ovn. Change History: Date Author Comments ------------ -------------- ------------------------------------ */ /***************************************************************** Initialise Variables which can be null ******************************************************************/ default for formula_status is 'S' default for formula_message is 'NO MESSAGE' /* ****************************************************************** READ IN INPUT VARIABLES ****************************************************************** */ INPUTS ARE timecard_bb_id (number) , timecard_bb_ovn (number) , application_period_bb_id (number) , application_period_bb_ovn (number) , time_recipient_id (number) , resource_id (number) , resource_type (text) /* **************************************************************** Processing **************************************************************** */ approval_mechanism = 'PERSON' approval_mechanism_id = XXTEST_GET_LINEMGR_ID ( resource_id,timecard_bb_id, timecard_bb_ovn ) /* **************************************************************** RETURN VARIABLE **************************************************************** */ RETURN approval_mechanism , approval_mechanism_id , formula_status , formula_message OA Custom OTL Time Entry Approval for TK /* ****************************************************************** Formula Name : HXC_OVERRIDE_APPROVER_WF_PERSON Description : Implement approval workflow person Contexts : None Explanation : Formula gets the override approver based on the timecard id and ovn. Change History: Date Author Comments ------------ -------------- ------------------------------------ */ /***************************************************************** Initialise Variables which can be null ******************************************************************/ default for formula_status is 'S' default for formula_message is 'NO MESSAGE' /* ****************************************************************** READ IN INPUT VARIABLES ****************************************************************** */ INPUTS ARE timecard_bb_id (number) , timecard_bb_ovn (number) , application_period_bb_id (number) , application_period_bb_ovn (number) , time_recipient_id (number) , resource_id (number) , resource_type (text) /* **************************************************************** Processing **************************************************************** */ approval_mechanism = 'PERSON' approval_mechanism_id = XXTEST_GET_TIMEKEEPER_ID ( resource_id,timecard_bb_id, timecard_bb_ovn ) /* **************************************************************** RETURN VARIABLE **************************************************************** */ RETURN approval_mechanism , approval_mechanism_id , formula_status , formula_message Time Entry Rule Fast Formula, OA Approval - approval maximum test (Custom) /******************************************************************* Formula Name : HXC_APPROVAL_MAXIMUM Description : Implements simple hours test for approvals Contexts : None Explanation : The formula is passed a resource id, period start and period end and maximum hours. Period start and end are the application period start and end dates. If the maximum hours is less than the number of hours over the period specified then the formula returns TO APPROVE equal to Y to initiate the approval process *********************************************************************/ /* Change History: Date Author Comments ------------ -------------- ------------------------------------ 04-Nov-2013 Sameer Patil */ /***************************************************************** Initialise Variables which can be null ******************************************************************/ default for db_pre_period_start is ' ' default for db_pre_period_end is ' ' default for db_post_period_start is ' ' default for db_post_period_end is ' ' default for db_ref_period_start is ' ' default for db_ref_period_end is ' ' default for reference_period is 1 default for duration_in_days is 1 default for period is 1 default for timecard_hrs is 0 default for period_maximum is 0 /* ****************************************************************** READ IN INPUT VARIABLES ****************************************************************** */ INPUTS ARE resource_id (number) , submission_date (text) , period (number) , period_maximum (number) , reference_period (number) , db_pre_period_start (text) , db_pre_period_end (text) , db_post_period_start (text) , db_post_period_end (text) , db_ref_period_start (text) , db_ref_period_end (text) , duration_in_days (number) , timecard_hrs (number) /* **************************************************************** Processing **************************************************************** */ IF ( xxtest_period_max (resource_id, submission_date, period_maximum, period, reference_period, db_pre_period_start, db_pre_period_end, db_post_period_start, db_post_period_end, db_ref_period_start, db_ref_period_end, duration_in_days, timecard_hrs ) = 1 ) THEN to_approve = 'Y' ELSE to_approve = 'N' /* **************************************************************** RETURN VARIABLE **************************************************************** */ RETURN to_approve "Team Work" More We Less Me.