Jared, The table in question is PER_PEOPLE_F in the HR schema that links to the FND_USER table in the APPLSYS schema (column names will be obvious). However, I would suggest that any programmatic linkage be done with Oracle Support's blessings - the interactions between the schemas, workflows, etc. are quite complex. To be able to post to OAUGDBA-Net (after joining up of course), please switch your Gmail to use plain text as that Listserv will reject everything else. (Gmail defaults to Rich formatting). -- John Kanagaraj <>< DB Soft Inc http://www.linkedin.com/in/johnkanagaraj http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!) ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** On 10/19/07, Jared Still <jkstill@xxxxxxxxx> wrote: > > We are in the process of implementing provisioning of Oracle Apps user > accounts through OID. > > Provisioning the accounts works OK. > > For employees to access their own benefits in HR, their account must be > linked with their employee information. > > We can do that manually, but I am looking for a method to script this. > > Anyone here done this before? > > Thanks, > > -- > Jared Still > Certifiable Oracle DBA and Part Time Perl Evangelist > > > PS. I did try posting this to oaugnet@xxxxxxxx, but their mail server > rejects all emails from me. > Just lucky I guess. > -- //www.freelists.org/webpage/oracle-l