Project Partners Blog


RUP 4 Patches You May Not Be Aware Of

Oracle provides a strong resource with its recommended patch lists (RPL).  However, Project Partners is pleased to provide a  detailed list of patches that we have uncovered, either during implementations or as a result of internal testing. 

As with any patch you should always do detailed research so you can find the patch number and a description of the patch.  It is always important to investigate the patches completely, understand their compatibility with those you have already applied and how they might impact your environment, especially where customizations are concerned.  This is where the importance of testing your functionality comes into play.

With that said, below is some very useful ‘insider information’ for your review.

Patch # Module Description
6372398 PJT MRIII-MRIV:This patch fixes the Data Corruption issues and Publish Workplan errors. This is recommended for all customers using Oracle Project Management on 11i.PJ_PF.M with Rollup 3 (OR) Rollup 4.
6350124 PJT MRIII-MRIV:This patch fixes the Data Corruption issues and Publish Workplan errors. This is recommended for all customers using Oracle Project Management on 11i.PJ_PF.M with Rollup 3 (OR) Rollup 4.
6356456 PJT

 

MRII-MRIII-MRIV:This patch fixes the issue of validation not done on Task End Date against Project End Date. This is recommended for all customers using Oracle Project Foundation on 11i.PJ_PF.M with Rollup 2 (OR) Rollup 3 (OR) Rollup 4. This was confirmed during this implementation
6327679 PJT MRIII-MRIV:This patch fixes the Data Corruption issues and Publish Workplan errors. This is recommended for all customers using Oracle Project Management on 11i.PJ_PF.M with Rollup 3 (OR) Rollup 4.
6013103 PJT MRII-MRIII-MRIV:This patch ensures that no duplicate names are allowed in creation of Budget Type. This is recommended for all customers using Oracle Project Management on 11i.PJ_PF.M with Rollup 2 or Rollup 3 or Rollup 4.
6210223 PJR 1OFF:6155136:11.5.10MRIV: PRC: MAINTAIN PROJECT RESOURCES – PERSON TYPE PARAMETER ERR. Correct unique values show up in the person type parameter of  PRC: Maintain Project Resources concurrent process.
6188963 PJT 1OFF:5988895:11.5.10MRIV:ISSUES UPLOADING TIME PHASE AMOUNTS FROM MSP TO ORACLE. When time-phased data is sent to Oracle Projects for resources of ype ‘Material’ in MSP, correct amounts are sent.
6254227 PJT 1OFF:6140979:11I.PJ_PF.MRIII:PA_PROJECT_PUB.UPDATE_PROJECT ERROR ORA-6519: ACTIVE AUTONOMOUS TRANSACTION DETECTED AND ROLLED BACK.

1. While trying to update a project using PA_PROJECT_PUB.UPDATE_PROJECT AMG API, proper error message is shown if an unexpected error exists.

2. For a fully shared structure project, workplan tasks, created using PA_PROJECT_PUB.ADD_TASK AMG API, are getting reflected in Financial structure when workplan is published.

 

5582197 PJT 1OFF:ER:11.5.10MR3: SUPPORTING NEGATIVE QUANTITY / AMOUNTS IN BUDGETS & FORECASTS AND PROJECT PERFORMANCE REPORTING.

 

This is required only if your client on MRUP3. Oracle Product Development annoucement.

5767364 PJT MRIII – This patch fixes the issue of ETC being non-zero even when the plan is zero in the published version after “PRC: Update PRoject Performance Data” is run. This patch is recommended for customers who already applied patch 5582197.

 

New Behavior

       ————-

           On running “PRC:Update Project Performance Data” ETC will

           be derived as zero in the published version when the plan

           is zero and actual is negative.

 

6349469 PJT REVENUE SHOWN AT PROJECT INSTEAD OF TASK LEVEL, FUNDING AND INVOICE WIPED OUT
6315190 PJT PERCENT COMPLETE DOES NOT DOWNLOAD TO MSP
5943708 PJT Issue with locking of Budget when submitted via Excel Upload
6350124 PJT This patch fixes the issue of ‘Data Not Found’ error thrown while uploading a project from MSP having large number of tasks in concurrent mode.
6060652 PJT This patch fixes the issue of extending a project assignment’s duration and regenerating forecast not extending the planning duration of corresponding planning element in the forecast when a forecast has staffing plan as ETC source.
6021352 PJT This patch fixes the issue of ‘Data Not Found’ error thrown while uploading a project from MSP having large number of tasks in concurrent mode.
6018034 PJT This patch fixes the issue of Organization Utilization erroring out for Global Week Start Period.
5716459 PJR This patch fixes the issue of the Project Capacity differing from Planned Quantity by a few digits when the duration of the task cover is more than one period.
5367017 PJT Projects ADI Functionality for Family Pack M Rollup Patch 4. This patch fixes a bunch of issues for MSP integration.
6764527 PJT 11.5.10MRIV: MSP INTEGRATION SUPPORT FOR MS PROJECT 2007. This patch is useful if you are using MSP 2007 in your client site
7578536 PJT Support to PARTIALLY SHARED STRUCTURES IN MSP INTEGRATION. Oracle Product Development annoucement.
7021566 PJT 1OFF:6975385:11.5.10M:DOWNLOAD INTO MSP IS TAKING VERY LONG TIME OVER 10 MINUTES. This cleans up MSP Integration flows
7110689 PJT 1OFF:6969178:11i.PJ_PF.MRIII:MSP UPLOAD ADDS PEOPLE ASSIGNMENT TO TASKS. This cleans up MSP Integration flows
7119796 PJT When sending data from MSP to PJT, Physical % complete in PJT was overwritten by MSP % complete.

 

