pay_payroll_assignments table

• Tables and Views for HCM

PAY_PAYROLL_ASSIGNMENTS

Schema: FUSION

Object owner: PAY

Object type: VIEW

• Manage VIP Account
• Register for VIP Plan
• VIP Member-Only Content
• HCM Data Loader
• HCM Extract
• BI Publisher
• Fast Formula
• OTBI Analytics
• Personalizations
• Scheduled Processes
• Absence Management
• Performance Management
• Talent Management
• Time & Labor
• HCM Extracts Questions
• HCM Data Loader Questions
• BI Reports Questions
• Report Issues/suggestions
• Your Feedback counts
• Write for Us
• Privacy Policy
• Join Telegram Group
• Join LinkedIn Group
• Join Facebook Page

SQL Query to pull Assigned Payrolls Information

• Post category: BI Publisher
• Post comments: 0 Comments
• Post last modified: August 5, 2021
• Reading time: 3 mins read

In this article, let’s try to pull the Assigned Payroll Information.

AssignedPayroll.dat HDL file will be used to load the Assigned Payroll information into the HCM system.

SQL Query to get this information:

Sample output will look like:

You Might Also Like

SQL Query to fetch HCM Data Loader Load Summary

SQL Query to get Position and Job Valid Grades

How to fetch the Delegated or Proxy Users?

Session expired

Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.

Learn to Grow

Reports (BIP) – Query to get assigned payroll details

Use the below query to extract assigned payroll details from Fusion HCM:

Payroll Assignment

The purpose of this assignment is to:.

• Reinforce previous learning
• Calculate regular wages, overtime wages and gross earnings
• Introduce conditional formatting
• Change page orientation
• Create a new sheet
• Add a header to the workbook

Preparation: (Review these terms)

• Formatting cell content
• Adjusting column width
• Creating simple formulas
• Centering column labels
• Using Auto Fill to drag formulas
• Using currency feature to add dollar signs and decimals
• Merge and Center
• Using the launcher button
• Use absolute cell references

New Terms: (Terms are bolded in the steps below.)

(THIS ASSIGNMENT IS DIVIDED INTO TWO PARTS; THE DOTTED LINE BELOW DIVIDES THE TWO SECTIONS.)

