About Configuring Accrual Fast Formula Function Calls
Configure the ODI variables used by E-Business Suite Accrual Extract interfaces for fast formula function calls.
-
a) HR_ACCRUAL_PERIOD_GRANT_AMT
-
b) HR_ACCRUAL_BALANCE_AMT
-
c) HR_ACCRUAL_CARRYOVER_AMT
-
d) HR_ACCRUAL_ABSENCE_AMT
-
e) HR_ACCRUAL_OTHER_AMT
Optional or Mandatory
By default, Oracle BI Applications uses a SQL expression for the above mentioned five variables which is used to execute the template Fast Formulas. The SQL expression is a function call for various metrics used in Accrual extract:
-
OBIA_ACCRUAL_FUNCTIONS.GET_NET_ACCRUAL() - used in variables (a) and (b).
-
OBIA_ACCRUAL_FUNCTIONS.GET_CARRY_OVER() - used in variable (c).
-
OBIA_ACCRUAL_FUNCTIONS.GET_ABSENCE() - used in variable (d).
-
OBIA_ACCRUAL_FUNCTIONS.GET_OTHER_NET_CONTRIBUTION()- used in variable (e).
If Accrual fast formulas at source are customized this setup step is mandatory.
Applies to
This applies to all extracts done for Accrual Module from E-Business Suite 11.1.10 and R12.x.x.
Configuring ODI variable HR_ACCRUAL_PERIOD_GRANT_AMT
This variable calls functions that fetches the Period Leave Accrual granted to an Employee for a given Accrual Plan and Period.
The default value is:
OBIA_ACCRUAL_FUNCTIONS.GET_NET_ACCRUAL(PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID,PER_ALL_ASSIGNMENTS_F.PAYROLL_ID,PER_ALL_ASSIGNMENTS_F.BUSINESS_GROUP_ID,-1,PER_TIME_PERIODS.END_DATE,PAY_ACCRUAL_PLANS.ACCRUAL_PLAN_ID,PER_TIME_PERIODS.START_DATE,NULL)
When a customized function is called, the example shows the expectation from the function call when an employee receives 1.5 days of period accrual grant per accrual period:
If the template fast formula is customized the function call must also be suitably changed inside the ODI variable value.
A sample Accrual period is shown in Other Information section.
Configuring ODI variable HR_ACCRUAL_BALANCE_AMT
This variable calls functions that fetches the Balance Leave Accrual of an Assignment for a given Accrual Plan and Period.
Default value is:
OBIA_ACCRUAL_FUNCTIONS.GET_NET_ACCRUAL(PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID,PER_ALL_ASSIGNMENTS_F.PAYROLL_ID,PER_ALL_ASSIGNMENTS_F.BUSINESS_GROUP_ID,-1,PER_TIME_PERIODS.END_DATE,PAY_ACCRUAL_PLANS.ACCRUAL_PLAN_ID)
When a customized function is called, the example shows the expectation from such a function call for an employee receiving 1.5 days of period accrual grant and no Absences, Carryovers, Other Net Accruals:
If the template fast formula is customized the function call must also be suitably changed inside the ODI variable value.
Configuring ODI variable HR_ACCRUAL_CARRYOVER_AMT
This variable calls functions that fetches the Carryover amount, when a new Accrual term begins.
Default value is:
OBIA_ACCRUAL_FUNCTIONS.GET_CARRY_OVER(PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID,PAY_ACCRUAL_PLANS.ACCRUAL_PLAN_ID,PER_TIME_PERIODS.END_DATE,PER_TIME_PERIODS.START_DATE )
When a customized function is called, the example shows the expectation from such a function.
If the template fast formula is customized the function call must also be suitably changed inside the ODI variable value. A sample Accrual term is shown in Other Information section.
Configuring ODI variable HR_ACCRUAL_ABSENCE_AMT
This variable calls the function that fetch the Absence amount, of a given accrual period.
Default value is:
OBIA_ACCRUAL_FUNCTIONS.GET_ABSENCE(PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID,PAY_ACCRUAL_PLANS.ACCRUAL_PLAN_ID,PER_TIME_PERIODS.END_DATE,PER_TIME_PERIODS.START_DATE )
When a customized function is called, the following example shows the expectation from such a function.
If the template fast formula is customized the function call must also be suitably changed inside the ODI variable value.
Configuring ODI variable HR_ACCRUAL_OTHER_AMT
This variable calls the function that fetch the Other Net Accrual amounts, of a given accrual period.
Default value is :
OBIA_ACCRUAL_FUNCTIONS.GET_OTHER_NET_CONTRIBUTION(PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID,PAY_ACCRUAL_PLANS.ACCRUAL_PLAN_ID,PER_TIME_PERIODS.END_DATE,PER_TIME_PERIODS.START_DATE )
When a customized function is called, the following example shows the expectation from such a function.
If the template fast formula is customized the function call must also be suitably changed inside the ODI variable value.
Dependency
None.
Additional Information/Notes
-
Absences are always subtracted from Accrual balance.
-
Carryover is always added to Accrual balance.
-
Other Net Contributions are always added to Accrual balance, but with Appropriate sign.
For example, if Accrual balance is 10 and Other Net Contribution is 2, then Net Accrual balance is 10+2=12. If Accrual balance is 10 and Other Net Contribution is (-3), then Net Accrual Balance is 10+(-3) = 7.
The example data set shows Accrual term and Accrual period.
