How to export Primavear P6 admin_config table using SQL Developer and import using SQLLDR

How to export Primavear P6 ADMUSER admin_config table using SQL Developer and import using SQLLDR     Export the ADMIN_CONFIG table    Open the SQL Developer and create connection to ADMUSER account where you want to export the ADMIN_CONFIG table . Below are my local ADMIN_CONFIG records I am going to export. As I highlighted [...]

By | 2019-10-10T10:49:26+00:00 October 10th, 2019|Categories: P6|Tags: , |0 Comments

P6 Classic EPS page not loaded: javax.net.ssl.SSLException: Received fatal alert: unexpected_message

Primavera P6 Classic EPS Page not loaded: javax.net.ssl.SSLException: Received fatal alert: unexpected_message   The Primavera P6 classic page ( Applets ) are not loaded after we updated to the Java 8 Update 171 . We got the below error in the Java Console    [crayon-5db0581fdde5c556764732/]     Solution:    The page loaded well after we unchecked  [...]

By | 2019-10-03T12:16:17+00:00 October 3rd, 2019|Categories: P6|Tags: |0 Comments

How to count ADMUSER tables in Oracle

How to count Primavera P6 ADMUSER tables in Oracle    Counting ADMUSER table is helpful to find which tables holds large number of records. By this, we can truncate temp tables, and optimize other costly tables like remove wasted space, gather stats to improve the performance of Primavera P6 .    The below query list [...]

By | 2019-09-10T11:02:57+00:00 September 10th, 2019|Categories: P6|Tags: , , , |Comments Off on How to count ADMUSER tables in Oracle

How to Shrink ProjectSecurity Table in Primavera P6

How to Shrink ProjectSecurityTable in Primavera P6       The ADMUSER.PROJECTSECURITY table is one of the costly table in the Primavera P6 . Whenever The ProjectSecurity runs inside the P6 ( See Above) , the PROJECTSECURITY table size get increases. This causes increase in Wasted Space in the table-space . Soon this will cause [...]

By | 2019-08-30T14:55:58+00:00 August 30th, 2019|Categories: P6|Tags: , |Comments Off on How to Shrink ProjectSecurity Table in Primavera P6

How to create maven build POM file for Oracle BPEL 12.1.3 project

How to create maven build POM file for Oracle BPEL 12.1.3 project   Before proceed to create POM file. We need to create Oracle SOA repository. The following command will create the repositotirs.    Assume the  Oracle BPM 12.1.3 installed on the directory C:\Oracle\Middleware\Oracle_Home   Set the following property    [crayon-5db0581fdf457652826631/]   Download the wagon-http-2.8-shaded.jar and [...]

By | 2019-08-17T00:16:48+00:00 August 16th, 2019|Categories: BPEL|Tags: |Comments Off on How to create maven build POM file for Oracle BPEL 12.1.3 project

How to turn Off the Global Scheduled Services through SQL Query in Primavera P6

How to turn off the Global Scheduled Services through SQL query in Primavera P6  In this section, we will see how to turn Off or On the following Global Scheduled Services through Oracle SQL Query      Log into ADMUSER account. The following query list the 5 Global Scheduled Services    select * from admuser.jobsvc [...]

By | 2019-08-17T00:16:28+00:00 August 16th, 2019|Categories: P6|Tags: |Comments Off on How to turn Off the Global Scheduled Services through SQL Query in Primavera P6

How to Share XER Files Without the Costs?

People who work with Primavera P6 XER files often have to reserve some types of data for themselves when sharing the project file with other parties. I’ve been asked by a general contractor in a construction company how to send the project XER file to sub-contractors without the cost rates. There might be more than [...]

By | 2019-05-07T07:20:58+00:00 May 7th, 2019|Categories: P6|Tags: |Comments Off on How to Share XER Files Without the Costs?

5 Time-Saving Primavera P6 Tips

If you are a frequent user of Primavera P6 or if it is the main application that you daily use for your work, then you already know that it is one of the most NOT automated applications when it comes to data entry, it may be one the quickest and most accurate applications when it [...]

By | 2019-02-14T10:31:10+00:00 February 14th, 2019|Categories: P6|Tags: |Comments Off on 5 Time-Saving Primavera P6 Tips

How to schedule a Oracle BPEL process using Oracle Enterprise Schedule Service

How to schedule an Oracle BPEL process using Oracle Enterprise Schedule Service   In my previous post, I have explained the installation of Oracle Enterprise Schedule Service . This post, I walk through on invoking an Oracle BPEL process every one-minute using OESS. Here below is my depleted sample Oracle BPEL composite that I am [...]

By | 2018-08-05T19:26:33+00:00 August 5th, 2018|Categories: BPEL, WebLogic|Tags: |Comments Off on How to schedule a Oracle BPEL process using Oracle Enterprise Schedule Service

How to install Oracle Enterprise Scheduler 12C

How to Install Oracle Enterprise Scheduler  12C   This post, I have explained the installation of Oracle Enterprise Scheduler 12.1.3 on Windows machine. OES is used to create schedules like a UNIX CRON job in WebLogic server, For example, we can create a job that invokes a Webservice Or Java process every night. I often [...]

By | 2018-08-05T15:43:49+00:00 August 5th, 2018|Categories: WebLogic|Tags: |Comments Off on How to install Oracle Enterprise Scheduler 12C
Like us on Facebook.
Connect!