How to Reclass Projects and Tasks En Masse

December 20, 2006 on 9:20 pm | by Marian Crkon | In Feature of the Week, How To Guides | | Print Print | Email Email

Darn it. You manually set up your projects and you found out some attributes were configured incorrectly. Now what? There is good news. You can use the Project Administration feature (Oracle Projects 11i) to update Project and Task Organizations in one, easy update.

The way it works is that you create an ‘update batch’ of changes you want to apply. As Project Billing Super User [or Costing Super User], navigate to Project Administration > Mass Update Batches and generate a mass update batch:

  • Enter a Batch Name, Description, and Effective Date for the batch.
  • In the Generate Detail Lines region of the window, enter the selection criteria to select the projects and tasks you want to update.
  • Choose Generate Detail Lines to generate the mass update batch lines.
  • Review and/or revise the mass update batch by choosing Details.
  • When ready to execute the mass update, Submit the batch. The system submits a concurrent request, which completes the update.

The system will also update all related burdening and cross-charge schedules and take the new organizations into account after the change.

Enhancement Tip

Unfortunately, the Mass Update functionality is only available to update Project and Task Organizations at this point (11i). It would be great if additional attributes were available, including Start Date and Completion Date, Key Members, Project Classifications, Service Type, etc. Judging by the fact that the ‘Attribute’ field has a drop-down menu, that was probably an original intention, but it was never implemented.

Also, the batch control functions are currently not arranged in any logical order and were confusing to the users. Arranging the functions left-to-right, or right-to-left according to follow their logical work flow would make more sense.

1 Comment »

RSS feed for comments on this post. TrackBack URI

  1. Looking forward to the additional attributes. Very rarely would I find the Organization needed to be changed, but Completion Date, Project Status, Asset Type, In Service Date all good candidates for this.

    Comment by Susie — March 28, 2007 #

Leave a comment

XHTML: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Powered by WordPress with Pool theme design by Borja Fernandez.
Entries and comments feeds. Valid XHTML and CSS. ^Top^