Oracle Apps

PeopleSoft is widely used in local government, healthcare, and education. As the name implies, PeopleSoft’s origins rise from managing groups of people. Different types of variables in the Application Engine people code Local variable – these are available for the duration of the program in which they are declared. Global/Component – These variables are available […]

The Issue Security error on Elasticsearch configuration. After making all needed changes and saving the template, when clicking the Execute button; you get a dialog box with the following message: Authorization Error — Contact your Security Administrator (124,188) The Solution Make sure that all the users have FULL access to the following Web libraries: Note: […]

For standalone P6 Professional (PPM) users with Oracle or Microsoft SQL Server Use the Administration Configuration tool to reset application user passwords. 1. Click Start > Programs > Oracle – Primavera P6 > P6 Professional Rx.x > P6 Professional Help & Tools > Administration Configuration. 2. Enter a privileged user name (default privuser) and password […]

This post explains how to reset an application user’s password for an SQLite database. There is only one P6 user per SQLite database, so if the user gets “Invalid Username or Password” and cannot remember the password, this solution can be used to reset the password. Connecting SQLite Database 1. To connect to the SQLite […]

This post explains how to change the login username for P6 Professional Standalone supported with SQLite. P6 Professional standalone is a single user application, the user name is “admin” by default, but you can also customize the user name when creating the P6 database and configuring the connection in SQLite. 1. Firstly please double check […]

Follow this example to reset your Primavera P6 admin user password using a database query. The same solution applies to reset passwords for any user in Primavera p6. Just replace ‘admin’ with your user_name in the query mentioned in Point 2. Note: You need the ADMUSER schema access to reset Primavera P6 admin password. Reset […]

Sometimes we may have a situation where the Integrated WebLogic server has problems starting, or it takes too long time to respond back. It is simple to recreate it than to troubleshoot. In this section, we explained how to delete the Default Domain and recreate it. Delete IntegratedWebLogic DefaultDomain 1. Open JDeveleoper, Open the Application […]

Question: How to read all modules assigned to user from the Primavera P6 EPPM database? 1. Login to ADMUSER schema and run the following query to get the user_id select user_id from admuser.users where user_name = ? 2. Pass the User ID to the below query to get the assigned modules select db_engine_type as MODULE_NAME […]

Run following SQL from apps user; select RELEASE_NAME from fnd_product_groups; You should see output like: RELEASE_NAME ———————– 11.5.10.2 Make sure you run the above command using the apps user. If you are using SYS or any other user, you may use below query: select RELEASE_NAME from apps.fnd_product_groups; You should see output like: RELEASE_NAME ———————– 11.5.10.2

Descriptive Flexfields has many Context Codes based on the value of the reference field and there is a need of downloading a specific Context and then upload to other instances. Example 1 Downloading ‘Global Data Element’ and all context codes that start with JA for all Descriptive Flexfields that start with JG. $ FNDLOAD apps/password […]