Creating new types for Document of Records in HRMS R12.

Creating new types for Document of Records in HRMS R12.

1.

Create New Record ex: HPPT_INFO , HVISA_INFO under DOCUMENT_CATEGORY

2.

3.

4.

5.

Check the Document of records in HRMS and upload documents.

Oracle Apps R12 HRMS to run Payroll only for current Employees using Assignment Set

Give name and Payroll > Save
Click Criteria>
Num : 1
Database Item : &PER_PERSON_TYPE
Operator : '= '
Value/Database Item: Employee

Save ...

Oracle Apps R12 Query to view users attached to Financial Modules

SELECT count(distinct FU.USER_ID)FINANCE_USERS
--select last_logon_date ,FU.USER_NAME,RESPONSIBILITY_ID, RESPONSIBILITY_APPLICATION_ID,FNDG.DESCRIPTION
from FND_USER_RESP_GROUPS_DIRECT FNDG,
FND_USER FU
WHERE fu.user_id= FNDG.USER_ID
--and fu.user_id = 2605
and RESPONSIBILITY_APPLICATION_ID in (200,222,260,140,101)
--and last_logon_date > to_date('01-jun-2016')  --enable if you want to see only recent employees.
--Payables,Receivables,Cash Managament, Assets,General Ledger

Oracle HRMS R12 Element Entry from Self Service using (ICD) Individual Compensation Distribution.

Element Entry from Self Service using (ICD) Individual Compensation Distribution.

1. Add Responsibility HR Professional V4.0 to the user.
2. Go to the Responsibility HR Professional V4.0 and click Individual Compensation Distributions Function.
3. Click Quick Setup
4. Select your element in the Element Type Field.
5. Click Create
6. Note down the Planid which appears once created.
7. Register the function and add in Employee Self-Service Menu.

Function properties:

Function: FUJ_ICD_AD

Type: SSWA jsp function

Parameters: pAMETranType=SSHRMS&pAMEAppId=800&pProcessName=HR_ADV_INDIVIDUAL_COMP_PRC&pItemType=HRSSA&pCalledFrom=FUJ_ICD_AD&PLANTYPE=1

    HTML Call:

OA.jsp?akRegionCode=HR_CREATE_PROCESS_TOP_SS&akRegionApplicationId=800&OAFunc=FUJ_ICD_AD   

Note: PLANTYPE=1 is derived from step6.

8. Add function to the Menu  ‘AE Self Service Functions Custom’ if AE Legislation else go to step 9.
9. Add the function to below Menu’s if needed  

1. Personal Actions Menu (optional)

2. Manager Actions Menu (optional)

3. Global Self Service Functions Custom

10.   Check the DFF ‘Ben ICD Developer DF’ which is created auto , whether  freezed or not, else enable freeze and save.

Another DFF ‘Add'l Element Entry Info.’ Freeze and save.

 

11. (Optional not tested)  if we have more plantypes then use personalization to show only 1 plan type in the self service page by adding your structure created in step 10 in the page Flex: (EleInpValFF) .

       

1.

2.

3.

4.

5.

6.

11

OAF/SSHR Customizations on vo, am, co to view , print and delete

1.

BEGIN
JDR_UTILS.LISTCUSTOMIZATIONS('/oracle/apps/per/selfservice/absence/server/AbsenceReplacedByLovVO');
END;

2.
copy the link from 1 and paste in 2,  

begin
  jdr_utils.printdocument('/oracle/apps/per/selfservice/absence/server/customizations/site/0/AbsenceReplacedByLovVO');
end;


3.
to delete the customization enter the output from 2 and paste it in 3

begin
 jdr_utils.deletedocument('/oracle/apps/per/selfservice/absence/server/customizations/site/0/AbsenceReplacedByLovVO');
end;

View Notifications of Others Users/Roles or monitor status of Workflow for users having Workflow Administrator Responsibility.

To enable to View Notifications of Others Users/Roles or monitor status of Workflow for users having  Workflow Administrator Responsibility.
Please follow any of below two procedures.

1. Attached screenshots Log in with SYSADMIN user.
Workflow Administrator Resp>Administrator Workflow>Administration




Update the field

*Workflow System Administrator - Workflow Administrator 
                                                                       'FND_RESP|FND|FNDWF_ADMIN|STANDARD

or

2.
UPDATE WF_RESOURCES
SET TEXT='FND_RESP|FND|FNDWF_ADMIN|STANDARD'
WHERE NAME = 'WF_ADMIN_ROLE'
commit

