How are you handling mass updates to existing business units (P0006)

morglum666

Well Known Member
Hi All,

We've had a corporate re-org and as a result we need to modify a bunch of category codes on business units. This should be a simple task. Unfortunately, it appears (and oracle confirmed) there is no mass update other than to key them in manually. They gave me this but its a pitiful answer:

Bug 11032948 : UPDATE BUSINESS UNIT CATEGORY - SAR: 8952270

Issue: There is a need to update Business Unit Category
Codes on a global baisis. There could be hundreds if not
thousands of business units

Created in Jan of 2010 without a fix.

How are you handling such requests? I am half way there to creating custom code, as the accountants are very unimpressed at the fact they can use excel to mass create new BU's, but not edit old ones.

Any advice appreciated.

Malcolm
 
SQL

Unless you reorg on a regular basis and need to write a app that user's can use just SQL it.
 
Malcolm,

We went through a major restructure that resulted in mass Cost Centre/Business Unit changes in F0006. We did just as Larry said, we used SQL to update the F0006.
 
Back
Top