Projects - EBS (MOSC)

MOSC Banner

Project Gating Statuses

edited Jul 18, 2011 7:14PM in Projects - EBS (MOSC) 5 commentsAnswered

Hi

Currently we are using 7 project statuses, now client wants them to be reduced to 3.

So we have set-up the 3 new statuses and changing them on project types, templates manually.

But to to change the statuses on all projects ( more than 500) we want to use the below mentioned statement.

Could you please advise if there will be any issues if we do the changes?

update pa_projects_all
set PROJECT_STATUS_CODE = 'xxx'
where PROJECT_STATUS_CODE in (xxx,xxx)

Please advise.

Thanks,

Shiv

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center