Person Assignment Labor Schedules with Time Card Distribution
If the Distribute Using Time Cards option is enabled on a person assignment labor schedule, imported payroll costs are distributed to projects using existing time card transactions in Project Costing as the basis for the payroll distribution.
With the time card distribution method, payroll costs for a pay period are summarized and distributed to the target time cards in Project Costing for the same person, assignment, and date range as per the imported payroll period costs.
If you are importing payroll costs from Oracle Fusion Payroll to be distributed to time cards, you must specify a Time Card Distribution Basis value on each project payroll pay element that you’ve enabled to be imported into Project Costing using the Manage Project Payroll Pay Elements task. The Time Card Distribution Basis values are:
Time Card Distribution Basis | Eligible Target Time Cards |
All Hours | Target time cards with any expenditure type class are eligible to receive payroll pay element costs with this basis. |
Straight Time Hours | Only target time cards with an expenditure type class of Straight Time are eligible to receive payroll pay element costs with this basis. |
Overtime Hours | Only target time cards with an expenditure type class of Overtime are eligible to receive payroll pay element costs with this basis. |
Project payroll pay elements don’t have to be defined if you are importing payroll costs from a third-party external payroll system. In this case, you must specify a Time Card Distribution Basis on each payroll cost record loaded to the interface table if the payroll cost will be distributed to projects using time cards.
To be eligible for payroll costing, a project time card must meet the following criteria:
- The transaction must have an expenditure type class of Straight Time (ST) or Overtime (OT).
- The time card can be sourced from Oracle Fusion Time and Labor or any external third-party application.
- The Import Raw Cost Amounts option on the project transaction source document is No.
- The project time card isn’t a converted item.
- The project time card can’t be a net zero transaction.
- The project time card must be incurred by the same person and HCM assignment as the payroll costs, regardless of the expenditure business unit of the time card transaction.
- The project time card’s expenditure item date is within the effectivity dates of the labor schedule version with the time card distribution option enabled.
- The project time card’s expenditure item date is with the payroll period start and end dates on the labor cost records.*
*Note that the payroll period start and end dates on an imported labor cost from Oracle Fusion Payroll may not be the same as the start and end dates of the payroll. In the case of a payroll transfer, for example, Oracle Fusion Payroll considers the effectivity dates of the person’s payroll assignment relationship and adjusts the payroll period start and end dates accordingly for the imported labor cost.
When a time card is imported into Project Costing, if an active labor schedule version with the time card distribution option enabled exists for the person assignment, and the time card transaction date is within the effective dates of the version, then the time card is imported using a static cost rate of 0. When payroll actual costs are imported, then the raw cost of the time card is recalculated using the distributed payroll costs relevant for that time card transaction.
Whereas project-based labor distribution rules create a separate currency-based project cost transaction on each target project for each payroll pay element, the time card distribution method doesn’t create any new project costs. Instead, the raw cost on existing target time cards is recalculated when payroll is distributed to projects using the time card distribution method.
In the time card distribution method, all eligible payroll pay element costs applicable for a given target time card are summarized, and a raw cost rate is calculated for the target time card. This rate is then used to calculate the raw cost of the target time card by multiplying against the target time card’s quantity.
The following example illustrates the process:
Lance Mackenzie is a consultant for Vision City Operations. He reports his time worked against projects on a weekly basis using Oracle Fusion Time and Labor. He’s also a salaried employee paid on a weekly basis, and his payroll is calculated and processed using Oracle Fusion Payroll.
Vision City Operations wants the most accurate cost to be calculated for Lance’s reported time. Therefore, labor schedule version was created for Lance with the time card distribution option enabled so that Lance’s hours will be costed based on his actual payroll costs.
Vision City Operations uses Oracle Fusion Payroll and has defined the following payroll project pay elements in Labor Distribution so that payroll costs for these pay elements are eligible to be imported into Project Costing. Note that as costs for these pay elements may be distributed to projects using time cards, a Time Card Distribution Basis has been entered for each:
Pay Element | Time Card Distribution Basis |
Regular Salary | Straight Time Hours |
Overtime | Overtime Hours |
Bonus | All Hours |
Lance reports the following hours for the current week:
Project | Expenditure Type Class | Quantity |
Fox Stores HCM Implementation | Straight Time | 25 |
DHHS Study | Straight Time | 15 |
DHHS Study | Overtime | 4 |
For the same week, Lance’s payroll is:
Pay Element | Time Card Distribution Basis | Amount (USD) |
Regular Salary | Straight Time Hours | 2,000 |
Overtime | Overtime Hours | 400 |
Bonus | All Hours | 200 |
Total: | 2,600 |
Using the quantity of hours for Lance’s eligible target time cards, a raw cost rate is calculated for each pay element:
Pay Element | Time Card Distribution Basis | Amount (USD) | Target Time Card Quantity | Rate = Cost/Quantity (Rounded) |
Regular Salary | Straight Time Hours | 2,000 | 40 | 50 USD/Hour |
Overtime | Overtime Hours | 400 | 4 | 100 USD/Hour |
Bonus | All Hours | 200 | 44 | 4.54545 USD/Hour |
The raw cost for each of Lance’s time card entries is then calculated using the sum of the rates for each applicable pay element rate multiplied by the time entry transaction quantity:
Project | Expenditure Type Class | Quantity | Calculated Raw Cost Rate (Rounded) | Raw Cost (Rounded) |
Fox Stores HCM Implementation | Straight Time | 25 |
54.54545 USD/Hour (50 USD/Hour for Regular Salary pay element + 4.54545 USD/Hour for Bonus pay element) |
1,363.64 USD |
DHHS Study | Straight Time | 15 |
54.54545 USD/Hour (50 USD/Hour for Regular Salary pay element + 4.54545 USD/Hour for Bonus pay element) |
818.18 USD |
DHHS Study | Overtime | 4 |
104.54545 USD/Hour (100 USD/Hour for Overtime pay element + 4.54545 USD/Hour for Bonus pay element) |
418.18 USD |
Total: | 2,600 USD |
Unit of Measure for Target Time Card Transactions
The unit of measure for target time card transactions isn’t considered when distributing payroll actual costs. When recording time using the predefined transaction sources Oracle Fusion Time and Labor or Oracle Fusion Projects, the unit of measure is always hours. Third party time card transactions, however, can be created using a unit of measure other than hours.
Distributing payroll actuals to time cards is based on the quantities of the target time cards. The unit of measure on the target time cards is not considered. Therefore, if you have different units of measure on your target time cards, the distribution of payroll actuals will not account for this.
For example, you are importing a pay element cost of 100 USD. The following would be the distribution results based on the target time cards in each example:
Example 1: All Target Time Cards with a Unit of Measure of Hours
Transaction Source | Quantity | Unit of Measure | Resulting Raw Cost |
Oracle Fusion Time and Labor | 8 | Hours | 50 USD |
<Third party source> | 8 | Hours | 50 USD |
Total: | 100 USD |
Example 1: All Target Time Cards with a Unit of Measure of Days
Transaction Source | Quantity | Unit of Measure | Resulting Raw Cost |
<Third party source> | 1 | Day | 50 USD |
<Third party source> | 1 | Day | 50 USD |
Total: | 100 USD |
Example 3: Target Time Cards with Different Units of Measure
Transaction Source | Quantity | Unit of Measure | Resulting Raw Cost |
Oracle Fusion Time and Labor | 8 | Hours | 88.89 USD |
<Third party source> | 1 | Day | 11.11 USD |
Total: | 100 USD |
Changes to Source Payroll Costs or Target Time Card Quantities
There can be changes to either payroll source costs or target time card quantities, or both, after payroll costs are initially successfully distributed to target time cards in Project Costing. Whenever there is a change in source payroll costs being imported in addition to previously distributed payroll costs, the target time cards are automatically adjusted to reflect the distribution of payroll actual costs which include the newest additions.
For example, a pay element cost of $4000 for a particular person assignment is successfully imported and distributed to target time cards in Project Costing. The distributed cost amounts after the initial payroll distribution are shown in the below table.
Transaction Number | Project Number | Quantity | Raw Cost (USD) |
100 | Stark Industries HCM Implementation | 25 | 2,500 |
101 | DHHS Study | 15 | 1,500 |
Totals: | 40 | 4,000 |
If you subsequently import an additional payroll cost for the same person assignment and payroll dates as per the original import, then the Import Payroll Costs process redistributes the new total cost to all target time cards. The table below shows the redistributed results when there is an additional $500 of payroll costs imported for the same period as the originally-imported cost of $4,000.
Transaction Number | Project Number | Quantity | Raw Cost (USD) |
100 | Stark Industries HCM Implementation | 25 | 2,812.50 |
101 | DHHS Study | 15 | 1,687.50 |
Totals: | 40 | 4,500 |
The total target time card quantities can also change after payroll costs have been successfully distributed. For example, a time reporter may revise his time card in Oracle Fusion Time and Labor to report more or less hours than were originally reported. Continuing with the example above, suppose an additional 10 hours were reported by the time reporter, and these additional hours were imported into Project Costing. There’s no change to the payroll costs for the period, but the previous distribution to target time cards is no longer accurate as the total target time card quantities have changed. In this scenario, the status of the relevant labor cost records in the Manage Labor Costs page changes to Needs Reprocessing. The table below shows the results after the successful reprocessing of the relevant labor costs.
Transaction Number | Project Number | Quantity | Raw Cost (USD) |
100 | Stark Industries HCM Implementation | 25 | 2,250 |
101 | DHHS Study | 15 | 1,350 |
103 | Fox Stores SCM Upgrade | 10 | 900 |
Totals: | 50 | 4,500 |
Payroll Cost Currencies
All imported payroll costs distributed to the same target time cards must have the same currency. Project-based distribution rules in Labor Distribution result in a separate project cost transaction for each pay element. Therefore, project-based distribution rules allow for different currencies across imported pay element costs. With time card distribution, however, multiple pay element costs are summarized before distributing to target time cards. Each target time card is updated with a single distributed cost amount, which may have been sourced from multiple payroll pay elements. Pay element costs with different currencies targeting the same time cards are rejected by the Import Payroll Costs process.
Time Card Raw Cost Rounding
For project-based labor distribution rules, new project cost transactions are created against target projects with a unit of measure of Currency for each payroll pay element cost. For these rules, the Import Payroll Costs ensures that the sum of the new project cost transactions is the same as the original payroll pay element cost, both when displayed or accounted.
With time card distribution-based rules, however, no new project cost transactions are created as a result of the payroll distribution process. Instead, a raw cost rate is calculated based on the sum of pay element costs and the quantities of target time cards. Each target time card transaction’s raw cost is then calculated by multiplying the raw cost rate with the time card transaction’s quantity.
This calculated transaction raw cost is saved as an unrounded amount in the data store. However, when the time card transaction is queried in the Manage Project Costs page or when it is accounted, the unrounded amount is rounded using the half up rounding rule to the precision of the currency.
For example, a payroll cost of 2,000 USD is imported and distributed to target time cards which have a total quantity of 42 hours. The raw cost rate is calculated as 2,000 USD divided by 42 hours resulting in a raw cost rate of 47.6190476190476 USD/hour. This raw cost rate is then used to calculate the raw cost of each target time card transaction as shown in the below table.
Transaction Number | Project Number | Quantity | Raw Cost Rate | Raw Cost (USD) - Unrounded | Raw Cost (USD) - Rounded |
100 | Stark Industries HCM Implementation | 18 | 47.6190476190476 | 857.142857142857 | 857.14 |
101 | DHHS Study | 17 | 47.6190476190476 | 809.52380952381 | 809.52 |
103 | Fox Stores SCM Upgrade | 7 | 47.6190476190476 | 333. 333333333333 | 333.33 |
Totals: | 42 | 2,000 | 1,999 |