Posts

Showing posts from 2023

Fusion HCM Life Cycle

Image
 

Fix - Unable To Search a Specific Person record in Responsive UI and Person Management Screen - Fusion HCM

Image
The person record should be present in PER_KEYWORDS and PER_PERSON_TYPE_USAGES_M to be able to search the person record in Person Management Run below 2 ESS jobs to populate the person records in PER_KEYWORDS and PER_PERSON_TYPE_USAGES_M 1. 'Update Person Search Keywords' process to populate the records in PER_KEYWORDS. Query to verify the same: select * from fusion.PER_KEYWORDS where person_id IN (SELECT person_id FROM fusion.per_all_people_f WHERE person_number = '<person_number'); 2. 'Correct Employment Data Integrity Issues' with Parameter 'Mode' set to 'Update' from dropdown, to populate records in PER_PERSON_TYPE_USAGES_M Query to verify the same: select * from fusion.PER_PERSON_TYPE_USAGES_M where person_id IN (SELECT person_id FROM fusion.per_all_people_f WHERE person_number = '<person_number');

What individual processes need to be run in order to see employee's pay-slip in Fusion.

Image
There are several processes that need to be executed in this sequence in order to see employee's payslip. Navigation: Payroll > Checklist > Submit a Process or Report > Pick your Legislative Data Group: - Calculate Payroll - Calculate Prepayments - Archive Periodic Payroll Results - Generate Check Payments, this process generates the file with checks - Make EFT Payments - Generate Payslips

Meanings of the ACTION_TYPE for payroll actions in Fusion

Image
  select lookup_type   ,lookup_code ,meaning   ,description   ,language   ,enabled_flag from fnd_lookup_values where lookup_type like 'ACTION_TYPE' and language = 'US' and enabled_flag = 'Y' order by lookup_code  

Query to get actions that were processed on an employee in Fusion

  select ppa.effective_date,ppa.action_type, pra.action_status, pfi.instance_name, pfi.created_by,pfi.creation_date from FUSION.pay_payroll_rel_actions pra, FUSION.pay_payroll_actions ppa, FUSION.pay_pay_relationships_dn prl, FUSION.pay_requests prq, FUSION.pay_flow_instances pfi where ppa.payroll_action_id=pra.payroll_action_id and ppa.action_type<>'G' --remove to retrieve any generic actions, such as Generate automatic element entries ones and pra.PAYROLL_RELATIONSHIP_ID=prl.PAYROLL_RELATIONSHIP_ID and prl.payroll_relationship_number like 'XXX' and pra.SOURCE_ACTION_ID is null and prq.pay_request_id = ppa.pay_request_id and prq.flow_instance_id=pfi.flow_instance_id order by ppa.effective_date desc;

How to hide salary and manage elements screen for certain user in Fusion

Manage Salaries (ORA_CMP_MANAGE_SALARIES), View Salaries (ORA_CMP_VIEW_SALARIES) and Manage Payroll Element Entry (ORA_PAY_ELEMENT_ENTRY_MANAGEMENT_DUTY) Take a copy of the job role and remove these Aggregate Privileges in the Role Hierarchy - create a new data role on this job role apply the existing Person Security Create a new role that includes the above aggregate privileges in the role hierarchy Create a new person security profile that limits the people returned according to the requirements Create a new data role based on this Job role and Person Security Profile Revoke the existing role from the user Grant the 2 new roles to the user

How to disable Notifications for QuickPay Flows

  1.       Use the  ORA_PAY_QP_ALLOW_WORKFLOW_NOTIFICATION  profile option to disable automatic flow notifications for the seeded QuickPay flows. On the Manage Administrator Profile Values page, search for and select the  ORA_PAY_ QP_ALLOW_WORKFLOW_NOTIFICATION  profile option. 2.       In the Profile Values section, click  Add . 3.       Select  Site  as the profile level to enable the profile option for the entire site of deployment. 4.       Use the drop-down list in the Profile Value field and select  No  to disable the QuickPay notifications. 5.       Click  Save and Close .

