Why Is Year End Pre-Process (YEPP) Failing With ORA-01006 Bind Variable Does Not Exist?
Last updated on JANUARY 13, 2017
Applies to:Oracle HRMS (US) - Version 22.214.171.124 and later
Information in this document applies to any platform.
EXECUTABLE:PYUEOY - End of Year process
When the Oracle Payroll user navigates to Submit Process and Reports > Single Request > Year End Pre processor
Why is the Oracle Payroll Year End Pre-Processor request failing with the following errors:
APP-PAY-06859: An error has been detected by another process.
Cause: During processing, the master or another slave process has detected an error,
communicated by setting the Payroll status to 'Error'. Action: Examine the error log file and payroll messages to investigate the cause of the error and Year End Pre-Process is erroring out. First Worker Process Error Message :
HR_6881_HRPROC_ORA_ERR SQLERRMC ORA-01006: bind variable does not exist
ORA-06512: at "APPS.HR_NONRUN_ASACT", line 5138 ORA-06512: at line 2
SQL_NO 1541 TABLE_NAME pay_core_utils.pop_message APP-PAY-06881: Error ORA-01006: bind variable does not exist ORA-06512: at "APPS.HR_NONRUN_ASACT", line 5138 ORA-06512: at line 2 has occurred in table pay_core_utils.pop_message at location 1541
Cause: an oracle error has occurred. The failure was reported on table pay_core_utils.pop_message at location 1541 with the error text ORA-01006: bind
variable does not exist rORA-06512: at "APPS.HR_NONRUN_ASACT", line 5138
ORA-06512: at line 2
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