PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Planning and Budgeting Security Groups - Automated Load

edited Jan 5, 2011 9:11AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 1 commentAnswered
Is there an automated way to load Security Groups to Planning and Budgeting from a spreadsheet instead of manually online?

We are trying to identify the most efficient way to load Planning & Budgeting Security Groups (on the BP_SECURITY_GRP component) that have already been configured and loaded in PS EPM 8.8 into the 9.0 system.  We have over 4,000 lines to load, of combinations for users with a certain role for a certain department.  I've done some initial testing of inserts into the PS_BP_SCTY_GRP_DTL table, but this did not accomplish the update. 
 
All I've seen on Peoplebooks is for the manual entry of users into the Security Group.  If you can, please let me know if you have any other recommended approach.  Thanks! 

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