Fluid Position Management - Add a Position returns over a million rows

Hi,

We are on Peoplesoft 9.2. - PUM37. We are implementing Fluid Position Management. When I try to 'ADD' a new position in our DEV environment the application just spins and eventually after 30 minutes it dies.

It looks like the view ps_position_src_vw being used is trying to pull back well over 1 million rows. We currently have about 166,000 rows in PS_POSITION_DATA_E

Has anybody else encountered anything like this ? Why is it pulling back so many rows when you are trying to 'Add' a brand new Position ? The DBA's tell me that its due to a cartesian join. Has anyone else encountered anything similar ? Any information would be greatly appreciated .