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 18.104.22.168.0 to 22.214.171.124.0
Information in this document applies to any platform.
You have developed an ADF Faces/BC application in ADF 126.96.36.199.0.
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