Writing Formulas for Default Assignment Costing (Oracle HRMS)

Writing Formulas for Default Assignment Costing

You can write a formula to specify the cost allocation key flexfields and their proportions that you use for default assignment costing.

Note: As a prerequisite, you must set the profile option HR: Default Assignment Costing to Yes.

To write a formula for default assignment costing:

Open the Formula window.
Required: enter the formula name exactly as below:
- PER_DFLT_ASG_COST_ALLOCATION
Select a formula Type of Element Input Validation.
Enter a Description of the formula.
Choose the Edit button.
Write the formula. Oracle HRMS provides the following inputs:
- assignment_id (number)
- business_group_id (number)
- position_id (number)
- effective_date (date)
Note: Because no context is set, do not use FastFormula Database Items. Instead, use functions for complex formulas.

Use the sample code below as a guideline in writing your own formula.
```
USE_FORMULA = 'Y'
```
```
COST_ALLOCATION_KEYFLEX_ID1 = 101
```
```
COST_ALLOCATION_KEYFLEX_ID2 = 102
```
```
COST_ALLOCATION_KEYFLEX_ID3 = 103
```
```
PROPORTION1 = .5
```
```
PROPORTION2 = .3
```
```
PROPORTION3 = .2
```
```
RETURN USE_FORMULA,
```
```
COST_ALLOCATION_KEYFLEX_ID1, PROPORTION1,
```
```
COST_ALLOCATION_KEYFLEX_ID2, PROPORTION2,
```
```
COST_ALLOCATION_KEYFLEX_ID3, PROPORTION3
```
If the application does not return a value for USE_FORMULA; or, if the value for USE_FORMULA is not equal to 'Y', the default assignment costing will not use the accounts and proportions returned by the formula. Instead, default assignment costing will be calculated based on the position control budget for the business group, if one has been defined.

If USE_FORMULA = 'Y',the application creates the default assignment costing with the cost allocation flexfield id (COST_ALLOCATION_KEYFLEX_ID%) and the related proportion (PROPORTION%).
- If the COST_ALLOCATION_KEYFLEX_ID% does not contain a valid cost allocation id for the business group,then that entry will be ignored.
- If the PROPORTION% is greater than 1, it will be treated as 1.
- If the PROPORTION% is less than 0, the entry will be ignored.