Quick Retropay (Enhanced) or Retropay (Enhanced) Errors: 'FORMULA_ERROR_TEXT Data PER_ADR_REGION_1 not found at line 87 of CA_LEG_PAYROLL_ CHK'

(Doc ID 2325229.1)

Last updated on NOVEMBER 06, 2017

Applies to:

Oracle HRMS (Canada) - Version 12.2 and later
Oracle Payroll - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When running 'Quick Retropay (Enhanced)' or 'Retropay (Enhanced)' one or more employees have errors:

ERROR

HR_51121_HRPROC_ERR_OCC_ON_SFM
FMLANAME CA_LEG_PAYROLL_CHK
APP-PAY-51121: Error was encountered when processing Skip formula CA_LEG_PAYROLL_CHK
HR_6867_HRPROC_FMLA_ORA_ERR
ORACLE_ERROR_TEXT
FORMULA_ERROR_TEXT Data PER_ADR_REGION_1 not found at line 87 of CA_LEG_PAYROLL_
CHK

Cause: A SQL SELECT statement, obtained from the application dictionary,
returned no rows when executed.

Action: Please refer to your local support representa
APP-PAY-06867: An error occurred during formula execution:

Data PER_ADR_REGION_1 not found at line 87 of CA_LEG_PAYROLL_CHK


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Run Quick Retropay (Enhanced) OR Retropay (Enhanced)


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