Posts
Showing posts from 2023
Fix - Unable To Search a Specific Person record in Responsive UI and Person Management Screen - Fusion HCM
- Get link
- X
- Other Apps
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.
- Get link
- X
- Other Apps
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
- Get link
- X
- Other Apps
Query to get actions that were processed on an employee in Fusion
- Get link
- X
- Other Apps
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
- Get link
- X
- Other Apps
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
- Get link
- X
- Other Apps
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)
- Get link
- X
- Other Apps
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
- Get link
- X
- Other Apps
Payroll Relationship and Payroll Relationship Rules in Fusion
- Get link
- X
- Other Apps
How to limit the number of personal payment methods added by Employees in their self-service.
- Get link
- X
- Other Apps
How to create employee’s Personal Payment Method using self-service interface
- Get link
- X
- Other Apps
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 department
- Get link
- X
- Other Apps
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, ...