• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

Oracle Apps

Application Engine Concepts

by admin

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 […]

Filed Under: Oracle Apps

PeopleSoft “Authorization Error – Contact your security administrator “

by admin

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: […]

Filed Under: Oracle Apps

How to Reset a Primavera P6 Application User Password

by admin

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 […]

Filed Under: Oracle Apps

Resetting an Application User’s Password in P6 Professional Using SQLite

by admin

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 […]

Filed Under: Oracle Apps

How to Change the P6 User Login Name in SQLite Database

by admin

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 […]

Filed Under: Oracle Apps

How to reset your forgotten Primavera P6 user password using database query

by admin

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 […]

Filed Under: Oracle Apps

How to delete and recreate Integrated WebLogic Server Default Domain in JDeveloper?

by admin

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 […]

Filed Under: Oracle Apps

How to read all modules assigned to user from Primavera P6 EPPM database

by admin

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 […]

Filed Under: Oracle Apps

How to check Oracle Apps/EBS version

by admin

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

Filed Under: Oracle Apps

How To Download Single Context Using FNDLOAD For Descriptive Flexfield

by admin

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 […]

Filed Under: Oracle Apps

Next Page »

Primary Sidebar

Recent Posts

  • ncat Command Examples in Linux
  • ncat: command not found
  • nautilus Command Examples in Linux
  • namei: command not found

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright