13 Replies Latest reply: Dec 6, 2012 12:29 PM by 962665 RSS

    per_accrual_calc_functions.Get_Net_Accrual language issue

    962665
      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?