Error ORA-01002: fetch out of sequence - HRMS Aces

You are not logged in. [Log In] HRMS Aces - The Online HRMS Community » Forums » Oracle Payroll » Payroll Processes » Error ORA-01002: fetch out of sequence

Top Posters (30 Days)

SBi	31
CT	16
bcooper	15
Saqib Rahat	11
PeterP	10
EBS_USER	9
kp_rapolu	8
Geoff Dixon	8
delboy	5
MarinaH	5

(Views)Popular Topics

Family Pack K issues thread	8849
CREATE_GRADE api returns:PLS-00306: wrong number o	6175
Still trying to locate...	4660
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID	4444
Review of my Release 12 laptop	4226
Log-on problems for existing users	3538
Viewing Output of another user	3261
Family Pack K	3128
October UK-OUG?	3090
HR_PF.K RUP4	2908

Topic Options

Rate This Topic

#5253 - 03/03/10 10:49 AM Error ORA-01002: fetch out of sequence
delboy claiming squatters rights Registered: 15/03/05 Posts: 291 Loc: Somewhere in Berkshire	Has anyone seen this error message before. We are running enhanced retropay and getting the error message APP-PAY-06881: Error ORA-01002: fetch out of sequence has occurred in table pay_assignment_actions at location 4024 Can't seem to narrow it down to whether its a data issue or not. Any advice greatfully received. Delboy
Top

#5255 - 03/03/10 02:07 PM Re: Error ORA-01002: fetch out of sequence [Re: delboy]
CT veteran Registered: 11/03/05 Posts: 820 Loc: Back at Fort Apache, Gosport!	I am inclined to think it a coding issue... Will probably have been caused by one of: 1 Data is being retrieved/changed via a cursor which uses FOR UPDATE and there is a commit inside the FETCH loop, ie before the last row has been retrieved 2. A cursor attempts to fetch after the last row has been found (ie after the 1403 sqlerror) 3. If something alters one or more of the bind variables that a cursor might be using, and thereafter attempting to fetch instead of re-executing the query. Apart from that, dunno mate! _________________________ L&K CT
Top

#5257 - 03/03/10 03:49 PM Re: Error ORA-01002: fetch out of sequence [Re: CT]
delboy claiming squatters rights Registered: 15/03/05 Posts: 291 Loc: Somewhere in Berkshire	Thanks CT, I will pass your thoughts on to someone who knows what the hell that all means Regards, A mere confused funkie
Top

#5258 - 03/03/10 04:07 PM Re: Error ORA-01002: fetch out of sequence [Re: delboy]
bcooper veteran Registered: 11/03/05 Posts: 945 Loc: Earth, Europe, England, here	I've seen this issue related to rollback segments too. Occasionally alongside the "Snapshot too old" error. As you are running a standard process i would be inclined to search on Metalink Oracle's new fancy support site (if its working today) for any hits. Not related to RUP4 by any chance?? _________________________ I'm blogging again - albeit sporadically Also my random musings courtesy of Twitter
Top

#5261 - 03/03/10 04:46 PM Re: Error ORA-01002: fetch out of sequence [Re: bcooper]
delboy claiming squatters rights Registered: 15/03/05 Posts: 291 Loc: Somewhere in Berkshire	It's not a RUP4 issue. We are live on RUP4 and have already run a retropay process on it. The only hit we got was the one CT suggested re: the commit statement in a sql function being called by a fast formula. Delboy
Top

Previous Topic

Index

Next Topic

Hop to:

Moderator: CT, delboy

Oracle R12.1.1 on your existing computer

Get up and running with Oracle on your existing computer in 5 minutes

Get up and running with Oracle on your existing computer in 5 minutes!

Alard Consulting Ltd are pleased to offer Oracle R12.1.1 on your existing computer.

Connect to Oracle R12 from your computer to do client demonstrations, your own development work, or test functional setup on a Vision environment without having to install and maintain Oracle.

Backup your work before making changes in case things go wrong. Just copy the files to a new directory before making the changes. If it doesn't work, copy the files back again, all from Windows. No other skills needed.

As everything is contained on a single external hard drive, you can take it with you to use wherever you need it.

For each sale from HCMAces a portion of the price will go to the running costs of this forum.

For more information see www.alard.net/products.html.

Forum Stats

494 Members
48 Forums
1213 Topics
5734 Posts

Max Online: 51 @ 12/08/10 02:30 AM

Today's Birthdays

No Birthdays

Recent vacancies