Fusion Global Payroll: Error In Fast Formula - Context PAYROLL_ASSIGNMENT_ID Was Used When Not Set (Doc ID 1613239.1)

Last updated on OCTOBER 10, 2016

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.1.7.0.0 and later
Oracle Fusion Global Payroll - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Symptoms

When running QuickPay for a terminated employee in Saudi Arabia (Final Settlement Process), the process completes in error, within the log file for the process, an error message appears.

Error

HR_51118_HRPROC_ERR_OCC_ON_ASGASGNO 80
AFDICT_APP_PREFIX-PAY-1635156: Error was encountered when processing payroll relationship 80.
HR_51119_HRPROC_ERR_OCC_ON_ETETNAME Gratuity
AFDICT_APP_PREFIX-PAY-1635252: An error occurred when processing element {ELEM_NAME. (ETNAME=Gratuity) HR_51120_HRPROC_ERR_OCC_ON_FMLFMLANAME SA_GRATUITY_CALCULATION
AFDICT_APP_PREFIX-PAY-1635031: An error occurred when processing formula SA_GRATUITY_CALCULATION.
HR_6867_HRPROC_FMLA_ORA_ERR ORACLE_ERROR_TEXT FORMULA_ERROR_TEXT Formula GRATUITY_BASE_SALARY_FF, line 18, context PAYROLL_ASSIGNMENT_ID was used when not set.
AFDICT_APP_PREFIX-PAY-1635399: An error occurred during formula execution. Contact your support representative. (ORACLE_ERROR_TEXT=) (FORMULA_ERROR_TEXT=Formula  GRATUITY_BASE_SALARY_FF, line 18, context PAYROLL_ASSIGNMENT_ID was used when not set.)
Formula GRATUITY_BASE_SALARY_FF, line 18, context PAYROLL_ASSIGNMENT_ID was used when not set.


The issue appears to be when accessing the DBI EE_BASIC_PAY_AMOUNT_ASG_ENTRY_VALUE within the following Formula:

//
DEFAULT FOR PAY_EARN_PERIOD_START  is '0001/01/01 00:00:00' (date)
DEFAULT FOR PAY_EARN_PERIOD_END is '4712/12/31 00:00:00' (date)
DEFAULT FOR EE_BASIC_PAY_AMOUNT_ASG_ENTRY_VALUE is 0

l_basic_pay = 0
l_housing_pay = 0
l_transport_pay = 0
MONTHLY_SALARY = 0

l_basic_pay = EE_BASIC_PAY_AMOUNT_ASG_ENTRY_VALUE /12
l_housing_pay = l_basic_pay * 0.25
l_transport_pay = l_basic_pay * 0.1

MONTHLY_SALARY = l_basic_pay + l_housing_pay + l_transport_pay

RETURN MONTHLY_SALARY
//

 

Attempted to introduce using get_context / change_context as follows, but this did not solve the issue:

l_pay_assign_id = get_context(PAYROLL_ASSIGNMENT_ID, -1)
CHANGE_CONTEXTS(PAYROLL_ASSIGNMENT_ID = l_pay_assign_id)


Steps To Reproduce
1. Define Gratuity Fast Formula of Type Payroll to reference DBI
2. Run QuickPay for terminated employee.
3. Fast Formula error is encountered during the QuickPay run.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms