ORA-01031: insufficient privileges JBO-28006: Could not create persistence table PS_TXN_seq (Doc ID 1245894.1)

Last updated on AUGUST 31, 2023

Applies to:

Symptoms

An ADF BC ("ADF Business Components") application has been developed.
It was tested and was working correctly when run from JDeveloper and the Integrated WebLogic Server.
However, in Production environment, some users report intermittent errors like:

JBO-28006: Could not create persistence table PS_TXN_seq

When forcing passivation to occur with the parameter jbo.ampool.doampooling=false, as explained in <Note:417546.1> - "How To Reproduce Problems Related to AM Passivation / Activation", the following errors occur during passivation:
(with the Java Options "-Djbo.ampool.doampooling=false -Djbo.debugoutput=console -Djbo.logging.show.function=true" set in the Project Properties)

Changes

Cause

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