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'
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.
When running 'Quick Retropay (Enhanced)' or 'Retropay (Enhanced)' one or more employees have errors:
APP-PAY-51121: Error was encountered when processing Skip formula CA_LEG_PAYROLL_CHK
FORMULA_ERROR_TEXT Data PER_ADR_REGION_1 not found at line 87 of CA_LEG_PAYROLL_
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
The issue can be reproduced at will with the following steps:
Run Quick Retropay (Enhanced) OR Retropay (Enhanced)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms