Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Not getting balance value in fast formiula — Cloud Customer Connect
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
8
Views
1
Comments
edited Aug 27, 2021 4:36PM in HCM Integrations 1 comment

Summary

Not getting balance value in fast formiula

Content

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.

Register

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