About Me

Dubai, United Arab Emirates
My name is Muhammad Faizan Karim and my aim is to spread the knowledge to everyone who want to learn oracle HRMS. I will try to write the video blogs for beginners so they can understand e-business suits from HRMS perspective, and if you have any difficulty in oracle applications HRMS , please feel free to contact with me at this email : faizan.kareem.ocp@gmail.com
Powered by Blogger.
Sunday, April 19, 2020
DECLARE
   l_request_id   NUMBER ;                       -- The request id
   l_two_task     VARCHAR2 (256);
   l_gwyuid       VARCHAR2 (256);
   l_url          VARCHAR2 (1024);
 
   CURSOR C1 IS
   SELECT '8105566' REQUEST_ID FROM DUAL
   UNION ALL
   SELECT '8105565' REQUEST_ID FROM DUAL
      UNION ALL
   SELECT '8105564' REQUEST_ID FROM DUAL
      UNION ALL
   SELECT '8105563' REQUEST_ID FROM DUAL;
BEGIN
   -- Get the value of the profile option named, Gateway User ID (GWYUID)
   --- l_gwyuid := fnd_profile.VALUE ('APPLSYSPUB/PUB');

   SELECT   profile_option_value
     INTO   l_gwyuid
     FROM   fnd_profile_options o, fnd_profile_option_values ov
    WHERE       profile_option_name = 'GWYUID'
            AND o.application_id = ov.application_id
            AND o.profile_option_id = ov.profile_option_id;


   -- Get the value of the profile option named, Two Task(TWO_TASK)

   SELECT   profile_option_value
     INTO   l_two_task
     FROM   fnd_profile_options o, fnd_profile_option_values ov
    WHERE       profile_option_name = 'TWO_TASK'
            AND o.application_id = ov.application_id
            AND o.profile_option_id = ov.profile_option_id;
FOR I IN C1 LOOP
  l_request_id := TO_NUMBER(i.request_id);
   l_url :=
      fnd_webfile.get_url (file_type     => fnd_webfile.request_out, -- for out file
                           ID            => l_request_id,
                           gwyuid        => l_gwyuid,
                           two_task      => l_two_task,
                           expire_time   => 500-- minutes, security!.
                           );

   DBMS_OUTPUT.put_line (l_url);
END LOOP;
END;

Tuesday, December 25, 2018
SELECT petf.element_type_id,
       petf.element_name,
       peg.event_group_name,
       prcu.retro_component_usage_id,
       pesu.retro_element_type_id,
       petf_retro.element_name retro_element_name
  FROM pay_element_types_f petf,
       pay_event_groups peg,
       pay_retro_component_usages prcu,
       pay_element_span_usages pesu,
       pay_element_types_f petf_retro
 WHERE     1=1
       AND petf.recalc_event_group_id = peg.event_group_id
       AND prcu.creator_id = petf.element_type_id
       AND pesu.retro_component_usage_id = prcu.retro_component_usage_id
       AND petf_retro.element_type_id = pesu.retro_element_type_id
Monday, April 3, 2017
In order to remove the substitution definition, you have to identify the customization path and then use the jdr API to remove it.

In order to identify the customization, use the following call:

    1 begin
    2   jdr_utils.listCustomizations( '/oracle/apps/per/selfservice/absence/server/AbsenceTypeVO' ) ;
    3 end ;
    4 /
    5 
    6 

It will output the path of the customization, which is the one to remove.
    1/oracle/apps/per/selfservice/absence/server/customizations/site/0/AbsenceTypeVO
    2 

In order to delete the customization definition, use the following call, using the output from the previous command as a parameter.
    1 begin
    2   jdr_utils.DeleteDocument( '/oracle/apps/per/selfservice/absence/server/customizations/site/0/AbsenceTypeVO' ) ;
    3 end ;

    4 /
    5 Successfully deleted document /oracle/apps/per/selfservice/absence/server/customizations/site/0/AbsenceTypeVO.

Tuesday, January 17, 2017
Adding transaction details to FYI notifications after approval
In R11 Self Service applications, it was not possible to send transaction details in FYI notification after approval. There is a new feature in R12.1.3 which allows to configure specific notifications to contain transaction details. This will certainly help user community who were long waiting for this functionality (specifically for absence approvals through SSHR).

