My Oracle Support Banner

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 12.2.1.1.0 and later
Information in this document applies to any platform.

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

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
Goal
Solution
References


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