You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Not getting balance value in fast formiula

Received Response
edited Aug 27, 2021 4:36PM in HCM Integrations 1 comment


Not getting balance value in fast formiula


I need to get Balance value of 'TRSR' balance and its dimension is Assignment Tax Unit Month to Date. I able to get the value in BI query pay_balance_pkg.get_value_dbi.

In fast formula I am not getting the value. I am passing correct payroll_rel_action_id,payroll_assignment_id,tax_unit_id and calc_breakdown_id. I found it by printing the log. I am using Change contexts.


 CHANGE_CONTEXTS(HR_ASSIGNMENT_ID=l_assignment_id_num,PAYROLL_REL_ACTION_ID = l_payroll_rel_action_id_num,PAYROLL_ASSIGNMENT_ID=l_assignment_id_num,TAX_UNIT_ID = l_tax_unit_id_num,CALC_BREAKDOWN_ID = l_calc_break_down_id_num)

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!