EBS HRMS 定制化配置
一、 扩展 Connector Schema
修改Oracle_EBS_HRMS-11.1.1.5.0/ scripts/OIM_EMPLOYEE_WRAPPER.pck文件中的属性定义，标注红色的为修改和添加的内容。
procedure get_schema( schemaout OUT schemalist ) AS
attr attributelist; BEGIN
schemaout := schemalist(); schemaout.extend(1); attr := attributelist(); attr.extend (56);
attr (1) := attributeinfo('HIRE_DATE','date',1,1,0,1); attr (2) := attributeinfo('BUSINESS_GROUP_ID','varchar2',1,1,0,1);
attr (3) := attributeinfo('LAST_NAME','varchar2',1,1,1,1); attr (4) := attributeinfo('FIRST_NAME','varchar2',1,1,1,1); attr (5) := attributeinfo('SEX','varchar2',1,1,0,1);
attr (6) := attributeinfo('PERSON_TYPE_ID','varchar2',1,1,0,1); attr (7) := attributeinfo('EMPLOYEE_NUMBER','varchar2',1,1,0,1);
attr (8) := attributeinfo('PERSON_ID','varchar2',1,1,0,1); attr (9) := attributeinfo('TITLE','varchar2',1,1,0,1);
attr (10) := attributeinfo('EMAIL_ADDRESS','varchar2',1,1,0,1); attr (11) := attributeinfo('MARITAL_STATUS','varchar2',1,1,0,1);
attr (12) := attributeinfo('NATIONALITY','varchar2',1,1,0,1); attr (13) := attributeinfo('NATIONAL_IDENTIFIER','varchar2',1,1,0,1);
attr (14) := attributeinfo('DATE_OF_BIRTH','date',1,1,0,1); attr (15) := attributeinfo('TOWN_OF_BIRTH','varchar2',1,1,0,1); attr (16) := attributeinfo('REGION_OF_BIRTH','varchar2',1,1,0,1); attr (17) := attributeinfo('COUNTRY_OF_BIRTH','varchar2',1,1,0,1); attr (18) := attributeinfo('USER_PERSON_TYPE','varchar2',1,1,0,1); attr (19) :=
attributeinfo('EFFECTIVE_START_DATE','date',1,1,0,1); attr (20) := attributeinfo('ACTUAL_TERMINATION_DATE','date',1,1,0,1);
attr (21) := attributeinfo('SUPERVISOR_ID','varchar2',1,1,0,1); attr (22) := attributeinfo('SUPERVISOR_NAME','varchar2',0,0,0,1);
attr (23) := attributeinfo('JOB','varchar2',1,1,0,1); attr (24) := attributeinfo('GRADE','varchar2',1,1,0,1);
attr (25) := attributeinfo('DEPARTMENT','varchar2',1,1,0,1); attr (26) := attributeinfo('PERSON_UPDATED_DATE','date',1,1,0,1); attr (27) := attributeinfo('ASSIGNMENT_UPDATED_DATE','date',1,1,0,1); attr.extend;
attr (28) := attributeinfo('U_ID','varchar2',1,1,1,1); attr.extend;
attr (29) := attributeinfo('FAMILY_NAME','varchar2',1,1,0,1); attr.extend;
attr (30) := attributeinfo('GIVEN_NAME','varchar2',1,1,0,1); attr.extend;
attr (31) := attributeinfo('IN_DATE','varchar2',1,1,0,1); attr.extend; attr (32) := attributeinfo('EMPLOYEE_STATUS','varchar2',1,1,0,1); attr.extend; attr (33) := attributeinfo('OFFICE_LOCATION','varchar2',1,1,0,1);
schemaout( 1 ) := schema_object('__PERSON__',attr);
修改完成后在数据库中重新编译。 二、
更新操作
2.1新建用户自定义字段
登录http://172.29.41.203:15000/sysadmin管理界面，新建纱箱“userdef”，保存并关闭。
单击“系统实体”下的“用户”项，单击“新建”按钮，在出现以下界面中选择文本。
确定后，在显示标签和名称中添加新字段。
使用同样步骤添加上所有自定义字段。
2.2添加用户资源实体
1. 登录到 Oracle Identity Manager Design Console。 cd /u01/oracle/Middleware/Oracle_IDM1/designconsole ./xlclient.sh
输入 xelsysadm/Welcome1
单击Yes
2. 展开 Resource Management文件夹, 双击Resource Objects并单击查找按键, 在右侧窗体下方新出现 Resource Objects Table页签。