Adding new OU's to existing Supplier Site in Oracle R12.1.3 Payables

1. For single Supplier .
2. For All suppliers based on single OU adding to other new OU.


--------------------------------------------------------------------------------------------
 1. For single Supplier .

DECLARE
CURSOR c_vendor_sites IS
SELECT vendor_site_code,
vendor_id,
org_id,
party_site_id,
address_line1,
address_line2,
address_line3,
address_line4,
city,
state,
zip,
province,
county,
country,
area_code,
phone,
fax_area_code,
fax,
email_address,
purchasing_site_flag,
pay_site_flag,
rfq_only_site_flag,
hold_all_payments_flag,
duns_number,location_id
FROM ap_supplier_sites_all
WHERE vendor_site_id = 590615; -- used to create a new vendor site in a different OU

l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;
l_vendor_rec_type ap_vendor_pub_pkg.r_vendor_rec_type;
p_api_version NUMBER := 1;
p_commit VARCHAR2(1) := FND_API.G_TRUE;
x_return_status VARCHAR2(1);
x_msg_count NUMBER;
x_msg_data VARCHAR2(2000);
x_vendor_site_id NUMBER;
x_party_site_id NUMBER;
x_location_id NUMBER;
v_vendor_id NUMBER;

BEGIN
FOR r_site IN c_vendor_sites LOOP
v_vendor_id := r_site.vendor_id;

l_vendor_site_rec.vendor_id := r_site.vendor_id;
l_vendor_site_rec.vendor_site_code := r_site.vendor_site_code;
l_vendor_site_rec.org_id := 246; -- Target ORG ID where the new Site will be created
l_vendor_site_rec.party_site_id := r_site.party_site_id;
l_vendor_site_rec.location_id := r_site.location_id ;
l_vendor_site_rec.address_line1 := r_site.address_line1;
l_vendor_site_rec.address_line2 := r_site.address_line2;
l_vendor_site_rec.address_line3 := r_site.address_line3;
l_vendor_site_rec.address_line4 := r_site.address_line4;
l_vendor_site_rec.state := r_site.state;
l_vendor_site_rec.zip := r_site.zip;
l_vendor_site_rec.province := r_site.province;
l_vendor_site_rec.county := r_site.county;
l_vendor_site_rec.country := r_site.country;
l_vendor_site_rec.area_code := r_site.area_code;
l_vendor_site_rec.phone := r_site.phone;
l_vendor_site_rec.fax_area_code := r_site.fax_area_code;
l_vendor_site_rec.fax := r_site.fax;
l_vendor_site_rec.email_address := r_site.email_address;
l_vendor_site_rec.purchasing_site_flag := r_site.purchasing_site_flag;
l_vendor_site_rec.pay_site_flag := r_site.pay_site_flag;
l_vendor_site_rec.rfq_only_site_flag := r_site.rfq_only_site_flag;
l_vendor_site_rec.hold_all_payments_flag := r_site.hold_all_payments_flag;
l_vendor_site_rec.duns_number := r_site.duns_number;
--l_vendor_site_rec.language := 'AMERICAN'; --- Language
--l_vendor_site_rec.address_style := 'POSTAL_ADDR_US'; --- Address Style of the country which needs to be done. Take address style code of the specific country
--DBMS_OUTPUT.PUT_LINE( l_vendor_site_rec.party_site_id );
ap_vendor_pub_pkg.create_vendor_site(p_api_version => p_api_version,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_vendor_site_rec => l_vendor_site_rec,
x_vendor_site_id => x_vendor_site_id,
x_party_site_id => x_party_site_id,
x_location_id => x_location_id);

IF x_return_status = fnd_api.g_ret_sts_success THEN
DBMS_OUTPUT.PUT_LINE('Vendor Site Created.');
DBMS_OUTPUT.PUT_LINE('New Vendor Site id is : ' || x_vendor_site_id);
DBMS_OUTPUT.PUT_LINE('New Party Site id is : ' || x_party_site_id);
DBMS_OUTPUT.PUT_LINE('New Location Id is : ' || x_location_id);
ELSE
DBMS_OUTPUT.PUT_LINE('Return Status ' || x_return_status );
DBMS_OUTPUT.PUT_LINE('Error Details');
DBMS_OUTPUT.PUT_LINE( x_msg_count );
DBMS_OUTPUT.PUT_LINE( x_msg_data );
END IF;
END LOOP; END;

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










