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

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 hundreds of Community platforms