This discussion is archived
13 Replies Latest reply: Dec 6, 2012 10:29 AM by 962665 RSS

per_accrual_calc_functions.Get_Net_Accrual language issue

962665 Newbie
Currently Being Moderated
Hello,

I am facing a wierd issue. It is very critical.
I have built a custom page to display Accrual balances.
I use the API: per_accrual_calc_functions.Get_Net_Accrual

My customer has multiple languages.

When the session language is English, the balances shown are correct. However, when I change it to 'Canadian French', the API returns all incorrect balances or null values depending on balance type.

Below is the API trace information for English language:

-----------------------------------------------------------------
ENTERING PER_ACCRUAL_CALC_FUNCTIONS.GET_NET_ACCRUAL
for assignment 116060
--------------------------------+--------------------------------
p_assignment_id 116060
p_plan_id 65
p_payroll_id 70
p_business_group_id 82
p_assignment_action_id -1
p_calculation_date 05-DEC-2012
p_accrual_start_date
p_accrual_latest_balance
p_calling_point BP
-----------------------------------------------------------------

-----------------------------------------------------------------
LEAVING PER_ACCRUAL_CALC_FUNCTIONS.GET_NET_ACCRUAL
--------------------------------+--------------------------------
p_start_date 01-JAN-2012
p_end_date 31-DEC-2012
p_accrual_end_date 05-DEC-2012
p_accrual 40
p_net_entitlement 24
-----------------------------------------------------------------


Below is the API trace information for Canadian French language:

-----------------------------------------------------------------
ENTERING PER_ACCRUAL_CALC_FUNCTIONS.GET_NET_ACCRUAL
for assignment 116060
--------------------------------+--------------------------------
p_assignment_id 116060
p_plan_id 65
p_payroll_id 70
p_business_group_id 82
p_assignment_action_id -1
p_calculation_date 05-12-2012
p_accrual_start_date
p_accrual_latest_balance
p_calling_point BP
-----------------------------------------------------------------

-----------------------------------------------------------------
LEAVING PER_ACCRUAL_CALC_FUNCTIONS.GET_NET_ACCRUAL
--------------------------------+--------------------------------
p_start_date 01-01-2012
p_end_date 31-12-2012
p_accrual_end_date 05-12-2012
p_accrual
p_net_entitlement
-----------------------------------------------------------------

The entire execution path is same for both the trace files.
Only the 'Date Format' look different and also the final output balances are different.

Do, I need to do anything differently?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points