Monthly Archives: May 2017

Oracle Primavera Unifier Installation on Windows

 Oracle Primavera Unifier Installation on Windows      In this section, I have detailed Oracle Primavera Unifier installation 16.2 on Oracle database on Windows machine.     Follow all the pre-requisites before beginning the Primavera Unifier Installation.  I highlighted the important point in the RED color text.    1. Pre-Requisites 1.1) Follow the link for instruction [...]

Create a WebLogic Domain with OPSS security

Create a WebLogic domain with OPSS Security Pre-Requisite Make sure you have installed WebLogic 12.1.3 and ADF Runtime before continuing this section. Follow the link for instruction http://www.catgovind.com/adf/adf-runtime-installation-fmw_12-1-3-0-0_infrastructure-jar/     1. Go to <MW_HOME>\oracle_common\common\bin and double click on the config.bat     2. The WebLogic configuration wizard opens on the screen. Toggle on Create a [...]

By | 2017-05-29T13:18:49+00:00 May 28th, 2017|Categories: WebLogic|Tags: , |0 Comments

How to run SQL Tuning Advisor in SQL Developer

How to run SQL Tuning Advisor in SQL Developer   Required grants to run the SQL Advisor Login as SYSDBA and grant the below privileges to the user who is going to run the SQL ADVISOR   [crayon-59518bdcb8185886798497/]   Run SQL Tuning Advisor   Open SQL Developer >> Write the SQL >> Right Click & [...]

By | 2017-05-21T23:55:35+00:00 May 21st, 2017|Categories: Oracle|Tags: , |0 Comments

How to generate Explain plan in SQL Developer

How to generate Explain plan in SQL Developer Using Explain Plan, we can find the Order of tables executed the given SQL Index is executed or not Join statement & Order Cost & Cardinality   TO Generate Explain Plan   1. Open SQL Developer >> Open a database connection >> Write a SQL query and [...]

By | 2017-06-11T18:11:42+00:00 May 21st, 2017|Categories: Oracle|Tags: , |0 Comments

How to compare two oracle database schemas in SQL Developer Database Diff

How to compare two Oracle database schemas in SQL Developer - Database Diff  Oracle SQL Developer provides a feature called Database Diff to compare two different schemas. Using this, we can compare the tables, views, synonyms, triggers between two schemas. You need to establish a database connection before proceeding the comparison. This section, I have [...]

By | 2017-05-21T16:54:34+00:00 May 21st, 2017|Categories: Oracle|Tags: , , |0 Comments

Primavera P6 API Error: Resource tree maximum level limit of 10

Primavera P6 API Error: Resource tree maximum level limit of 10   Today my colleague got the below error while running Primavera P6 API code that creates resources in P6. It cannot create a resource more than 10 levels.    ParentObjectId: You are unable to select this parent resource because the result will exceed the Resource tree maximum [...]

By | 2017-05-19T15:28:55+00:00 May 19th, 2017|Categories: P6|Tags: , , |0 Comments

How to grant select on PXRPTUSER views to non Primavera P6 user

How to grant select on PXRPTUSER views to non-primavera p6 user  Sometimes, Other database schemas require select access to PXRPTUSER views. For example, a data warehouse (EDW) might require access to PXRPTUSER to produce an analytical report or a custom database schema may require select access. The PXRPTUSER views are referring to ADMUSER tables so the only grant VIEW [...]

By | 2017-05-19T09:15:05+00:00 May 18th, 2017|Categories: P6|Tags: |0 Comments

All you want to know about Primavera P6 – User Interface View

All you want to know about Primavera P6 - User Interface View   This section is for you if your answer is Yes in any of the following point 1. Lock some of the Activity fields, say you want to lock the cost fields to some users 2. Hide any of the P6 Project web [...]

By | 2017-05-12T19:01:07+00:00 May 11th, 2017|Categories: P6|Tags: , , , |0 Comments

Primavera P6 export project into XML failed

Primavera P6 export Project into XML failed Recently we upgraded Primavera P6 into 16.2.6 after that Exporting project into an XML failed. When I export the project and click the Download File link, it says the below message in the pop-up File not Found. Please contact the Administrator Solution: The following solution worked: 1. Log [...]

By | 2017-05-10T23:35:48+00:00 May 10th, 2017|Categories: P6|Tags: , , , |0 Comments
Like us on Facebook.
Connect!