7158411 PJT 1OFF:7132911:11I.PA.M:11.5.10:SLOW PERFORMANCE FOR MSP UPLOAD DUE TO REPEATED UNNECESSARY EXECUTIONS OF AN INSERT STATEMENT. This cleans up MSP Integration flows
7292740 PJT 1OFF:7111506:11.5.10MRIII: RESOURCE NAME CHANGE IN ORACLE IS NOT IN MSP
7295051 PJT 1OFF:11.5.10M:DEFAULT VALUES FOR FIELDS COMING FROM MSP
7307406 PJT Lag time appeared in minutes when project information is received in Microsoft Project from Oracle Projects. This is now appearing in days.
7326486 PJT 1OFF:7245033:11.5.10MRIV: MSP ERROR MESSAGES DON’T PROVIDE ENOUGH DATA. MSP error messages now provide enough detail for planning resource assignments. : This cleans up MSP Integration flows by highlighting errors in upload of data from MSP to OP in particular resource assignments.
7347844 PJT 1OFF:7140682:11i.PJ_PF.MRIII:MSP SERIOUS ISSUES WITH RESOURCE ASSIGNMENTS OF NULL QUANTITY IN MSP INTEGRATION. : This cleans up MSP Integration flows 
7348655 PJT MSP update to pm_product_reference causes unique constraint violation. This has now been rectified.

 

7362336 PJT 1OFF:7246997:11i.PJ_PF.MRIV:APPLY BUTTON IN MSP PREFERENCES IS GRAYED OUT BUT IT IS STILL WORKING
6890053 PJT 1OFF:6774602:11.5.10MRUP4:MSP WORKPLAN DATA ARE NOT UPDATED IN PROJECTS FROM MSP.

 

1) When uploading the data to Oracle Projects without any change,the Workplan planned effort and cost remains same.

 

2) Actuals and Costs corresponding to resource assignment are displayed properly when periods corresponding to task assignments are updated using AMG API UPDATE_TASK_ASSIGNMENT_PERIODS when resource has actuals.

The Raw Cost Rate, Burdened Cost Rate, Bill Rate amount flags for the budget versions created through pa_budget_pub.create_draft_budget api are defaulted from the plan type setup.

Some part of this issue was faced in Enbridge and cleans up the MSP Integration flows

7438518 PJT 1OFF:7389307:11i.PJ_PF.MRIII:TRANSACTION START DATE BLANKD OUT DURING PUBLISHING FOR A TASK CREATED VIA MSP.  This cleans up MSP Integration flows
7444604 PJT 1OFF:7366360:11.5.10MRUP 3 & 4:RESOURCE NOT ASSIGNED TO PROJ PLAN LIST”

Distribution: by development (password required)

8618373 PJT Description:

Old Behavior

————

Printable page is not hounouring the following.

1. Different views and different tabs in all the Performance Reporting pages.

2. In printable page, Periodic Summary is shown with page name as ‘Periodic Analysis’.

3. Printable page is not honouring the ‘Period Filter’ available in Periodic Summary.

 

New Behavior

————

1. Now, printable page honors different views and tabs available in performance reporting pages.

2. Periodic Summary page in printable page mode will be shown with page name as ‘Periodic Summary’ only.

3. Printable page honors Period Filter in Periodic Summary page.

Helps in better usage of printable pages in Project Performance tabs

7629010 PJT Old Behavior

————

 Period filters in Project Performance Periodic pages do not display proper ‘From’ and ‘To’ values selected by the user.

 

New Behavior

 ————

 Period filters in Project Performance Periodic pages  display proper ‘From’ and ‘To’ values selected by the user.

7579744 PJT Old Behavior

     ————

       1. User is not able to save negative ETC burdened cost on a forecast

          line with positive actuals and a positive forecast.

       2. Pa_Budget_Pub.Create_Draft_Finplan API takes long time to

          create budgets.

 

     New Behavior

     ————

       1. User is able to save negative ETC burdened cost on a forecast

          line with positive actuals and a positive forecast.

       2. Pa_Budget_Bub.Create_Draft_Finplan takes less time to

          create budgets.

Helps in better usage of all options in the Project Performance: Periodic Summary page

This issue was encountered during Enbridge implementation. It helps in retaining a forecast line with equal amounts of actual and negative ETC so that the forecast is zero. It helps simulate a reversal situation.

7514128 PJT Old Behavior

    ————

      Printable page in Performance Reporting Overview page, Task

      Summary page, Resource Summary page, Periodic Summary page and

      Period to Date summary pages is showing Overview page in

      printable format always.

 

    New Behavior

    ————-

      Printable page in Performance Reporting Overview page, Task

      Summary page, Resource Summary page, Periodic Summary page and

      Period to Date summary pages is showing the current page in

      printable format.

This issue was encountered during Enbridge implementation. It helps in having the printable page options to work in Project Performance Reporting.

7502171 PJT Old Behavior

      ————

        Printable Page does not show project information in performance

        overview page of Reporting tab.

 

      New Behavior

      ————

        Printable Page shows project information in performance

        overview page of Reporting tab.

This issue was encountered during Enbridge implementation. It helps in having the printable page options to work in Project Performance Reporting.

Author: Koushik Banerjee

Leave a Reply

You must be logged in to post a comment.