My Oracle Support Banner

850 Inbound Purchase Orders Program Fails With SQL Error Message ORA-01002: Fetch Out Of Sequence (Doc ID 2867954.1)

Last updated on MAY 06, 2022

Applies to:

Oracle Order Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

850 Inbound Purchase Orders program failing:


ERROR
-----------------------
Exit ECE_INBOUND.INSERT_INTO_PROD_INTERFACE->04-MAY-2022 09:12:35
  Time Taken 0 seconds
  Program level ECE_INBOUND.RUN_INBOUND: Please check the log file, correct the problem, and try again.
  SQL error message ORA-01002: fetch out of sequence.
  An Error occured at ORIG_SYS_DOCUMENT_REF : 22050412310770500150 .



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Run 850 ECE inbound

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.