Auto Create User Profiles

RE: Mapping EMPLID

Wed, 03 Jun 2009 11:56:49 +0100

I did something like this once. Modify FUNCLIB_LDAP.LDAPAUTH.FIeldDefault record PeopleCode. At the end of the DNToID() function, locate the line that reads [i]if &curDN "" Then[/i]. Add the following code from the commented modification below: If &curDN "" Then &AttribsDoc = &DirEntriesDoc.GetDoc("Attribute"); &ret = &AttribsDoc.GetValue("Attribute_Name", &userIdAttr); &ret = &AttribsDoc.GetValue("Value", &userID); /*MOD by Brent Martin 6/10/05 - Get User ID from Employee ID which is stored in Active Directory */ &sql_oprid = CreateSQL("select OPRID from psopralias where emplid = :1 and OPRALIASTYPE = 'EMP'", &userID); &ret = &sql_oprid.Fetch(&userID); /*MOD END */ Return &userID; End-If; - Brent Martin

...

Wed, 03 Jun 2009 03:25:52 +0100

How do I map the empId from PSOPRDEFN table and the empId in LDAP - Active Directory? The mapping is based on the SignonUserId by default. Can I change it? Any suggestion would be highly appreciated !! - swarat

RE: Integration Broker: Unable to load message data into staging tables

Fri, 16 Nov 2007 20:04:37 +0100

Unfortunately I haven't worked with ELM in over a year and I just don't remember. It's probably an easy answer for PeopleSoft support though. - Brent Martin

Integration Broker: Unable to load message data into staging tables.

Fri, 16 Nov 2007 05:00:00 +0100

Thanks for the article it is very helpful. I'm working on integrating Peoplesoft HRMS 9.0 with Peoplesoft ELM 9.0 with Peopletools 8.49. While configuring Full Sync EIPs for Person and Organization Data, I was able to successfully run the SETID_INTIALIZE, COUNTRY_FULLSYNC, STATE_FULLSYNC, CURRENCY_FULLSYNC EIPâ€™s. Next I have configured DEPT_FULLSYNC in HRMS which has rowset based message. Now, in ELM I have LM_DEPT_FULLSYNC which is also rowset based and uses a staging table whoâ€™s structure is different from DEPT_FULLSYNC(HRMS) message structure. ELM also has a DEPT_FULLSYNC service operation which is non-rowset based. I tried setting up DEPT_FULLSYNC (HRMS) with both LM_DEPT_FULLSYNC and DEPT_FULLSYNC (ELM) but ran into errors. Can you please shed some light on ; I.Which corresponding service operation needs to be configured and activated at ELM ( LM_DEPT_FULLSYNC or DEPT_FULLSYNC) II.If it is LM_DEPT_FULLSYNC then is their any additional settings needed to utilize transformation program. Regards, --TH-- - TH

RE: Security

Tue, 12 Jun 2007 15:44:06 +0100

User ID Types allow you to specify how a user interacts with the system. You can set up users as Employees, Customers, Vendors, etc. You'll notice this is a scroll area, so users can be set up with multiple ID types. Each ID type has its own prompt table, so if a user has an ID Type of Employee, you can set a valid employee ID. If a user has a type of Customer, you can set a valid Customer ID. You enable User ID types and define their prompt tables at PeopleTools > Security > Security Objects > User Profile Types. Self service applications like Employee Expenses depend on this relationship to be established to provide basic application functionality and security. Relationships are stored on the PSOPRALIAS table. - Brent Martin

Security

Tue, 12 Jun 2007 13:45:03 +0100

What is the significance of user id type in user profile (security) and needed details on the translate values of user id type . - Anita

Comment from Vijayshree

Wed, 03 Jan 2007 22:53:23 +0100

Hi ,
I do not have any LDAP or Active directory setup with me .
Can I create user profiles for 20,000 users or more than that in PeopleSoft enterprise one with using Autoprofile or any Auto method?
Thanks,
Vijayshree - Vijayshree

...

Sat, 11 Nov 2006 08:14:11 +0100

Assuming you're talking about changing everyone's operator ID, you can get a good list of the basic security tables that you'll need to update from the USEREXPORT.DMS data mover script.

If you want to maintain your user's existing run controls, you'll have to update a lot more tables. There are probably several ways to identify them, but my favorite way is to turn on SQL Trace, delete a user, and see what tables it attempted to delete data from.

Updating e-mail addresses involves fewer tables. In HRMS 8.8, the tables that have E-mail address include PSOPRDEFN, PS_ROLEXLATOPR, PSUSEREMAIL, PS_EMPLOYEES, PS_EMAIL_ADDRESSES, PS_HR_APPS_EMAIL. - Brent Martin

Comment from Jag

Thu, 09 Nov 2006 16:32:58 +0100

Good one..Have an similar requirement, If I need to migrate all the existing Peoplesoft userids(which ends with e-mail suffix such as gmail.com) into new userids (to some ending suffix like yahoo.com). The requirement is due to merger and change in email ids through out the organisation, how can we handle this? - Jag