2. For All suppliers based on single OU adding to other new Two OU's.

DECLARE

CURSOR c_vendor_sites IS

SELECT vendor_site_code,
apsa.vendor_id, vendor_site_id,
org_id,
party_site_id,
address_line1,
address_line2,
address_line3,
address_line4,
city,
state,
zip,
province,
county,
country,
area_code,
phone,
fax_area_code,
fax,
email_address,
purchasing_site_flag,
pay_site_flag,
rfq_only_site_flag,
apsa.hold_all_payments_flag,
duns_number,location_id
FROM ap_supplier_sites_all apsa, ap_suppliers aps
where apsa.vendor_id = aps.vendor_id--vendor_id = 577807
and apsa.org_id = 102
 --apsa.org_id not in (1601)
and aps.enabled_flag = 'Y';

l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;
l_vendor_rec_type ap_vendor_pub_pkg.r_vendor_rec_type;
p_api_version NUMBER := 1;
p_commit VARCHAR2(1) := FND_API.G_TRUE;
x_return_status VARCHAR2(1);
x_msg_count NUMBER;
x_msg_data VARCHAR2(2000);
x_vendor_site_id NUMBER;
x_party_site_id NUMBER;
x_location_id NUMBER;
v_vendor_id NUMBER;

BEGIN
FOR r_site IN c_vendor_sites LOOP
v_vendor_id := r_site.vendor_id;

l_vendor_site_rec.vendor_id := r_site.vendor_id;
l_vendor_site_rec.vendor_site_code := r_site.vendor_site_code;
l_vendor_site_rec.org_id := 246; -- Target ORG ID where the new Site will be created
l_vendor_site_rec.party_site_id := r_site.party_site_id;
l_vendor_site_rec.location_id := r_site.location_id ;
l_vendor_site_rec.address_line1 := r_site.address_line1;
l_vendor_site_rec.address_line2 := r_site.address_line2;
l_vendor_site_rec.address_line3 := r_site.address_line3;
l_vendor_site_rec.address_line4 := r_site.address_line4;
l_vendor_site_rec.state := r_site.state;
l_vendor_site_rec.zip := r_site.zip;
l_vendor_site_rec.province := r_site.province;
l_vendor_site_rec.county := r_site.county;
l_vendor_site_rec.country := r_site.country;
l_vendor_site_rec.area_code := r_site.area_code;
l_vendor_site_rec.phone := r_site.phone;
l_vendor_site_rec.fax_area_code := r_site.fax_area_code;
l_vendor_site_rec.fax := r_site.fax;
l_vendor_site_rec.email_address := r_site.email_address;
l_vendor_site_rec.purchasing_site_flag := r_site.purchasing_site_flag;
l_vendor_site_rec.pay_site_flag := r_site.pay_site_flag;
l_vendor_site_rec.rfq_only_site_flag := r_site.rfq_only_site_flag;
l_vendor_site_rec.hold_all_payments_flag := r_site.hold_all_payments_flag;
l_vendor_site_rec.duns_number := r_site.duns_number;
--l_vendor_site_rec.language := 'AMERICAN'; --- Language
--l_vendor_site_rec.address_style := 'POSTAL_ADDR_US'; --- Address Style of the country which needs to be done. Take address style code of the specific country
--DBMS_OUTPUT.PUT_LINE( l_vendor_site_rec.party_site_id );
ap_vendor_pub_pkg.create_vendor_site(p_api_version => p_api_version,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_vendor_site_rec => l_vendor_site_rec,
x_vendor_site_id => x_vendor_site_id,
x_party_site_id => x_party_site_id,
x_location_id => x_location_id);

IF x_return_status = fnd_api.g_ret_sts_success THEN
DBMS_OUTPUT.PUT_LINE('Vendor Site Created.');
DBMS_OUTPUT.PUT_LINE('New Vendor Site id is : ' || x_vendor_site_id);
DBMS_OUTPUT.PUT_LINE('New Party Site id is : ' || x_party_site_id);
DBMS_OUTPUT.PUT_LINE('New Location Id is : ' || x_location_id);
ELSE
DBMS_OUTPUT.PUT_LINE('Return Status ' || x_return_status );
DBMS_OUTPUT.PUT_LINE('Error Details');
DBMS_OUTPUT.PUT_LINE( x_msg_count );
DBMS_OUTPUT.PUT_LINE( x_msg_data );
END IF;
END LOOP;
END;