Create the ADF Persistence Objects (PS_TXN, PS_TXN_SEQ) Using a Custom Name (Doc ID 2667233.1)

Last updated on JUNE 28, 2021

Applies to:

Goal

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"?
 

Solution

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