2. 输入Lookup.EBSHRMS.ReconAttrMap.Trusted 值后单击查找按钮。
3. 单击Add按钮来新添加行。
4.在Code Key字段输入2.2节中定义的属性值，如U_ID。 5.在Decode字段输入1节中定义的属性值，如U_ID。 6.保存后关闭对话框。
2.5创建用户资源实例的同步配置
注：创建同步配置把以上的操作更新到MDS中。
1. 在 Resource Management 文件夹内的Resource Objects中搜索 Oracle EBS HRMS Trusted User。
3. 在 Object Reconciliation页内单击 Create Reconciliation Profile项并保存。
三、
更新Connector Bundle
注：必须把先前添加的新属性字段更新到Connector Bundle（org.identityconnectors.ebs-1.0.1115.jar）中。 1. 解
压
Oracle_EBS_HRMS-11.1.1.5.0/bundle/org.identityconnectors.ebs-1.0.11150.jar文件到当前目录。
2.在configuration文件夹内，编辑search.properties文件。 3. 找到HRMS_CURRENT_EMPLOYEE_RECON_QUERY和
HRMS_CURRENT_FUTURE_EMPLOYEE_RECON_QUERY对应的SQL，并添加与第2节中定义相同的属性值。 4. 保存修改结果到文件。
5. 确认新修改的SQL能够正常执行并包括新添加的字段。
6. 更新connector bundle (org.identityconnectors.ebs-1.0.11150.jar) 包，执行以下命令。
jar -cvfm META-INF/MANIFEST.MF * org.identityconnectors.ebs-1.0.11150.jar 7. 运行更新 JAR脚本来更新数据库中的connector bundle。
[oracle@idmdev bin]$ cd $OAM_ORACLE_HOME/server/bin [oracle@idmdev bin]$ ./UpdateJars.sh For running the Utilities the following environment variables need to be set APP_SERVER is weblogic OIM_ORACLE_HOME is /u01/oracle/Middleware/Oracle_IDM1 JAVA_HOME is /u01/oracle/Middleware/jdk1.7 MW_HOME is /u01/oracle/Middleware WL_HOME is /u01/oracle/Middleware/wlserver_10.3 DOMAIN_HOME is /u01/oracle/Middleware/user_projects/domains/oim_domain Executing oracle.iam.platformservice.utils.JarUpdateUtility in IPv4 mode [Enter Xellerate admin username :]xelsysadm [Enter the admin password :] Welcome1 [[Enter serverURL (Ex. t3://oimhostname:oimportno for weblogic or corbaloc:iiop:localhost:2801 for websphere)]:]t3://idmdev.tp-link.net:15000 [[Enter context (i.e.: weblogic.jndi.WLInitialContextFactory for weblogic or com.ibm.websphere.naming.WsnInitialContextFactory for websphere)]:]weblogic.jndi.WLInitialContextFactory Logging configuration class \java.lang.ClassNotFoundException: oracle.core.ojdl.logging.LoggingConfiguration log4j:WARN No appenders could be found for logger (org.springframework.jndi.JndiTemplate). log4j:WARN Please initialize the log4j system properly. Enter the jar type 1.JavaTasks 2.ScheduleTask 3.ThirdParty 4.ICFBundle 4 Enter the path/location of jar file : /home/software/connector/Oracle_EBS_HRMS-11.1.1.5.0/bundle/org.identityconnectors.ebs-1.0.11150.jar Do u want to update more jars [y/n] :n
8. 更新oim_hrms_connector用户访问权限
create or replace synonym oim_hrms_connector.XXTP_HR_IDM_PEOPLE_V for APPS.XXTP_HR_IDM_PEOPLE_V;
grant select on APPS.XXTP_HR_IDM_PEOPLE_V to oim_hrms_connector; 9. 更新成功后，重启OIM所有服务。 四、
SQL样例
4.1 HRMS_CURRENT_EMPLOYEE_RECON_QUERY
SELECT * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY person_id) Row_Num,resultTable.* FROM (
SELECT PAPF.PERSON_ID AS person_id, PAPF.FIRST_NAME AS first_name, PAPF.LAST_NAME AS last_name, PAPF.EMAIL_ADDRESS AS email_address, PPT.USER_PERSON_TYPE user_person_type, PAPF.EFFECTIVE_START_DATE AS effective_start_date, PAPF.EFFECTIVE_END_DATE AS effective_end_date, PAPF.EMPLOYEE_NUMBER AS employee_number, PPS.ACTUAL_TERMINATION_DATE AS actual_termination_date, sysdate as SYSTEM_DATE, PAPF.BUSINESS_GROUP_ID AS business_group_id, PAAF.SUPERVISOR_ID AS supervisor_id , SUP.FULL_NAME AS supervisor_name, PJ.NAME AS job, PG.NAME AS grade, HAOU.NAME AS department, PAPF.TOWN_OF_BIRTH AS town_of_birth, PPU.PERSON_TYPE_ID AS person_type_id, PAPF.REGION_OF_BIRTH AS region_of_birth, PAPF.COUNTRY_OF_BIRTH AS country_of_birth, PAPF.NATIONAL_IDENTIFIER AS national_identifier, PAPF.TITLE AS title, PAPF.MARITAL_STATUS AS marital_status, PAPF.SEX AS sex, PAPF.DATE_OF_BIRTH AS date_of_birth, PAPF.NATIONALITY