My Oracle Support Banner

AM Activation Creates Duplicate Row When Primary Key Is Populated Through a DB Sequence. (Doc ID 1296256.1)

Last updated on MARCH 03, 2021

Applies to:

Oracle JDeveloper - Version to
Information in this document applies to any platform.


You have developed an ADF Faces/BC application in ADF
One ADF Faces page is used to create detail records.
The Detail key attribute gets its value assigned from a DB sequence through code added in the Entity Object create() method:

The application works fine, except under heavy load, where the insertion of a second detail record  duplicates the previous record.
By disabling AM pool (jbo.ampool.doampooling=false), as explained in
<Note 417546.1> - How To Reproduce Problems Related to AM Passivation / Activation,
you can reproduce the problem at will.

It works fine when the key is entered manually by the end user (with the aforementioned code removed).
It works fine under normal conditions (jbo.ampool.doampooling=true and no load on the system).




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

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