Create the ADF Persistence Objects (PS_TXN, PS_TXN_SEQ) Using a Custom Name
(Doc ID 2667233.1)
Last updated on MAY 12, 2020
Applies to:Oracle JDeveloper - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
We have built an ADF app. Whenever business users try to launch the App, it's taking very long time to fully load actual page approximately around 10 mins every time.
We see below errors on the log files.
• JBO-28006: Could not create persistence table PS_TXN_seq
• java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
We searched in Oracle Support and understood that ADF app creates below objects to maintain the session info and additional details. However, Customer is not comfortable to create the tables without any prefix as it is gonna raise red flags with Application support team.
Is there any alternate way for creating these objects in the DB with some prefix like "XX"?
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