Finding and Updating the GUID of a User in Oracle Application Server

1) Finding the GUID of a User a. Using SQL SQL> select guid from portal.wwsec_person$ where user_name = ‘<user_name>’; b. Using ldapsearch: ldapsearch -h myhost -p 3060 -D cn=orcladmin -w <GUI_password_for_orcladmin_user> -b “” -s sub “cn=<cn_for_problem_user>” “*” orclguid 2) Manually updating a users GUID SQL> update portal.wwsec_person$ set guid = <OID_user_GUID> where user_name =’user_name’; SQL>…

Installation and configuration of Oracle BI Applications 7.9.6 with Oracle EBS R12 and Informatica 8.6

I had a recent activity which involved configuring Oracle BI Applications to utilize the preconfigured reports that come with it. I was able to do the entire setup on my Dell Vostro with 4GB RAM and 2.2 GHz processer, but for better performance I would recommend better hardware. When I initially started I had difficulty…