Oracle Projects determines rates from a combination of rate schedules and rate overrides, and uses the rates to calculate cost, revenue, and bill amounts. How Oracle Projects determines rates depends upon whether the rate is for costing, billing, or workplan and financial planning purposes.
You can define four types of rate schedules. The following table lists the four types of rate schedules and indicates how you can use each rate schedule type in Oracle Projects.
| Rate Schedule Types | Use to Determine... |
|---|---|
| Employee | Cost Rates - Labor Bill Rates - Labor Planning Rates - Labor |
| Job | Cost Rates - Labor Bill Rates - Labor Planning Rates - Labor |
| Non-Labor | Bill Rates - Non-Labor Planning Rates - Non-Labor |
| Resource Class | Planning Rates - Labor Planning Rates - Non-Labor |
Use the Rate Schedules window to define rate schedules.
Note: When you navigate between rate schedules using the Rates Schedule window, you can disable the Toggle Query Coordination check box if you do not want Oracle Projects to automatically retrieve and display the corresponding rates. When you disable the Toggle Query Coordination check box, you can navigate to the Rates block and run a query, with or without query criteria, to retrieve the rates.
You can use rate schedules for the following purposes:
Costing: Use rate schedules to define cost rates for labor expenditure items. You can maintain hourly cost rates by job or by employee.
Note: You do not use rate schedules to define cost rates for non-labor expenditure items. Instead, you can assign cost rates directly to non-labor expenditure types.
Billing: You can use rate schedules to determine revenue and bill amounts for billable expenditure items for contract projects when the revenue accrual method or the invoice method is Work (As-Work-Occurs). You can use employee, job, and non-labor bill rate schedules for this purpose.
You can also associate bill rate schedules with transfer price rules to determine the transfer price amount of cross charged expenditure items during Borrowed and Lent or Intercompany Billing cross charge processing. For information on transfer price rules, see: Defining Transfer Price Rules, Oracle Projects Implementation Guide.
Planning: Use rate schedules to provide rates for workplan and financial planning. You can use the same rate schedules that are used to calculate actual costs and revenue, or you can use a set of planning rate schedules to define rates for planning.
You can specify a set of planning rate schedules when you enable planning rates for a workplan structure or when you define planning options for a financial structure, budget version, or forecast version. You can also specify employee, job, non-labor, and resource class rate schedules for this purpose.
Other Sources
Rate Schedule Definition, Oracle Projects Implementation Guide