About Me
- Muhammad Faizan Karim
- 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;
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
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:
It will output the path of the customization, which is the one to remove.
In order to delete the customization definition, use the following call, using the output from the previous command as a parameter.
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.
Reference: https://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:
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
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:
Subscribe to:
Posts
(Atom)