Why Is Year End Pre-Process (YEPP) Failing With ORA-01006 Bind Variable Does Not Exist? (Doc ID 403676.1)

Last updated on JANUARY 13, 2017

Applies to:

Oracle HRMS (US) - Version 11.5.10.2 and later
Information in this document applies to any platform.
EXECUTABLE:PYUEOY - End of Year process





Goal

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:

HR_6859_HRPROC_OTHER_PROC_ERR
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

 

Solution

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