• Inserting blank column (Step #3, pages 1-2)
• Calculate Regular Pay (Step #5, page 2)
• Arithmetic Operators (Table mentioned In Step #5. Can be found on page 4)
• Calculate OT rate and OT pay. (Step #6, page 2)
• Calculating Gross Pay (Step #18, page 3)

—————————————————————-

• Creating a new sheet (Steps #20, page 3)
• Inserting a header (Step #28, page 4))

Spreadsheets are often used to determine the company payroll. This assignment breaks down regular pay, overtime pay and gross earnings. Additionally, conditional formatting is introduced to enhance the years of service for each employee by using color. (THIS ASSIGNMENT IS WORTH 25 POINTS. THE RUBRIC IS ON PAGE 5.)

• Download and open the Payroll Form and save it to your storage device as Payroll. ‘
• Adjust the columns if necessary to see all the data. (NOTE for clarification: in cell C4 the term Reg. means Regular; in cell D4, OT means Overtime.)
• Insert new columns. Move your mouse cursor above the Years of Service to the letter “E” which signifies what column you are in. As you move your mouse upwards to that letter “E” it becomes a black downward facing arrow. Once you see the black arrow, right click your mouse to get the short cut menu. From the menu, choose INSERT. A new column appears. Staying in that same position, INSERT to add more columns for a total of three new columns between OT Hours and Yrs of Service.
• Type the following: Reg. Pay in Cell E4; OT Pay in F4 and Gross Pay in G4.
• Calculating Regular (Reg) Pay. Create a formula to multiply Reg (Regular) pay times the number of hours that person worked. (Arithmetic operators such as the multiply symbol can be found at the end of this assignment and in the Extra Help Content folder called TABLES.) Formulas always start with the equal sign, use the cell reference such as B5 times C5. Make sure you start your formula where you want the answer to be. In this case start your formula in E5. (Hint: John Adams’ result will be 420.)
• Calculate Overtime (OT) pay. Create a formula to calculate overtime pay and have the result show in cell F5. To determine the overtime rate, multiply the regular rate times 1.5 (means overtime pay is 1 ½ times the regular rate.) To calculate the overtime pay, multiply the rate times the overtime hours. Two multiplication operators can be in the same formula. It is similar to using a calculator, but amounts are cell references. (Hint: John Adams’ Overtime pay should be 78.75.)
• Calculate Gross Pay. Gross pay is found by adding the regular pay plus the overtime pay. Start the formula in the gross pay column G5 of the first employee.
• Drag the formulas in E5, F5 and G5 down each column for each employee.
• In Cell A16 type the word TOTAL in all capital letter.
• Using the AutoSum key, calculate the totals of Reg. Pay (E16), OT Pay (F16) and Gross Pay (G16).
• Format these total as currency with two decimal places.
• Select cells H5-H14.
• From HOME tab, find the Styles group. On the left side of that group, find Conditional Formatting.
• Click on the Color Scales Option and then click on “More Rules”.
• In the lower box labeled “Edit Rule Description Box,” select Format Style and change to the 3- color option. Choose red for the lowest, yellow for the mid color, and green for the highest. Then click okay. ]
• Adjust all columns to make sure all the headings and entries are displayed.
• Center all entries and labels in columns B through H.
• Type your name in cell A18. Use Text Wrap to keep it all in one cell.
• Select the title “Payroll Report.” Change the font to AHARONI, 14 pt.
• Merge and Center the title between columns A-H.
• Change Orientation. Pages can be viewed with the long side on the left (Portrait) or the long side can be across the top (Landscape). From the HOME tab, From the PAGE LAYOUT tab, find the group called Page Layout. In that group find Orientation. For this assignment, change the orientation of the worksheet to LANDSCAPE.
• Save this worksheet as Payroll Report. Continue on to the second part of this assignment in the next steps.      ———————————————————————————————–
• Double-click on the new “Sheet 2.” Type What If.
• Select Columns A1 to H18. From the HOME tab, Clipboard group, click COPY icon. You should see a dotted line around the section you selected.
• Place your cursor in cell A1 and press PASTE. The previous columns A1 to H18 appear on the What If sheet.
• Adjust any columns so that they are wide enough for all columns.
• On the “What if” worksheet, type the words “What if” in cell I4. Widen the column if necessary
• Type 0.05 in cell J3
• In cell I5, use a formula that includes dollar signs in the formula (Absolute Referencing) to calculate the 5% pay raise in J3 times the Pay Rate in B5. YOU MUST USE ABSOLUTE CELL REFERENCING. [Hint: Use the decimal given Step-p 22]. Do you remember the formula used in Assign 3, Public Expenses by the Quarter Instructions to increase another value? IIf not, see Extra Help folder
• Your correct answer should be 53 cents more than the regular pay rate.
• Once you have the correct formula, use the short-cut menu to pull this formula down column from I5 to I14.
• In Cell K4 type the label: Difference.
• Insert a formula in K5 to determine the difference between the original Pay Rate and the “What If” increased pay rate. Once the formula is correct, drag the formula down K5 to K14. Make all amounts only two decimal places.
• A Header will appear at the top of every page, if there were more than one page in the worksheet.
• A Header only appears in the Print Out or in Print Preview. Otherwise, you won’t see it.
• Click the PAGE LAYOUT tab and find Page Setup Group.
• Click the launcher for Page Setup.
• Find the tab called Header/Footer and click on it.
• In the new dialog box that appears, click on Custom Header.)
• In the Center section of the Header , type XYZ Corporation and then click OK.
• Save this worksheet as Payroll and submit it through Blackboard. When you save this workbook, both the Payroll and the What If sheets will save together.
• If you are not taking this class on line, ask the instructor for information on how to print both the Payroll and the What If sheets that display the formulas.

TABLE: Arithmetic Operators used in Spreadsheets

TABLE: Order of Precedence in formulas

THE ORDER OF PRECEDENCE IS VERY IMPORTANT WHEN YOU WORK WITH FORMULAS THAT CONTAIN MORE THAN ONE OPERATOR. THIS IS BECAUSE IT AFFECTS THE FINAL VALUE (THE FINAL ANSWER).

Check the Rubric below to be sure you have completed all the tasks

• Payroll Assignment. Authored by : Fran Wells. License : CC BY: Attribution

Privacy Policy

• MAY MAINTENANCE PACK FOR 23A

Revision History

Feature Summary

Profit Sharing Reporting Enhancements

• MARCH MAINTENANCE PACK FOR 23A

Legislative Changes for the Tax Year 2023-24

Payroll Controlled Availability Features

Payroll for India

Effective Date on Professional Payroll Pages

Adjust Individual Balance Responsive Page

• RetroPay Late Hire Additions

QuickPay - Process Configuration Group Parameter

Values Defined by Criteria: Multiple Values Support in the Payroll Run

Autocomplete Rules for TimeCard Required and Overtime Period within HR Flows

Values by Criteria: Text Support in Payroll Run

Compile Formula Additional Parameters

Ability to Record Costing Information as part of a Global Transfer

Calculation Entries Additional Fields

Include Payroll Details in Change Assignment Approval Notification

• Export Payroll Run Results
• Export Payroll Balance Results

Global Payroll Replaced or Removed Features

Enhanced Reports Available and Previous Versions Are No Longer Supported

CPP and QPP Exemption During Mid-Period Payroll Transfer

Load ROE Reasons Mappings Using HCM Data Loader

Enhanced Reporting Information Card

Support for HR and Payroll Data Validation Reporting

• Work Risk Incident Premium Validation
• Support for Dynamic Payroll Relationship Groups
• INFONAVIT Involuntary Deduction Enhancement

Social Insurance for GCC Citizens

P60 End of Year Statement for Tax Year 2022-23

Benefits in Kind Proration on Mid-Period End or Termination

Court Order Processing Fee Override

P45 Flow - Errors and Warnings Report

P11D Audit Report Includes Person Number

LGPS – Calculation of Employer Contributions for Absences with Reduced Payment

Regional Pay Data Report Enhancement for California

Regional Pay Data Report Enhancement

IMPORTANT Actions and Considerations for Payroll

May Maintenance Pack for 23A

This document will continue to evolve as existing sections change and new information is added. All updates appear in the following table:

HCM Cloud applications have two types of patches you can receive that are documented in this What’s New:

• Release Updates (23A, 23B, 23C, and 23D)
• Optional Monthly Maintenance Packs to each update

It is important for you to know what Release Update your environment is on. You can find this in your Cloud Portal.

We’re here and we’re listening. If you have a suggestion on how to make our products better, please let us know. To enter an idea go to the Ideas Lab on Oracle Customer Connect. In this document wherever you see the light bulb icon after the feature name it means we delivered one of your ideas.

____________________

Suggested Reading for all HCM Products:

• HCM Common What's New - In this What's New you will find feature that are used across applications.
• Human Resources What’s New – In the Global Human Resources section you will find features on the base application in which other application are built upon. 

NOTE: Not all Global Human Resource features are available for Talent and Compensation products.

• Oracle Human Capital Management Cloud Functional Known Issues and Maintenance Packs (Document ID 1554838.1 ) . These documents identify bug fixes and possible known issues. You will also need to review these documents based in the release update version you are currently on or will be moving to.
• Oracle Help Center – Here you will find guides, videos and searchable help.
• Release Readiness – New Feature Summary, What’s New, Feature Listing Spreadsheet, Spotlights and Release Training

GIVE US FEEDBACK

We welcome your comments and suggestions to improve the content. Please send us your feedback at [email protected] . Indicate you are inquiring or providing feedback regarding the HCM Cloud What’s New in the body or title of the email.

Column Definitions:

Report = New or modified, Oracle-delivered, ready to run reports.

UI or Process-Based: Small Scale = These UI or process-based features are typically comprised of minor field, validation, or program changes. Therefore, the potential impact to users is minimal.

UI or Process-Based: Larger Scale* = These UI or process-based features have more complex designs. Therefore, the potential impact to users is higher.

Features Delivered Disabled = Action is needed BEFORE these features can be used by END USERS. These features are delivered disabled and you choose if and when to enable them. For example, a) new or expanded BI subject areas need to first be incorporated into reports, b) Integration is required to utilize new web services, or c) features must be assigned to user roles before they can be accessed.

Payroll for Mexico

Payroll for Oracle Human Capital Management for Mexico supports country specific features and functions for Mexico. It enables users to follow Mexico's business practices and comply with its statutory requirements.

You can use the Calculate Mexico Profit Sharing task to process all employees regardless of whether they are eligible for a profit sharing payment or not. This task flow has been enhanced to produce three outputs:

• Excel report – ProfitSharingReport.xlsx
• Element entry HCM Data Loader text file – ElementEntry.txt
• Audit information HCM Data Loader text file – PayrollInterfaceInboundRecord.txt

The Excel report includes additional person and employment information:

• Mexico Adjusted Service Date
• Assignment Start Date
• Assignment Category
• Termination Date
• Statutory Eligibility Criteria Met

When the Calculate Mexico Profit Sharing flow has completed successfully you’ll need to:

• Rename the ElementEntry.txt HCM Data Loader text file with a .dat extension.  Upload the ElementEntry.dat Profit Sharing HCM Data Loader file. This step is not required if you chose to create the element entries from the Calculate Mexico Profit Sharing task flow.
• Rename the PayrollInterfaceInboundRecord.txt HCM Data Loader text file with a.dat extension. Upload the PayrollInterfaceInboundRecord.dat HCM Data Loader file. You need to complete this if you want to review the employee’s profit sharing information in the application using the Payroll Interface Inbound Records page.

If you upload the PayrollInterfaceInboundRecord.dat file, the Payroll Interface Inbound Records page includes information for all employees that were processed in the Calculate Mexico Profit Sharing process regardless of whether they received a payment or not. You can view the values that were used to calculate the profit sharing for those employees that received a payment. A message is included for the employees that did not receive a profit sharing payment indicating their ineligibility.

To view the profit sharing audit information:

• Go to My Client Groups > Payroll > Administration > Payroll Interface Inbound Records .
• In the search area, enter the Person Number and select Mexico Profit Sharing Information for Record Type and Person for Record Owner Type.
• Click the Person number to open the page:

• Search for profit sharing audit information:

View profit sharing audit information

This feature enables you to oversee the Mexico profit sharing process, and provides audit information that you can use to review employees' data associated with this process.

Steps to Enable

You don't need to do anything to enable this feature.

March Maintenance Pack for 23A

Payroll for the United Kingdom

Payroll for Oracle Human Capital Management for the United Kingdom supports country specific features and functions for the United Kingdom. It enables users to follow the United Kingdom's business practices and comply with its statutory requirements.

The UK payroll legislative updates for the tax year 2023-24 includes all the prescribed changes to rates, thresholds, and percentages for tax, National Insurance deductions, statutory payments, student and postgraduate loans, pensions enrolment trigger and band, Scottish earnings arrestment bands, and all other changes that apply for UK, Scotland and Wales from 6 April 2023.

You can stay compliant with the legislative requirements for the tax year 2023-24.

Key Resources

For more information, see Payroll Legislative Updates For Tax Year 2023/2024 on the Information Center for Fusion Human Capital Management - United Kingdom (Doc ID 2090342.2)

Payroll Controlled Availability

The following is a list of Controlled Availability features that are being offered by our Controlled Availability Program.

NOTE: These features are not generally available for all customers at this time. These are only available through the Controlled Availability Program and will require approval to become a part of the features program. To be a part of these programs you will be required to participate in testing and providing feedback. Some programs may require other participation as well.

Not to worry if you don't have to time to be a part of these early stage programs. You can uptake this feature when it is generally available for all customers. When these features are available for all customers you will see the features under their product headings as usual.

We invite you all to browse through the list of features to see if there are any features you are interested in implementing in advance of the features scheduled release. The table below will provide information on signing up for features. Please sign up soon, as these programs have limited availability and some are designed for specific types of customers.

The table below gives you a brief description of the features available and how to sign up. Some features are bigger than others, so for more information there may be a What's New describing the feature in more detail below this table.

We look forward to hearing your thoughts and ideas as you participate the Controlled Availability programs!

Oracle Cloud HCM expands its global footprint to support Oracle Fusion Cloud Payroll for India.

The key features available in Cloud Payroll for India include:

• Processing of statutory deductions with the required data capture: 
• Income Tax (IT)
• Professional Tax (PT)
• Provident Fund (PF)
• Employee State Insurance (ESI)
• Labour Welfare Fund (LWF)
• National Pension Scheme (NPS)
• Calculation of following items for IT computation with the required data capture:
• House Rent (HRA)
• Income from House Property (Self-occupied and Let-out)
• Chapter VI A
• Other Income
• Investment declaration and submission of investment proof documents
• Processing previous employment information with the required data capture
• Processing the following allowances and related tax exemptions:
• Allowances under section 10 (14)(i)
• Allowances under s ection 10 (14)(ii)
• Leave Encashment
• Scholarship Allowance
• Leave Travel Allowance (LTA)
• Perquisites
• Payroll processing, payroll flows, and archiving
• Payment methods, payment types, and payments processing
• Support for the following reports:
• Statement of Earnings
• Payroll Activity Report
• Payroll Balance Report
• PF monthly ECR (Electronic Challan cum Return)
• Form 24Q (first 3 quarters)

Leverage the various features of Oracle Fusion Cloud Payroll for India to efficiently manage the different aspects of payroll in your organisation.

To enable this feature you need to log a Service Request (SR).

You can open a service request in My Oracle Support and include a tag for ' CA-India Payroll' .

HCM Cloud applications have two types of patches you can receive that are documented in this New Feature Summary:

SUGGESTED READING FOR ALL HCM PRODUCTS

• Human Resources What’s New - In the Global Human Resources section you will find features on the base application in which other application are built upon.

NOTE : Not all Global Human Resource features are available for Talent and Compensation products.

• Oracle Human Capital Management Cloud Functional Known Issues and Maintenance Packs (Document ID 1554838.1 ). These documents identify bug fixes and possible known issues. You will also need to review these documents based in the release update version you are currently on or will be moving to.

Global Payroll

Oracle Global Payroll is a high-performance, graphical, rules-based payroll management application. It’s designed to keep pace with the changing needs of your enterprise and workforce in order to reduce setup costs, administration, and processing time. It operates globally and consistently in every country supported by Oracle. It uses a highly scalable processing engine that takes advantage of the features of the Oracle database for parallel processing, resulting in optimal performance. In countries with payroll extensions delivered and supported by Oracle, the application delivers the calculations, tax reporting, and regulatory rules required to accurately process payroll and remain in compliance.

A new Effective Date field is displayed on the following professional payroll pages:

• Person Results
• Third-Party Person Payment Methods
• View Process Information Groups

The effective date gives a date context to the data you are viewing on the page. The effective date is the same as the date you enter on the Advanced Person Search page.

However, if you don’t enter a date on the Advanced Person Search page, the effective date defaults to today’s date.

Use the Effective Date field to view information on a page as of a specific date. For example, if you have selected a date of 27, October 2022 and chosen to view Last 3 Months payslips, you can view your payslips for prior three months.

For payslips, the effective as of date is editable, and you can enter a different date.  However for the other 3 pages, the effective as of date, is read-only and appears on the top right hand side of the page.

Use the effective date on some of the professional payroll pages to easily identify the date context for the data you are viewing on the page.

Use the Adjust Individual Balances task to adjust one or more balances for a worker as of a specific date. For example, use this task for any of these actions for an individual worker:

Correct balance entries from the Load Initial Balances process

Correct balances omitted during the balance initialization process

Correct balances with incorrect tax dimensions or incorrect tax jurisdictions

The adjust balances process adjusts one or more balances that are fed by the element   you select in the Adjust Values section of the Adjust Individual Balances responsive page. Select the name of the payroll balance you want to adjust and enter the adjustment details.

When you select a balance, the Adjustment Element drop-down includes list of elements feeding the selected balance, and that the employee is eligible for. If there is only one eligible element, the name of the element is displayed as read-only text. If the employee is not eligible for any of the elements that feeds the selected balance, you cannot proceed further, and you will have to select a different balance or leave the Balance field blank.

Adjust Multiple Balances Flow

After you select the payroll balance you want to adjust and enter the adjustment details, and click Submit, the application uses the Adjust Multiple Balances flow to submit the changes for the employee. A name is automatically generated for the flow that includes the name of the employee and the date of the balance adjustment. For example, if you use the Adjust Individual Balances to submit balance adjustments for Susan Smith as on 08, November 2022, the flow name is 'Balance_Adjustment_Susan_Smith_2022_11_08'.

You can view details of the balance adjustments submitted for an employee on the View Flows, Process Results Summary, and Person Results pages.

Impacted Balances

The Impacted Balances section displays details of the payroll balances that are impacted by the adjustment. For example, the Bonus element with an element input value of Earnings Calculated feeds these three balances:

• Gross Earnings

Therefore, if you select an element input value of Earnings Calculated, and select any one of these three balances to adjust, the Impacted Balances section displays adjustment details of the other two balances. This section displays the current balance values for the employee and indicates the new balance values after the adjustment is submitted. Use the section to view and validate the impact of the change on other payroll balances before you submit the balance adjustments for the employee.

Costing and Payment Details Section

Use the Costing and Payment Details section to enable or disable the costing of the adjustment results.

Use these steps to disable costing of the adjustment results.

• Navigate to the Setup and Maintenance area and search for the Manage Profile Options  task.  
• On the Manage Profile Options, click Actions < New and create the PAY_BAJ_UI_COST_FLAG profile option.

In the Profile Option Levels section, select Updatable . Click Save and Close .

Navigate to the Setup and Maintenance area and search for the Manage Administrator Profile Values  task.

• On the Manage Administrator Profile Values page, search for and select the PAY_BAJ_UI_COST_FLAG profile option.
• In the Profile Values section, click  Actions < New and specify the level at which you want to set the profile value.
• Select Site in the Profile Level field and  N  in the Profile Value field to disable costing of the balance adjustment results.
• Click Save and Close .

The Include adjustment in costing process  check box is deselected by default and the balance adjustment results aren't costed. 

Select the  Include adjustment in payment balance  check box to pay the adjustment results. The adjustment run results are included in the next pre-payment process. The period in which this balance adjustment payment is included is determined by the Date Earned value.

List of Values for Balances and Elements on the 

If you’re using any of these predefined job roles, then the list of values for Balances and Elements on the Adjust Individual Balances responsive page are secured by the security privileges defined for the roles.

• ORA_CMP_COMPENSATION_ADMINISTRATOR_JOB
• ORA_HRC_HUMAN_CAPITAL_MANAGEMENT_APPLICATION_ADMINISTRATOR_JOB
• ORA_HRC_HUMAN_CAPITAL_MANAGEMENT_INTEGRATION_SPECIALIST_JOB
• ORA_PAY_PAYROLL_ADMINISTRATOR_JOB

However, if you are using a user-defined role, add the aggregate privilege ORA_PAY_REST_SERVICE_ACCESS_PAYROLL_REFERENCE_DATA_LOVS to the role to secure the list of values. If you don’t add this privilege, the Adjust Individual Balances responsive page doesn’t display the list of values for balances and elements.

For more information on how to secure the list of values for balances and element for a user-defined role, refer ‘Secure List of Values for a User-defined Role for Balance Adjustments’ topic on the Oracle Help Center.

Adjust one or more payroll balances for an employee using the responsive Adjust Individual Balances page and view the balance adjustment results on the View Flows, Process Results Summary, and Person Results pages.

Create and use the PAY_BAJ_UI_COST_FLAG profile option to enable or disable the costing of the balance adjustment results.

For more information on how to secure the list of values for balances and element for a user-defined role, refer ‘ Secure List of Values for a User-defined Role for Balance Adjustments ’ topic on the Oracle Help Center .

You can now configure the event action to enable the Evaluate Late Hires flow pattern and automatically evaluate late hires, create a net pay result, and create retro event notifications. This allows you to process the late hires within the Recalculate Payroll for Retroactive Changes flow. This flow pattern now contains two tasks, Calculate Payroll for Late Hire and Late Hire Retropay Notification that replaces the need to manually enter an element entry against the late hire because the Late Hire Retropay Notification task automatically creates the notification. You can also now view the late hire details for an employee using the Person Results and Payroll Checklist pages.

Use the sample HCM Data Loader (.DAT file) to enable all or some of the following events:

• Create Flow: If set to Y, generates the Evaluate Late Hire flow pattern with its Calculate Payroll for Late Hire and Late Hire Retropay Notification tasks.
• Hire Date Later: If set to Y, the retroactive net pay result is generated when an employee's hire date is later than the payroll process date.
• Run Payroll Relationship Group: If set to Y, the retroactive net pay result is generated even when the original payroll was run with a payroll relationship group.
• Additional Assignments: If set to Y, the retroactive net pay result is generated when a late assignment is added to a payroll relationship.

The flow results are available to view in the View Flows , Process Results and Person Results pages.

Use the  View Flows page to drill down into the Evaluate Late Hires details.

Use the Payroll Checklist page to drill down into the Evaluate Late Hires tasks details. Calculate Payroll for Late Hire details contain the payroll calculations and Late Hire Retropay Notification details contain the event notifications generated.

Use the  Person Results page to drill down into the Calculate Payroll for Late Hires details.

Calculate retroactive pay for late hires using the enhanced RetroPay Late Hire solution. This feature automates the calculation of retroactive earnings for late hires by removing the need for manual intervention and view the late hire details for an employee using the payroll flow and checklist.

Section A – New Users of Late Hire Functionality

If you are currently using the Late Hire functionality, go to Section B because you don't need to create a new Event Group and only need to update your existing Event Action. New users, follow these steps:

Create a new Event Action for your legislative data group.

• Use this reference data as a template to create your new event actions (Create Flow, Hire Date Later, Run Payroll Relationship Group and Additional Assignments) for your legislative data group. Set each to Y to enable, or N to not enable. In this example, we have enabled all 4 event actions:

METADATA|EventAction|FLEX:PAY_EVENT_ACTIONS_DDF|CreateFlow

(PAY_EVENT_ACTIONS_DDF=ORA_CREATE_RUN_REL_ACTIONS)|HireDateLater

(PAY_EVENT_ACTIONS_DDF=ORA_CREATE_RUN_REL_ACTIONS)|RunPayRelationshipGroup

(PAY_EVENT_ACTIONS_DDF=ORA_CREATE_RUN_REL_ACTIONS)|AdditionalAssignments

(PAY_EVENT_ACTIONS_DDF=ORA_CREATE_RUN_REL_ACTIONS)|EventActionCode|EffectiveStartDate|EffectiveEndDate|EventActionName|EventActionTypeCode|LookbackTimeDefinitionCode|ActionSubmission|ProcessMode|AutoApprove|LegislativeDataGroupId

MERGE|EventAction|ORA_CREATE_RUN_REL_ACTIONS |Y|Y|Y|Y|

<Event_Action_Code>|1950/01/01|4712/12/31|

<Event_Action_Name>|ORA_CREATE_RUN_REL_ACTIONS||SYNC||Y|<Legislative_Data_Group_ID>

Note: You can modify line MERGE|EventAction|ORA_CREATE_RUN_REL_ACTIONS |Y|Y|Y|Y| to set to your needs. The 4 Ys represent the enabling of the 4 event actions in order. For example, if you do not want to enable Run Payroll Relationship Group, your line should be MERGE|EventAction|ORA_CREATE_RUN_REL_ACTIONS |Y|Y|N|Y|

• Update your Event Action in the reference data with following details:

Replace <Event_Action_Code> with event action code, such as MY_EVENT_ACTION

Replace <Event_Action_Name> with event action name, such as My_Event_Action

Replace <Legislative_Data_Group_ID> with LDG ID

• Zip the modified template as EventAction.zip.
• Create a new Event Group for your legislative data group.

Use this reference data as template to create your new event group for your legislative data group:

METADATA|EventGroup|EventGroupCode|EventGroupName|EventGroupType|LegislativeDataGroupName

METADATA|DateTrackedEvent|UpdateType|EventGroupCode|DatedObjectName|LegislativeDataGroupName

METADATA|EventGroupAction|EffectiveStartDate|EffectiveEndDate|EventGroupCode|EventActionCode

MERGE|EventGroup|<Event_Group_Code>|<Event_Group_Name>|A|<Legislative Data Group Name>

MERGE|DateTrackedEvent|DT_INSERT|<Event_Group_Code>|oracle.apps.hcm.payrolls.registrations.protectedModel.entity.PayrollUsageDEO|<Legislative Data Group Name>

MERGE|EventGroupAction|1950/01/01|4712/12/31|<Event_Group_Code>|<Event_Action_Code>

Update Event Group in the reference data with following details:

Replace <Event_Group_Code> with event group code, such as MY_EVENT_GROUP

Replace <Event_Group_Name> with event group name, such as My_Event_Group

Replace <Legislative Data Group Name> with LDG Name, such as US Legislative Data group

• Zip the modified template as EventGroup.zip..

Upload EventGroup.zip and EventAction.zip using HDL.

Section B – Existing Users of Late Hire Functionality

If you are currently using the Late Hire functionality, update the existing Event Action HDL and reload. You need to ensure the new HDL contains the new Metadata for the |FLEX:PAY_EVENT_ACTIONS_DDF, as per the example below. Existing users follow these steps:

• Use this reference data as a template to create your new event actions (Create Flow, Hire Date Later, Run Payroll Relationship Group and Additional Assignments) for your legislative data group. Set each to Y to enable, or N to not enable. In this example, we have enabled all 4 event actions
• Ensure the Event Action reference data for  <Event_Action_Code> , <Event_Action_Name> and  <Legislative_Data_Group_ID> are as per the previous Event Action HDL.

Tips And Considerations

Original payroll must have a run type of Regular .

• See the Process Payroll chapter in the Administering Global Payroll guide.

The Process Configuration Group parameter is now available on the QuickPay submission page. Use the parameter to select a process configuration group of your choice when submitting a QuickPay.

If you don’t make a selection, the process configuration group value defaults to what you have set using the ACTION_PARAMETER_GROUPS profile option. However, if you haven’t set the profile option and the field is left blank, then it defaults to the default group for the QuickPay process.

Use the Process Configuration Group parameter on the QuickPay submission page to select a process configuration group of your choice when submitting a QuickPay.

With this feature, you can now calculate one or more values in the payroll run using a Values Defined by Criteria. For example, your company calculates car allowance and housing allowance rates for an employee based on their job. The job criteria details and the allowance values are captured in a Values Defined by Criteria. You can now indicate which of the values captured on the Values Defined by Criteria should be calculated when processing an element in the payroll run.

This feature extends the flexibility of Value by Criteria as customers can now retrieve multiple values when calling a Value by Criteria directly in the payroll run.

To enable this feature, create value definitions using the following steps: 

• Create a value definition for each type of value held on the Values Defined by Criteria.
• Select the calculation type that corresponds with the calculation type of the value. For example, if the car allowance value on the Values Defined by Criteria has a calculation type of 'Flat Amount', the car allowance value definition should also have a calculation type of 'Flat Amount'.

NOTE : Enter a value identifier only when you define multiple value records for a criterion. Newly added validation will prevent the calculation of rates when a value identifier is captured for values defined by criteria with a single value record.

• Select Value Identifier in the Calculation Type Override field. This indicates the value definition will retrieve one value (from multiple values), held on a Values Defined by Criteria.
• Enter the name of the Values Defined by Criteria.
• Enter the name of the value in the Value Identifier field such as car allowance.
• Associate the value definition to your element using a Calculation Factor.

Create Calculation Value Definition

You can now derive the Timecard Required flag and Overtime Period in the Payroll Assignment Business Object, based on HR assignment attributes such as job, grade, or department, using Autocomplete Rules.

When you create the rules, you must select the "Field Modification Rule Type". The Business Object is "Payroll Terms", and the Field value is "Default Payroll Values Indicator". Refer the below screenshot for details.

Field Modification Rule Type

Assumption: HR assignments records must already be available so that the TCR and/or OP can be derived from them.

This feature provides a better user experience while working on HR assignment attributes.

• To enable Autocomplete Rules in the HCM Experience Design Studio, you need to log a Service Request (SR). Please review and follow the instructions provided in the My Oracle Support document, Enabling Oracle HCM Cloud Autocomplete Rules (Document ID 2767655.1 ) to get access.

Creating the Rule with Auto Complete

Autocomplete rules will be supported in the following transactions:

• Hire an Employee
• Add contingent worker
• Add Non-Worker
• Add Pending Worker
• Add Assignment
• Add Temp Assignment
• Create Work Relationship
• Add a Pending Worker
• Create and Edit Offer

For further information about the related action type codes for the EMP_Groovy_ActionTypeCode HCM Params function, please refer to the Configuring and Extending HCM Using Autocomplete Rules guide

Rule Sample

In the example below, the Autocomplete rule enables the defaulting of OP and TCR flag based on the Business Unit in the New Hire (EMPL_ADD_EMP) Flow:

Limitations:

• This feature is not valid for HR Assignment EFFs and DFFs.
• It is not possible to derive the payroll attributes based on Salary. Salary basis is not an HR assignment attribute, it's a Salary record.

Access Requirements

You must be granted the Human Capital Management Application Administrator role to work in a sandbox.

With this feature, you can now create a Values Defined by Criteria to capture text values based on a set of criteria such as assignment job and location. You can also retrieve the appropriate text value for an employee when processing the payroll run. For example, the text value could be the name of a rule or other type of condition that is used for payroll calculation purposes.

Create Value

When you create a value record for a Values Defined by Criteria, you can now select the 'Text' calculation type.

NOTE: It's not possible to calculate a rate from a text value. Therefore, rate definitions and the HCM Rates process cannot retrieve text information from a value defined by criteria.

This feature extends the flexibility of Value by Criteria as customers can now capture and return 'text' values that can be used for payroll calculation purposes.

Optimize performance of the Compile Formula process by using these additional Flow Parameters provided.

Additional Flow Parameters

These additional parameters provide greater flexibility in the selection of the formula you want to compile. 

With this feature, you can now record an employee’s costing information as part of the Local and Global Transfer transaction. For example, an employee transfers to a new legal employer and as a result the costing information changes; within the global transfer transaction, you can now record the new costing data for the target assignment.

A new Person Costing selection box is available when starting a Local and Global Transfer transaction. If you select it, a new region is displayed within the flow, and you can specify the Costing details for the new assignment. This region is automatically pre-populated with the source assignment’s costing details, and if you do not make any changes, the costing details will be carried forward to the new assignment. You can also update the costing details for the new assignment, as required.

Steps to use this feature

1. Select the Local and Global Transfer Quick Action.

2. Select the assignment to transfer.

Person Search

3. Select the Person Costing.

4. Enter the details in When and Why section.

When and Why

NOTE: The Costing Region will only be displayed if the new legal employer is different to the current legal employer, and if the change is permanent.

5. Enter the other regions and continue to the Person Costing section.

Person Costing

Person Costing is pre-populated with the current assignment’s costing details. If the details are not relevant to the new assignment, you can either delete them or make inline edits.

You also create additional rows if the costing is split across various cost centers. As long as the total percentage is lesser than 100, the Add button will be displayed.

Once you submit the transaction, it goes through an approval process (if the approval is configured). Since costing details are part of the transaction, they won’t be committed until the transaction has been approved.

NOTE: While the transaction is pending approval, you can update the source assignment costing details via Costing for Persons Quick Action; it will have no impact on the costing details entered for the new assignment.

This feature provides a better user experience while recording an employee’s costing information as part of the Local and Global Transfer transaction.

By default, the person costing region is disabled. To enable it, create a rule in the Transaction Design Studio.

Person Costing exists at 4 different levels:

• Payroll Relationship
• Payroll Relationship Element
• Assignment Element

NOTE:  Only Assignment level costing is supported within the Local and Global Transfer flow. If you store the costing details at any other level than assignment, you should not be enabling this feature. Other levels will NOT get copied from the source to the target assignment.

How does this feature work with existing copy costing feature?

You enable either the copy costing feature or the costing region but not both.

The existing copy costing feature allows you to simply copy costing details from the source to the target assignment, without the possibility to override them. When enabled, you can choose on a case-by-case basis whether to copy the costing data to the new assignment or not. It supports all the 4 costing levels mentioned above.

The costing region allows you to view and update the assignment-level costing prior to submitting the transaction.

NOTE: When costing region is enabled, you must make it mandatory. This is to ensure that the end user visits the costing region and enters the costing data. If the region is not visited, no data will be copied to the target assignment.

• If both Copy Costing feature and Costing Region are enabled, the Costing Region takes priority, that is, the Copy person costing override to the new employment record flag on the Payroll region will be hidden.
• When the Costing Region is enabled, no further copy will happen. If the costing data exists at other levels than assignment, they will NOT be copied to the new assignment, nor will any future dated costing records.

The Calculation Entries page provides an overview of all earnings and deductions that will be processed for an employee within a payroll period. Use the Creator Type field within the Standard Entries collapsed region to identify the origin of the element entry. For example, an entry displayed on the page can be a Salary Proposal, Element Entry, Balance Adjustment, and so on. 

Within the detail region of Time and Absence, you can see if the entry has been processed or not processed by a QuickPay or Payroll process.

Use the Creator Type field to identify the origin of an element entry on the collapsed Standard Entries page. View the Time and Absence Entries region to identify if an entry has been processed or not processed by a QuickPay or Payroll process.

With this feature, you can now enhance the Change Assignment approval notification to include payroll details. If you have enabled the Payroll Details region within the Change Assignment flow, you can now include payroll data within your approval notification template.

This feature allows the approvers to view the payroll data entered as part of the Change Assignment transaction.

Payroll Details are now available within the approval notification data model. Update your Change Assignment notification template to include this data based on your business requirements.

NOTE: Ensure that all ongoing approval notifications are closed prior to upgrade.

For transactions submitted but not closed before upgrade, the following rules will apply:

• Level 1 approver will not see any payroll data in the approval notification.
• Level 2 approver may see payroll data depending on whether Level 1 approval edited the transaction and what types of changes were made.
• Payroll Assignment Details will never be shown in the Approval Notification after upgrade if the initiator visited the payroll region with Other Info enabled.
• For more information on customizing the notifications, refer the Fusion HCM BIP Notifications: Best Practice to Customize the Report Template, Data Model or Sub-Template ( Doc ID 2647434.1 )

To view the payroll data in the approval notification, a user should have one of the following aggregate privileges:

• Manage Payroll Relationship
• View Payroll Relationship

You can now export an employee’s payroll run results into a file, such as a Microsoft Excel Workbook File. When you are viewing the run results on the responsive page, use the Export button to export to a file and save.

Result Details page

Export employee’s payroll run results into a file directly from the page.

The Export feature supports the following:

• The export feature supports Microsoft Excel and CSV file formats. The setting is controlled using the profile option File Format for Export to Excel.
• The Microsoft Excel report includes a separate column for each attribute and label supported by the list view. 
• The order of the columns on the report is in the same order as the attributes within each row on the Results page.
• The report shows the same filtered values as that shown on the Results page. For example, if you have filtered the information on the Results page based on Primary or Secondary Classification, the exported worksheet will include only the same information shown on the filtered Results page. 
• Any attributes that are hidden on the page aren’t included in the report.
• The sort order of the rows on the page is the same as the sort order of the rows on the report.
• All attributes displayed in the collapsed and expanded view are included in the export file. Some attributes, such as Element Name, are included in both views. As a result, the export includes Element Name column that displays this information for the collapsed view and a separate Element Name column that displays the same information for the expanded view.
• The first column in the export is always blank. This is a format limitation of the export feature and doesn't impact the integrity of the exported information.

Use the Export feature on the responsive Balance Results page to export payroll balance results displayed for an employee on the responsive page into a file, such as a Microsoft Excel Workbook File. You can now export the following information captured on the list view:

• Balance Name Results and Balance Group Results
• Balance Feeds
• The order of the columns on the report is in the same order as the attributes within each row on the Balance Results page.
• The report shows the same filtered values as that shown on the Balance Results page. For example, if you have filtered the information on the Balance Results page based on Balance Name or Balance Group Name, the exported worksheet will include only the same information shown on the filtered Balance Results page. 
• The sort order of the rows on the page is the same as the sort order of the rows on the  report.
• The balance result only supports export of collapsed view. This is because the expanded view is dynamic and displays information based on the selection.

Export the payroll balance results information displayed for an employee on the responsive Balance Results page into a file, such as a Microsoft Excel Workbook File to facilitate easy filter, view, and comparison of the results data.

From time to time, Oracle replaces existing features with new features, or removes existing features.

Replaced features may be put on a path of removal, the features below will let you know what update you will have to have moved to the newer feature. As a best practice, you should move to the newer feature as soon as possible for full support and to stay up with the latest updates that the product offers.

Any feature that is removed, will have an Update in which that feature is no longer available. Please make necessary plans to move off the feature by the Update indicated, as it will no longer be available.

Starting with 23A, the following reports will no longer be supported, and enhancements will not be made. These reports will be removed from the application starting with Update 23D.

• Run Payroll Costing Report
• Run Payroll Activity Report
• Run Statutory Deduction Register
• Run Payroll Register Report

Enhanced versions of these reports have already been delivered which provide better support for the extraction of payroll balances for large volumes of data.

• Run Payroll Activity Report for the Latest Process
• Run Statutory Deduction Register for the Latest Process
• Run Payroll Register Report for the Latest Process
• Run Periodic Payroll Activity Report
• Run Periodic Statutory Deduction Register
• Run Periodic Payroll Register Report
• Run Payroll Costing Results 

The new version of the reports are already available.

Use the enhanced reports that use a much lighter report template with enhanced performance and scalability capabilities to handle high volumes of data.

For additional information, refer the following resources on the Oracle Help Center:

• Latest Process Year-to-Date and Periodic Balances Reporting  in the Administering Global Payroll guide.

Payroll for Canada

Payroll for Oracle Human Capital Management for Canada supports country specific features and functions for Canada. It enables users to follow Canada's business practices and comply with its statutory requirements.

The Canada Pension Plan (CPP) and Quebec Pension Plan (QPP) employee and employer contributions are calculated according to legislative rules, and the exemption amounts are honored in cases where an employee experiences mid-period payroll transfers (of the same frequency) in the same period. With this update the exemptions are only applied for one payroll, and the calculations of the taxes are more accurate.

Further support of the exemption amounts, and compliance to legislative rules.

• Welcome tab > Other Documents > How To Use My Oracle Support Hot Topics Email Subscription Feature

You can now load default values in mass for the Record of Employment (ROE) Reason mappings using the HCM Data Loader (HDL). The reason mappings are held at the PSU level, and are used for terminations and absences. Once these mappings are configured, they are used by the ROE archive process to derive the Record of Employment Reason for issuing the ROE.

Using the HCM Data Loader for the Organization business object (OrgInformation), populate these attributes:

These mappings are held at the Payroll Statutory Unit (PSU) level. Once these mappings are loaded, you can view them by accessing the Payroll Statutory Unit Details region using the Manage Legal Entity HCM Information task located in the Setup and Maintenance work area. 

Supports the ability to create default Record of Employment mappings in bulk using the HCM Data Loader, in addition to the page.

For additional information on the Record of Employment reason mappings, see the technical brief noted in the Key Resources section.

This is a sample Organization.dat file used to create the Record of Employment mappings for terminations and absences.

METADATA|OrgInformation|FLEX:PER_ORGANIZATION_INFORMATION_EFF|EFF_CATEGORY_CODE|EffectiveStartDate|EffectiveEndDate|OrgInformationContext|OrganizationName|ClassificationName|LegislationCode|SequenceNumber|oraHrxCaPsuLoaRoeUnique(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_LOA_ROE_MAP)|oraHrxCaPsuLoaClsfName_Display(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_LOA_ROE_MAP)|oraHrxCaPsuRoeLoaReason_Display(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_LOA_ROE_MAP)|oraHrxCaPsuTermRoeUnique(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_TERM_ROE_MAP)|oraHrxCaPsuTermAction_Display(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_TERM_ROE_MAP)|oraHrxCaPsuRoeTermReason_Display(PER_ORGANIZATION_INFORMATION_EFF=ORA_HRX_CA_PSU_TERM_ROE_MAP)MERGE|OrgInformation|ORA_HRX_CA_PSU_LOA_ROE_MAP|HCM_PSU_CA|2001/01/10|4712/12/31|ORA_HRX_CA_PSU_LOA_ROE_MAP|ZHRX_CAVS_LE_02|Payroll Statutory Unit|CA|1|1|ZHRX_CA_Compassionate Care|Compassionate Care, Family Caregiver|||MERGE|OrgInformation|ORA_HRX_CA_PSU_LOA_ROE_MAP|HCM_PSU_CA|2001/01/01|4712/12/31|ORA_HRX_CA_PSU_LOA_ROE_MAP|ZHRX_CAVS_LE_02|Payroll Statutory Unit|CA|2|2|Sickness|Strike or lockout|||MERGE|OrgInformation|ORA_HRX_CA_PSU_LOA_ROE_MAP|HCM_PSU_CA|2001/01/01|4712/12/31|ORA_HRX_CA_PSU_LOA_ROE_MAP|ZHRX_CAVS_LE_02|Payroll Statutory Unit|CA|3|3|Other|Shortage of work, End of contract or season|||MERGE|OrgInformation|ORA_HRX_CA_PSU_LOA_ROE_MAP|HCM_PSU_CA|2001/01/01|4712/12/31|ORA_HRX_CA_PSU_LOA_ROE_MAP|ZHRX_CAVS_LE_02|Payroll Statutory Unit|CA|4|4|Maternity|Maternity|||MERGE|OrgInformation|ORA_HRX_CA_PSU_TERM_ROE_MAP|HCM_PSU_CA|2001/01/01|4712/12/31|ORA_HRX_CA_PSU_TERM_ROE_MAP|ZHRX_CAVS_LE_02|Payroll Statutory Unit|CA|1||||5|Global Transfer: Location Change|Employer bankruptcy or receivershipMERGE|OrgInformation|ORA_HRX_CA_PSU_TERM_ROE_MAP|HCM_PSU_CA|2001/01/01|4712/12/31|ORA_HRX_CA_PSU_TERM_ROE_MAP|ZHRX_CAVS_LE_02|Payroll Statutory Unit|CA|2||||6|Global Transfer: Career Progression|Shortage of work, End of contract or seasonMERGE|OrgInformation|ORA_HRX_CA_PSU_TERM_ROE_MAP|HCM_PSU_CA|2001/01/01|4712/12/31|ORA_HRX_CA_PSU_TERM_ROE_MAP|ZHRX_CAVS_LE_02|Payroll Statutory Unit|CA|3||||7|Global Transfer: Internal Recruitment|Strike or lockoutMERGE|OrgInformation|ORA_HRX_CA_PSU_TERM_ROE_MAP|HCM_PSU_CA|2001/01/01|4712/12/31|ORA_HRX_CA_PSU_TERM_ROE_MAP|ZHRX_CAVS_LE_02|Payroll Statutory Unit|CA|4||||8|Global Transfer: Manager Request|QuitMERGE|OrgInformation|ORA_HRX_CA_PSU_TERM_ROE_MAP|HCM_PSU_CA|2001/01/01|4712/12/31|ORA_HRX_CA_PSU_TERM_ROE_MAP|ZHRX_CAVS_LE_02|Payroll Statutory Unit|CA|5||||9|Global Transfer: Worker Request|Quit, Follow spouseMERGE|OrgInformation|ORA_HRX_CA_PSU_TERM_ROE_MAP|HCM_PSU_CA|2001/01/01|4712/12/31|ORA_HRX_CA_PSU_TERM_ROE_MAP|ZHRX_CAVS_LE_02|Payroll Statutory Unit|CA|6||||10|Resignation: Personal Reasons|Quit

Refer to these documents on the Canada Information Center for additional information.

Canada Information Center: https://support.oracle.com/rs?type=doc&id=2102586.2

• CA – Payroll tab > Product Documentation > Technical Briefs > Record of Employment Processing
• CA – Payroll tab > Product Documentation > Technical Briefs > Loading Canada Data Using HCM Data Loader

Hot Topics Email (To Receive Critical Statutory Legislative Product News)

To receive important Fusion Canada Legislative Product News, you must subscribe to the Hot Topics Email feature available in My Oracle Support.  Refer to the document below on the Canada Information Center for additional information.

https://support.oracle.com/rs?type=doc&id=2102586.2

You can now use the new, responsive Reporting Information page to capture the information required to create a reporting information card for an employee. The Reporting Information page captures information used for these types of reporting information:

• ROE Vacation Pay
• ROE Statutory Holiday Pay
• ROE Other Monies
• ROE Comments
• ROE Special Payments
• Quebec Labour Standards Contribution
• Year-End Data

The page retains the existing reporting card functionality, but it is enhanced to improve usability, which improves the overall user experience. It also provides a consistent look and feel with other HCM responsive pages, other localization tax card pages, and the employee self-service tax card page.

This illustration displays a reporting information card with a ROE Data component.

To add a new component, click Add on the Reporting Information section and select the component.

Each individual component offers its own set of unique component details to capture.  For example, the illustration below displays the fields to capture when adding the Year-End Data component. You may also add multiple types of components within this page.

With this feature you will see improved usability of the page, and improved the overall user experience.

Note the important tips and considerations below:

• The Effective As-of Date at the top of the page drives the date of the information displayed.
• The payroll field is not defaulted. It is selected by the user using an LOV. The LOV only shows the payrolls assigned to the employee. It displays the payroll that is processed where the Effective As-of Date on the card falls between pay period start and end dates.
• The active Tax Reporting Unit on the employee's card displays based on the Effective As-of Date on the card.
• For additional information on the Record of Employment components, see the Record of Employment technical brief noted in the Key Resources section.
• For additional information on the Quebec Labour Standards Contribution component, see the Administering Payroll for Canada guide noted in the Key Resources section.
• For additional information on the Year-End Data component, see the Administering Canada End-of-Year Processing guide noted in the Key Resources section.
• CA – Payroll tab > Product Documentation > Payroll Guides > Administering Payroll for Canada
• CA – Payroll tab > Product Documentation > Payroll Guides > Administering Canada End-of-Year Processing

You can now use the existing Payroll Data Validation Report to report exceptions for missing or invalid HR and payroll data that is required for payroll processing and reporting in Canada. The report is enhanced to include validations on this data:

• Payroll is not setup for the employee
• Tax card is not created for the employee
• TRU association is not created on the tax card
• Province of employment is not set on the tax card
• Home address is not set for the employee
• Person has multiple active home addresses at the same time
• Temporary SIN is expiring in N days

The new parameter Number of Days to Validate Temporary SIN is used to allow the user to enter the number of days value. The report will validate X number of days from the effective date parameter entered. If the temporary SIN expires within the days specified, a message is reported.

This feature offers enhanced data validation on HR and payroll data that is required, which helps identify data issues before payroll processing occurs.

The Work Risk Incident Premium (WRIP) that may be set up in the Organization Card at the payroll statutory unit (PSU) or tax reporting unit (TRU) level, is now validated to ensure that it's between the Work Risk Incident Premium Low Value and Work Risk Incident Premium High Value. A message is displayed if the WRIP is not within the allowed range.

Organization Card - Employer Social Security component

Ensures the accurate calculation of social security.

You can use the Payroll Relationship Group parameter to run the Mexico processes for dynamic groups of employees, rather than just a static group. The dynamic payroll relationship group option is supported by configuring a formula that will dynamically build the list of employees, based on a defined criteria.

For example, you may configure a formula to create a group of terminated employees, union employees, or employees that are on vacation. You then attach those employees to a payroll relationship group. This feature is available for the following Mexico processes that have the Payroll Relationship Group parameter:

Calculate Mexico Profit Sharing

Run Mexico Annual Tax Adjustment

Run CFDI Payslip Interface

Social Security Archiver

SUA Interface Extract

Social Security Affiliation Report

You can limit the scope of the process to only select the individuals based on a defined criteria rather than having to define and maintain a static list.

To enable and use this feature, you will need to:

• Optionally create a value set.
• Create a payroll relationship group formula type formula.
• Create a dynamic object group.
• For additional information on creating dynamic object groups, refer to the Administering Global Payroll guide on the Oracle Help Center.
• For additional information on creating Payroll Relationship Group Formula Type fast formulas, refer to the Administering Fast Formulas guide on the Oracle Help Center.

You can now create Instituto del Fondo Nacional de la Vivienda para los Trabajadores (INFONAVIT) loans using the element template for involuntary deductions.

• Create the elements with the primary classification involuntary deductions.

Select the secondary element classifications of INFONAVIT Loan and INFONAVIT Loan Insurance.

Create the elements

• Use the involuntary deductions calculation card to enter the relevant calculation information for loans and the associated loan insurance for employees that have an INFONAVIT loan.

INFONAVIT Loan - Involuntary Deduction Card

This enhancement changes the way in which you manage an employee's INFONAVIT loan.

• For more information about involuntary deductions, refer to the  How You Add Involuntary Deductions to a Calculation Card Help Center topic.

Payroll for Oman

Payroll for Oracle Human Capital Management for Oman supports country specific features and functions for Oman. It enables users to follow Oman's business practices and comply with its statutory requirements.

Calculate social insurance contributions accurately with the delivered legislative rules and information for citizens of the GCC countries. You must provide the following information in order to calculate Social Insurance.

• Type of employer
• Country of employment
• Nationality (Country of Citizenship)
• Confirmation that the person is registered for Social Insurance in the Country of Employment
• Whether or not it has been agreed that the country of citizenship will pay any difference in contributions
• Contributory salary
• Any additional personal details based on localization

With this enhancement, the following legislative information and rules are available to be used for calculating social insurance for your employees.

• Minimum and maximum ages at which contributions should be deducted
• Minimum and maximum earnings levels
• Rules for proration on starters and leavers
• Employer’s rates
• Employee’s rates

Age Range : Citizens of all GCC countries should register with the appropriate authority for Social Insurance within the respective age ranges.

Earnings Limit: The minimum and maximum earnings limits are stored in the Elements, Calculation Units and Rates part of the CIR as calculation vale definitions. The table below indicates the minimum and maximum earnings for the GCC legislation.

Employee Rates:

Employer Rates:

Contributory Salary (Private Sector): You can specify a contributory salary to be used in the calculation of Social Insurance. Use the balance Employee Private Sector Contributory Salary Base to provide a value for the contributory salary, or you can define a formula subject to rules on citizenship. For employer contributions, use the balance Employer Contributory Salary.

Contributory Salary (Government Sector): Use the balance Employee Government Sector Contributory Salary Base to provide a value for the contributory salary. For employer contributions, use the balance Employer Contributory Salary.The contributory salary for GCC citizens working in the government sector varies each period. For a Bahrain citizen the total of social allowances should not exceed 150 BHD.

The Contributory Salary balance is the basis for the calculation of employee's social insurance, any salary adjustment should be taken into consideration in this balance

Social Insurance Calculation (Private and Government Sector)

Calculate social insurance contributions accurately with the delivered legislative rules and information for citizens of the GCC countries.

With this enhancement, you can estimate the calculation of gratuity, to aid in costing the amount that may be due for eligible employees on termination. You can also pay the actual amount of gratuity due when the employee leaves employment.

A gratuity calculation won't be processed for employees registered for social insurance.

Organization Calculation Card : You can choose to provide a gratuity or pension benefits program and define a Gratuity Formula to calculate the gratuity payment. Select 'True' on the check box for Gratuity to be Paid to activate either gratuity process. Attach the monthly salary calculation formula to the calculation card at the PSU level, to be used as the salary base for the gratuity calculation.

Person Calculation Card : You can set Override Amounts to override the gratuity amount calculated by a delivered formula. Use the component detail 'Oman Employee Gratuity Details' to specify the Override Amount. The Latest Gratuity Payment Date is auto-populated when the gratuity payment on termination is made. This card is created automatically as part of the termination process if your product usage is set to Payroll or Payroll Interface.

Elements and Balances : You can verify the delivered elements and balances for gratuity, so the gratuity calculation is correct for the Legislative Data Group (LDG).

Calculation Value Definitions : Use the delivered calculation value definitions from the value definition group Gratuity, with a calculation type of Flat Amount.

Automatic Gratuity Calculation Card Creation : The application automatically creates a gratuity calculation card when an employee is terminated and isn't registered for Social Insurance.

Monthly Gratuity Estimate : Add the element Employee Gratuity Accrual Initiator to the employees to initiate the accrual process and trigger the calculation of an estimated gratuity payment. You may need to initialize the gratuity accrual balance to ensure that the first period of gratuity accrual is calculated correctly.

Private Sector Gratuity Payment Calculation:

• If the employee has more than 12 months of service then gratuity is calculated based on 15 days per year up to 3 years of service.
• If the employee has more than 3 years service, for the first 3 years service, gratuity accrual is based on 15 days per year, plus 30 days per year, or part year, for the remaining service.

Government Sector Gratuity Payment Calculation (Hire Date After 8 March 2011):

If the employee has more than 60 months service, then gratuity is calculated based on 30 days per year.

Government Sector Gratuity Payment Calculation (Hire Date On or Before 8 March 2011):

If the employee has more than 24 months service, then gratuity is calculated based on 30 days per year.

The actual gratuity will be calculated and paid on the termination of an employee when the Employee Gratuity Details calculation card is present.

Calculate and estimate the calculation of gratuity for eligible employees.

You can use the updated templates provided for the tax year 2022-2023 to generate and issue P60 End of Year Statement to your employees.

• eP60 - Online
• Plain Paper

You can stay compliant with updates provided for the P60 forms for the tax year 2022-2023.

• For more information, see the topic End of Year P60 Process for the UK in the Administering Payroll for the United Kingdom guide on the Oracle Help Center .

You can prorate the car, van, and other benefits appropriately using the new attributes introduced for availability dates when your employee terminates part way through a tax period.

There are two date fields available on the Car and Car Fuel component:

• Available from Date
• Available to Date

These dates will record the actual period of the car benefit when the car was actually available to the employee.

The car availability from date should be updated every time you create a car component.

The car availability to date must be entered when there is a change in the benefit, for example, change of car or in case of a termination.

You can leave the benefit component open ended and enter the new available from and to dates. The application processes the component in payroll, and calculates the taxable amount as a prorated value based on the actual period the benefit was provided to the employee.

You can use this feature to effectively prorate the value of the taxable benefit correctly when there is a change in the car benefit, or when there is an employee termination mid-period.

You can use the new field Processing Fee Override Amount if a particular court order type fee is not required, or a different value to that of the default amount is required.

This also includes the ability to override to zero. If no value is entered, the application considers the current default override fee or the override fee specified at the organization level for that court order type.

You can use the enhanced court order feature to override the processing fee for an individual employee court order calculation at the component level in the Court Order and Student Loan calculation card.

• For more information, see the Define Court Order Adjustments and Overrides for the UK topic in the Administering Payroll for the United Kingdom on Oracle Help Center .

You can utilize the errors and warnings report when running the P45 flow, that lists all the anomalies found during the process. This implies that the process will stop and you need to review and fix the errors.

Here's the data for employer, organization, and employees that were previously marked as warnings are now shown as errors:

• Employer Name
• Employer PAYE Reference
• Tax Reporting Unit Name
• Date of Birth
• Person Number
• Date of Leaving
• Payroll Statutory Unit Name

You can use the Run Errors and Warnings Report task in the P45 process to review and fix issues.

• For more information, see the P45 Process in the Administering Payroll for the United Kingdom on the Oracle Help Center .

You can identify employees reported on the P11D audit report using the two new fields included in the output. You need to use the Run P11D Archive flow pattern and all the relevant tasks.

The Run P11D Archive task produces the relevant audit reports, but doesn't generate any XML file. Person Identifier and Payroll Relationship Number have been added to the output file generated from the P11D process.

The Generate Online P11D and XM L task produces the audit report and the XML file that will be submitted to HMRC. And it displays the persons processed on the Process Results page. Rollback or Mark for Retry options are enabled at both person level and task level.

The P11D Audit Report is enhanced to make the reconciliation process easier to identify employees based on person number and payroll relationship of the employee.

• For more information, see the Processing Benefits-in-Kind Through Payroll and P11D Reporting in the Administering Payroll for the United Kingdom on Oracle Help Center .

You can now calculate employer contributions for periods with reductions in pay mid-period, due to absences such as sickness or maternity. This is done by prorating Permanent Pensionable Pay for days with normal pay and prorating Assumed Pensionable Pay for days with reduced or zero pay.

Comply with LGPS requirements to calculate employer contributions correctly for periods with mid-period reduction in pay, due to absences.

You need to create a new LGPS main scheme element to enable this feature.

Payroll for the United States

Payroll for Oracle Human Capital Management for the United States supports country specific features and functions for the United States. It enables users to follow the United States business practices and comply with its statutory requirements.

We have augmented California pay data reporting with the addition of the CA Pay Data Reporting Pay Bands calculation value definition.  This calculation value definition tracks the pay bands included in the pay data reporting extracts.  These bands are editable to accommodate any last minute changes announced by Civil Rights Department (CRD) of the state of California.

This feature makes the report a lot more flexible.  It helps you capture and report any new requirements announced by Civil Rights Department (CRD) of the state of California.

Refer to these topics in the Oracle Help Center :

• Overview of California Pay Data Reporting  
• Regional Pay Data Report for the US    

We have improved the flexibility of the Regional Pay Data Report by making the parameters related to contact information optional rather than mandatory.

This includes these parameters.

Contact Title

Contact Name

Contact Phone Number

Contact Address Line 1

Contact Address Line 2

Contact City

Contact State

Contact Country

Contact Postal Code

Contact information is no longer required on California Pay Data Report extract template; these are now captured as series of questions online.

For additional info, see the following topic on the Oracle Help Center:

• Regional Pay Data Report for the US

REPLACED OR REMOVED FEATURES

From time to time, Oracle replaces existing Cloud service features with new features or removes existing features. When a feature is replaced the older version may be removed immediately or at a future time. As a best practice, you should use the newer version of a replaced feature as soon as the newer version is available.

_________________________

KNOWN ISSUES / MAINTENANCE PACK SPREADSHEETS

Oracle publishes a Known Issues document for every Update to make customers are aware of potential problems they could run into and the document provides workarounds if they are available.

Oracle also publishes Maintenance Pack and Statutory Maintenance Pack documentation of bugs that are fixed in the monthly or statutory patching.

To review these documents you must have access to My Oracle Support:

Oracle Human Capital Management Cloud Functional Known Issues and Maintenance Packs (Document ID 1554838.1 )

looking for assignment ID in PAY_ELEMENT_ENTRIES_F

PAY_ELEMENT_ENTRIES_F table description says it contains element entries for each assignment but table does not have assignment_ID as a field on the table

PAY_ELEMENT_ENTRIES_F

This table contains element entries for each assignment. The actual values for each entry are held in PAY_ELEMENT_ENTRY_VALUES_F. An entry represents a specific instance of an element for a particular assignment. For example, there may be a salary element and each assignment receives a salary element entry.

How do I find the assignment_id that is connected to the element entries? which table do I connect to to get this information.

• Category 454
• Configuration
• General Payroll

Howdy, Stranger!

To view full details, sign in.

Don't have an account? Click here to get started!

• Payroll Insight

The following table lists objects (tables) of the Payroll Insight for Oracle

• Authorizations Insight specific objects
• Process Insights specific objects
• System Configuration Insight
• Financial Close Insight
• Order-to-Cash Insight
• Procure-to-Pay Insight