My Oracle Support Banner

Generic Upgrade Mechanism Error APP-PAY-06881: Error ORA-01002: fetch out of sequence has occurred in table pay_temp_object_actions at location 1117 (Doc ID 2343414.1)

Last updated on DECEMBER 27, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, UK Payroll

When attempting to RUN Generic Upgrade Mechanism process with parameter "Update Action Type of Assignment Action"
the following error occurs.

ERROR
-----------------------
***** Processing Ass Id 285257 Status 1
Setting error text
In { pyarpp
In { pyxcra
Out } pyxcra
declare
begin
  pay_archive.process_employee(:asg_action);
end;

passing asg action = 1464158619
for assignment id = 285257
Out } pyarpp
In { pyxassu
errors encountered = 0
In { pylogseh
In { pyxpmsh
Out } pyxpmsh
In { pylogpop
Out } pylogpop
Out } pylogseh
status complete
Out } pyxassu
Oracle error occurred
Table=pay_temp_object_actions
sqlno=1117
ORA-01002: fetch out of sequence

In { pyomcrc
Main processing returned failure
In { pyopnlr
Out } pyopnlr
In { pyoupas
pactid = 1911620
action type = X
current value of action_status = 1,P
Out } pyoupas
Out } pyomcrc
In { pyfldlf
.
.
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01002: fetch out of sequence

SQL_NO 1117
TABLE_NAME pay_temp_object_actions
APP-PAY-06881: Error ORA-01002: fetch out of sequence has occurred in table pay_temp_object_actions at location 1117

Cause: an oracle error has occurred. The failure was reported on table pay_temp_object_actions at location 1117 with the error text ORA-01002: fetch out of sequence
.

Action: Please contact your support representative.

In { pyxipmt
message text = Error ORA-01002: fetch out of sequence has occurred in table pay_temp_object_actions at location 1117

Cause: an oracle error has occurred. The failure was reported on table pay_temp_object_actions at location 1117 with the error
message level = F,F
payroll_id text = 0
source_id text = 7,1911620
line_text = 38, Error ORA-01002: fetch out of sequence
line_text = 63, has occurred in table pay_temp_object_actions at location 1117
line_text = 0,
line_text = 135, Cause: an oracle error has occurred. The failure was reported on table pay_temp_object_actions at location 1117 with the error
Out } pyxipmt


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Generic Upgrade Mechanism process with parameter "Update Action Type of Assignment Action"


Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.