My Oracle Support Banner

R12 E-Business Suite Applications Technology Stack Forms Logout Fails With Error ' Oracle error-1002: ORA-01002. fetch out of sequence has been detected in FND_SIGNON_AUDIT_END' After 27468057 (CPU April 2018) (Doc ID 2433220.1)

Last updated on AUGUST 10, 2018

Applies to:

Oracle E-Business Suite Technology Stack - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

E-Business Suite R12 Applications Technology Stack, Forms for Applications Technology

 

 

 

 

After applying the E-Business Suite April 2018 CPU on a 12.1.3 instance, users attempts to logout fail with the following error:


'Oracle error-1002: ORA-01002. fetch out of sequence has been detected in FND_SIGNON_AUDIT_END'


The issue can be reproduced at will with the following steps:
1. Access the application
2. Launch forms
3. Try to close the forms
4. Above mentioned error is encountered


The issue has the following business impact:
Due to this issue, users cannot close forms without errors

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.