Oracle Celebrate(Feature/Configuration/Use)

Image
  Oracle Me ->Celebrate Oracle Celebrate, a part of the Oracle ME employee experience platform is used to recognize employees’ achievements. Create recognition programs based on core values, across your organization. Enable employees to participate in these programs, post congratulatory messages that others can see and react to on their dashboards, and send reward points. Oracle Celebrate, part of the Oracle ME employee experience platform, delivers tailored, in-the-moment peer-to-peer recognition and holistic engagement insights to bring unsung heroes to the forefront and drive unique cultural values. Features Tailored recognition programs Personalize recognition programs for different segments of the organization, such as employees in a specific country or department. Embedded cultural values Improve company culture and drive desired behaviors by tying company values to moments of recognition. Employee recognition hub Provide individuals with a single place to amplify their ...

Make the payroll field as optional under payroll details for Local and Global transfer

Image
  Get into a sandbox and navigate to HCM Experience Design Studio tool.   Query the Local and Global Transfer 1)   Create Rules 1)       Enter a name and description 2)       Under the Show or Hide Region set the "Payroll Details" option to Not Required. Save and retest. If satisfied you can publish the sandbox.

Payroll Relationship and Payroll Relationship Rules in Fusion

Image
A payroll relationship is an association between a person and a payroll statutory unit (PSU). Payroll Relationship Type Mappings Example for US Legislation:  Payroll Relationship Rules controls when and how payroll relationships are created for a person. Payroll relationship rules for a legislation.  

How to limit the number of personal payment methods added by Employees in their self-service.

Image
  Navigation : My Client Group -> Show More ->payroll section->Payment Method Preferences Add the details: Note : In above screenshot - ·          setup is performed to allow employees to select only Direct Deposit as the Payment type ·          maximum allowed Personal Payment methods is set as 3

How to create employee’s Personal Payment Method using self-service interface

Image
1) Login to application 2) Navigate to Me -> Pay -> Payment Methods   3) Payment Method has 2 sections - Bank Accounts and My Payment Methods 4) Click Add button in the Bank Accounts region and Enter account number, account type and routing number. 5) Click save 6) Click Add button on the Payment Methods region. Enter a Payment Method name. 7) Enter appropriate information and click Save.

Query to get costing by person

   SELECT PAP.PERSON_NUMBER,         PPN.FULL_NAME,                                 PAA.ASSIGNMENT_NUMBER,                                 SUBSTR(PCAF.EFFECTIVE_START_DATE,1,10) AS COSTING_START_DATE,                                 SUBSTR(PCAF.EFFECTIVE_END_DATE,1,10) AS COSTING_END_DATE,                    (PCA.PROPORTION * 100) AS PERCENTAGE,         PCA.SEGMENT1 AS...

Query to get costing by department

  SELECT PD.NAME AS DEPT_NAME,         PD.STATUS,                                 SUBSTR(PCAF.EFFECTIVE_START_DATE,1,10) AS COSTING_START_DATE,                                 SUBSTR(PCAF.EFFECTIVE_END_DATE,1,10) AS COSTING_END_DATE,        (PCA.PROPORTION * 100) AS PERCENTAGE,                    PCA.SEGMENT1 AS COMPANY,        PCA.SEGMENT2 AS COST_CENTER   FROM PAY_COST_ALLOC_ACCOUNTS PCA,        PAY_COST_ALLOCATIONS_F PCAF,       ...

Query to get element costing information

  SELECT PET.BASE_ELEMENT_NAME       ,PEC.CLASSIFICATION_NAME AS PRIMARY_CLASSIFICATION_NAME       ,PET.ELEMENT_NAME                    ,PLDG.NAME    LEGISLATIVE_DATA_GROUP       ,PCA.SEGMENT1 COST_COMPANY                   ,PCA.SEGMENT2 COST_DEPARTMENT_ID                   ,PCA.SEGMENT3 COST_ACCOUNT_NUMBER                   ,PCA.SEGMENT10 COST_PROJECT                   ,PCA_OFFSET.SEGMENT1 OFFSET_COMPANY              ...