My Oracle Support Banner

GLXJEENT: APP-FND-01206 : This record already exists, Journal Entry Form Producing Locks on FND_DOC_SEQ_USERS (Doc ID 782619.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Oracle General Ledger - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
Form: GLXJEENT.fmb - Journal Entry


Symptoms

Journal Entry form GLXJEENT is locked on a Journal Category with Gapless Sequence assigned.

Steps to reproduce:

  1. User makes a header entry
  2. Press down arrow to go to the next form
  3. Enter the same information
  4. Save
  5. User receives error message "APP-FND-01206 : This record already exists. You entered a duplicate value or sequence of values that must be exist"
  6. This applies a row level lock on fnd_doc_sequence_users
  7. This lock is not released until the user presses "OK" on the error message box

- No other users are able to save records until the "OK" is pressed and the lock released

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
Cause
Solution
 Still Have Questions?
References

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