Projects - EBS (MOSC)

MOSC Banner

Following patching concurrent prgram PRC: UPDATE PROJECT SUMMARY AMOUNTS completes in error due to i

edited Oct 16, 2012 3:28AM in Projects - EBS (MOSC) 2 commentsAnswered

Hi,

After applying patching to Production, concurrent prgram PRC: UPDATE PROJECT SUMMARY AMOUNTS completes in error due to invalid status of package body PA_PROJ_ACCUM_MAIN.  This is due to RESOURCE_CLASS column doesnt exist in the view PA_PROJ_REQ_DISTRIBUTIONS_V.  Issue seems similar to Bug 14280007.

On further investigation following found. Patches were applied using merged Patchsets,  looking at worker log file found that the view is being recreated after the patch has found that the view is incorrect (see log extract).  This has run patch file pav1353.odf at 11.02:55 on Sat 13th.  Searched Oracle support for this patch file and found note: Performance Issue With Prc: Update Project Summary Amounts [ID 825764.1]

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Projects Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center