The following instructions give details about the Rate Schedule Definition steps in the Oracle Project Foundation Product Implementation Checklist.
You can define four types of rate schedules in Oracle Projects. You specify one of the following schedule types for each rate schedule you define:
Employee - Use this type of rate schedule to define standard hourly rates or percentage markups by employee.
Job - Use this type of rate schedule to define standard hourly rates by job title. When you enter a job-based rate schedule, you enter a job group to indicate which jobs are used to determine rates.
Non-Labor - Use this type of rate schedule to define rates or percentage markups by non-labor expenditure type or non-labor expenditure type and non-labor resource combination.
Resource Class - Use this type rate schedule to define planning rates by resource class or by resource class and organization combination.
Note: In a multi-organization environment, you can share rate schedules across different operating units, or have different rates for the same resource in different operating units.
You can use the different types of rate schedules for various purposes in Oracle Projects:
Costing: Use cost rate schedules to maintain hourly cost rates for employees or jobs. You can use both the employee and job rate schedule types as cost rate schedules.
Billing: Use bill rate schedules to maintain the rates and percentage markups over cost that you charge clients for your labor and non-labor expenditures. You can also use bill rate schedules in transfer price rules to determine how Oracle Projects calculates the transfer price for cross charged expenditures. You can use the employee, job, and non-labor rate schedule types as bill rate schedules.
Planning: Use either actual rates or planning rate schedules to determine rates for workplan and financial planning. All four rate schedule types can be used as planning rate schedules.
You can define or copy rate schedules for your entire organization. You can also define or copy separate schedules for individual business units.
Note: Use a naming convention to distinguish between the different uses for rate schedules. No system attribute is available to distinguish among the uses.
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.
For further information about rates in Oracle Projects, please see Rates: Oracle Projects Fundamentals.
You can define employee, job, non-labor, and resource class rate schedules.
Define Organizations.
Define Employees.
Define Jobs. See: Define Jobs, Implementing Oracle HRMS.
Define Implementation Options. See: Implementation Options.
Define Expenditure Types. See: Expenditure Types.
Define Non-Labor Resources. See: Non-Labor Resources.
Define Resource Classes. See: Resource Classes.
Specify the operating unit to which your organization and rate schedule belong.
When you have access to only one operating unit, that operating unit appears as a default value in this field.
Specify the organization that maintains the schedule.
The organization you enter can be any organization from your organization hierarchy, regardless of whether the organization has the Expenditure Organization classification, and regardless of the start and end dates for the organization.
Enter a schedule name and a description of the schedule.
Specify a currency for the schedule.
Note: You can specify a different currency for your Bill Rate Schedule if the Enable Multi Currency Billing option is enabled for the operating unit. See: Enable Multi Currency Billing, Billing Implementation Options, Oracle Projects Implementation Guide.
Check the Share Across Operating Units check box to allow other operating units to use this schedule.
Note: To share bill rate schedules, you must also enable the Share Bill Rate Schedules Across Operating Units options in the Billing tab of the Implementation Options window. See: Share Bill Rate Schedule Across Operating Units, Billing Implementation Options, Oracle Projects Implementation Guide.
Select a schedule type.
Depending on the schedule type, specify rates or markups for employees, job titles, non-labor expenditure types, or resource classes.
Save your work.
Attention: Retroactive changes to rates and markups do not automatically create adjustments. You need to adjust and recalculate revenue or costs for affected items manually.
You can use employee rate schedules as planning schedules, cost rate schedules, and bill rate schedules.
Specify the organization, name, description, and currency and indicate whether to share the schedule across operating units.
Select the Employee tab.
Enter an employee.
Note: If your system is set up for cross business group access, you can select an employee from any business group. If you are using single business group access, you can only select an employee from the business group associated with your current responsibility. See: Setting the Cross Business Group Profile Option, Oracle Projects Implementation Guide.
Enter either a rate or a markup percent for the employee.
Enter an effective from date for the schedule line. Optionally, enter an effective to date.
You can use job schedules as planning rate schedules, cost rate schedules, and bill rate schedules.
Specify the organization, name, description, and currency and indicate whether to share the schedule across operating units.
Select the Job tab.
Select a job group
Enter a job. You can choose any active job associated with the job group you selected.
Enter a rate for the job.
Enter an effective from date for the schedule line. Optionally, enter an effective to date.
Note: When a project uses a job-based bill rate schedule, the job group on the schedule must match the project's billing job group. If you need to change to a different schedule, only those schedules that match the project's billing job group are allowed.
You can use non-labor rate schedules as planning rate schedules, cost rate schedules, and bill rate schedules. When using a non-labor rate schedule as a bill rate schedule, all expenditure types that you want to bill must be enabled. If you want to bill at cost, you must enter a 0% markup.
Specify the organization, name, description, and currency and indicate whether to share the schedule across operating units.
Select the Non-Labor tab.
Select an expenditure type. You can select any active expenditure type associated with a non-labor expenditure type class.
Optionally, enter a non-labor resource if the expenditure type is associated with the Usage expenditure type class.
If the expenditure type is defined with the rate required option enabled, then you can enter either a rate or a mark up percent. Otherwise, you must enter a markup percent.
Enter an effective from date for the schedule line. Optionally, enter an effective to date.
Suggestion: When you define bill rates for expenditure types that relate to inventory items, it is recommended that you use cost markups instead of rates. When you specify a bill rate for an expenditure type that relates to inventory items, the base unit of measure for inventory transactions reported under the expenditure type must be the same as the unit of measure for the expenditure type. If the base unit of measure for an inventory transaction differs from the unit of measure for the expenditure type, then the revenue distribution process reports an error and does not process the transaction.
You can use resource class rate schedules only as planning rate schedules.
Specify the organization, name, description, and currency and indicate whether to share the schedule across operating units.
Select the Resource Class tab.
Select a resource class.
Optionally, enter an organization. The organization can be any active organization.
Note: If your system is set up for cross business group access, you can select an organization from any business group. If you are using single business group access, you can only select an organization from the business group associated with your current responsibility. See: Setting the Cross Business Group Profile Option, Oracle Projects Implementation Guide.
If necessary, specify a unit of measure. If the resource class is people or equipment, the system automatically sets the unit of measure to hours. Otherwise, you must specify the unit of measure.
Enter a rate and a markup percent as appropriate. You can enter both a rate and a markup percent for the same resource class and organization combination. If you enter both a rate and a markup percent, the system uses the markup percent if the unit of measure is currency. Otherwise, the system uses the rate. Minimally, you must enter either a rate or a markup percent. If you enter a markup percent, you must enter a value greater than zero.
Enter an effective from date for the schedule line. Optionally, enter an effective to date.
To minimize the effort of creating new rate schedules, you can copy existing rate schedules. You can then modify the newly copied schedules.
In the Rate Schedules window, query the rate schedule that you want to copy.
Click Copy Rate Schedule.
Enter the following details for the new rate schedule:
Organization: The default value is copied from the organization of the source rate schedule.
Schedule
Description
Currency: The default value is copied from the source rate schedule.
Share Across Operating Units: Indicate whether you want to share this schedule across operating units. The default value is copied from the source rate schedule.
Rate Escalation %: Specify a numeric factor to increase or decrease the source rate schedule rates.
Markup Escalation %: Specify a numeric factor to increase or decrease the source rate schedule markup rates.
Click OK.