Steps to configure this functionality: 
1.    Log in using System Administrator responsibility
2.    Application > Function
3.    Add &pNtfFyiDetails=Y into form parameters to both functions: HR_LOA_SS and HR_LOA_MGR_SS
4.    Save

If this parameter is set to Y, then the FYI Notification page displays a Details region with the Proposed column and a Supporting Documents region.

Note: This feature is available from 12.1.3.


Referencehttps://oraebizblog.wordpress.com/2012/09/18/adding-transaction-details-to-fyi-notifications-after-approval/
Tuesday, December 6, 2016
Function to Get HRMS Table Balances

FUNCTION GET_BALANCE_VALUE (p_assignment_id    IN NUMBER,
                               p_balance_name     IN VARCHAR2,
                               p_dimension_name   IN VARCHAR2,
                               p_date             IN DATE)
      RETURN NUMBER
   IS
      v_bg_id            per_business_groups.business_group_id%TYPE;
      v_leg_code         per_business_groups.legislation_code%TYPE;
      v_defined_bal_id   pay_defined_balances.defined_balance_id%TYPE;
      v_bal_value        NUMBER;
   --
   BEGIN
      --
      SELECT paaf.business_group_id, pbg.legislation_code
        INTO v_bg_id, v_leg_code
        FROM apps.per_business_groups pbg, apps.per_all_assignments_f paaf
       WHERE     paaf.business_group_id = pbg.business_group_id
             AND paaf.assignment_id = p_assignment_id
             AND paaf.primary_flag = 'Y'
             AND paaf.assignment_type = 'E'
             AND TRUNC (p_date) BETWEEN paaf.effective_start_date
                                    AND  paaf.effective_end_date;

      --
      v_defined_bal_id :=
         get_defined_balance_id (v_bg_id,
                                 p_balance_name,
                                 p_dimension_name,
                                 v_leg_code);
      --
      v_bal_value :=
         get_balance_value_on_date (p_assignment_id,
                                    v_defined_bal_id,
                                    p_date);
      RETURN v_bal_value;
   --
   EXCEPTION
      WHEN OTHERS
      THEN
         RETURN 0;
   END GET_BALANCE_VALUE;
Sunday, April 3, 2016

Deployment Steps for OA Framework on R 12.2.x or R 12.2.4

Steps to deploy custom OA Framework page on R 12.2.4

1) Copy class files on server
2) Create ZIP file
3) Make Jar file from the ZIP file created before
4) Bounce the services

1) Copy class files on server
==================================
Copy files to custom folder path on server.

2) To Make .ZIP file
==================================
A) Create a temporary custom.zip file which contains all the custom application's directories/files at non-standard location. Please follow the following steps:

    1) cd $JAVA_TOP

    2) zip -r customprod.zip. Where the list of all directory paths are present, relative to $JAVA_TOP, for custom application's java files at non-standard location.

    Command: zip -r xxtest.zip xxtest

    3) Generate & sign customprod.jar file.

    Command: adjava oracle.apps.ad.jri.adjmx -areas $JAVA_TOP/customprod.zip -outputFile $JAVA_TOP/customprod.jar -jar $CONTEXT_NAME 1 CUST jarsigner -storePass -keyPass

3) To Make .JAR file
==================================
example : adjava oracle.apps.ad.jri.adjmx -areas $JAVA_TOP/customprod.zip -outputFile $JAVA_TOP/customprod.jar -jar $CONTEXT_NAME 1 CUST jarsigner -storePass -keyPass

Command:     adjava oracle.apps.ad.jri.adjmx -areas $JAVA_TOP/xxtest.zip -outputFile $JAVA_TOP/xxtest.jar -jar $CONTEXT_NAME 1 CUST jarsigner 


4) Bounce the Apache and mid-tier service by using the following commands.
==================================
adapcctl.sh stop

adapcctl.sh start

admanagedsrvctl.sh stop oacore_server1

EnterWeblogic Password:

admanagedsrvctl.sh start oacore_server1

EnterWeblogic Password: