Oracle provides a strong resource with its recommended patch lists (RPL). However, Project Partners is pleased to offer a detailed list of patches we have uncovered during implementations or as a result of internal testing.
As with any patch, you should always do detailed research to find the patch number and description. It is always important to investigate the patches thoroughly, 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 beneficial ‘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 being done on the Task End Date against the 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 to create 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 | PJ | 1OFF:6155136:11.5.10MRIV: PRC: MAINTAIN PROJECT RESOURCES – PERSON TYPE PARAMETER ERR. Correct unique values appear 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 type ‘Material’ in MSP, correct amounts are sent. |
| 6254227 | PJT | 1OFF:6140979:11I.PJ_PF.MRI: 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, a proper error message is shown if an unexpected error exists. 2. Work plan tasks are created using PA_PROJECT_PUB for a fully shared structure project.ADD_TASK AMG API is reflected in the Financial structure when the work plan 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 is on MRUP3. Oracle Product Development announcement. |
| 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 have 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 the 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 | The issue with locking of Budget when submitted via Excel Upload |
| 6350124 | PJT | This patch fixes the ‘Data Not Found’ error thrown while uploading a project from MSP with a large number of tasks in concurrent mode. |
| 6060652 | PJT | This patch fixes the issue of extending a project assignment’s duration and regenerating the forecast, not extending the planning duration of the corresponding planning element in the forecast when a prediction has a staffing plan as an ETC source. |
| 6021352 | PJT | This patch fixes the ‘Data Not Found’ error thrown while uploading a project from MSP with a 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 | PJ | This patch fixes the issue of the Project Capacity differing from the 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 helpful if you are using MSP 2007 on your client site |
| 7578536 | PJT | Support to PARTIALLY SHARED STRUCTURES IN MSP INTEGRATION. Oracle Product Development announcement. |
| 7021566 | PJT | 1OFF:6975385:11.5.10M: DOWNLOADING INTO MSP IS TAKING A VERY LONG TIME, OVER 10 MINUTES. This cleans up MSP Integration flows |
| 7110689 | PJT | 1OFF:6969178:11i.PJ_PF.MRIII: MSP UPLOAD ADDS PEOPLE ASSIGNMENTS 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 was 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 uploading 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 a 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 remain the same. 2) Actuals and Costs corresponding to resource assignments are correctly displayed when periods corresponding to task assignments are updated using AMG API UPDATE_TASK_ASSIGNMENT_PERIODS when a resource has actuals. The Raw Cost Rate, Burdened Cost Rate, and Bill Rate amount flags for the budget versions created through pa_budget_pub.create_draft_budget API defaults from the plan type setup. Some part of this issue was faced in Enbridge and cleaned up the MSP Integration flows |
| 7438518 | PJT | 1OFF:7389307:11i.PJ_PF.MKIII: TRANSACTION START DATE BLANKED 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 ———— The printable page is not honoring the following. 1. Different views and different tabs in all the Performance Reporting pages. 2. On the printable page, the Periodic Summary is shown with the page name ‘Periodic Analysis.’ 3. Printable page is not honoring the ‘Period Filter’ available in the Periodic Summary. New Behavior ———— 1. Now, the printable page honors different views and tabs available on performance reporting pages. 2. Periodic Summary page in printable page mode will be shown with the 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 cannot 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 a long time to create budgets. New Behavior ———— 1. User can 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’s implementation. It helps retain a forecast line with equal amounts of actual and adverse ETC so that the forecast is zero. In addition, 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 the Overview page in the 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 show the current page in printable format. This issue was encountered during Enbridge’s implementation. It helps to have printable page options to work in Project Performance Reporting. |
| 7502171 | PJT | Old Behavior
———— Printable Page does not show project information in the performance overview page of Reporting tab. New Behavior ———— Printable Page shows project information in the performance overview page of Reporting tab. This issue was encountered during Enbridge’s implementation. It helps to have printable page options to work in Project Performance Reporting. |
Author: Koushik Banerjee
