NW7.02 JAVA AS - how to pull UME info from the DB

[Former Member]

Experts,

We have a NW7.02 Pure JAVA AS (not portal, just AS) running on AIX 6.1 with Oracle 11g DB.

This JAVA AS is a customer front-end for our ECC back-end. 

We have customized the UME to add a tab for all users called "Customized Information".

Within that tab, we have field called objkey_0 which contains the customer's Business Partner number.

Customers create an account, then by accessing the back-end, we add a their Business Partner number that that tab/field noted above.

we have over 50,000 users that have registered in the UME.

I'd like to be able to list out all those business partner numbers. 

is there a particular DB command I could run to pull that data direct from Oracle?  Or is there a better way than that?

Thanks!

NICK

[Former Member · Accepted solution]

I ended up pulling all the ume records from /useradmin, then exporting them to a text file, then used grep to get what I needed.

[Former Member]

Hi Nick,

Try getting this info from table UME_STRINGS.

Check out :

http://scn.sap.com/thread/1374638

Also take help of the developer who customized the i-view.

Regards.

Ruchit.

[Former Member]

Ruchit.

Thanks for that post.  Not quite what I was looking for.  Like I said in my post, this isn't an iview, this isn't portal.

[Former Member]

Hi Nick,

Even if you ignore the i-view part the UME_STRINGS table culd potentially be checked.Point is this infowould be getting saved inthe DB somewhere and probably UME_STRINGS is the best place to start looking from.

Regards.

Ruchit.