System information

Identity Manager Resources Reference
Part Number 820-2952-10 Page 103
• The Oracle ERP adapter supports Oracle E-Business Suite (EBS) version 12. It is no longer
necessary to edit or comment out sections the OracleERPUserForm, depending on version
of ERP installed as described in the Identity Manager Resources Reference. (16705, 16713)
The FormRef attribute now supports the following properties:
❍ RESOURCE_NAME — Specifies the ERP resource name
❍ VERSION - Specifies the version of the ERP resource. Allowed values are 11.5.9,
11.5.10, 12.
❍ RESP_DESCR_COL_EXISTS — Defines whether the description column exists in the
fnd_user_resp_groups_direct table. This property is required if Version is 11.5.10 or 12.
Allows values are TRUE and FALSE.
These properties should be entered on wherever the user form is being referenced from.
For example, the Tabbed User Form may need to be modified in a manner similar to the
following to support Release 12.
<FormRef name='Oracle ERP User Form'>
<Property name='RESOURCE_NAME' value='Oracle ERP R12'/>
<Property name='VERSION' value='12'/>
<Property name='RESP_DESCR_COL_EXISTS' value='TRUE'/>
</FormRef>
Resource User
Attribute Data Type Description
npw_number string Contingent worker number. It represents an
npw_number from the
per_people_f table.
When you enter a value on create, the adapter tries to lookup a
user record in the
per_people_f table, retrieve the person_id
into the create API, and insert the
person_id into the fnd_user
table's
employee_id column.
If no
npw_number is entered on create, no linking is attempted.
If you enter an
npw_number on create and that number is not
found, then the adapter throws an exception.
The adapter will try to return the
npw_number on a getUser , if
npw_number is in the adapter schema.
Note: The
employee_number attribute and npw_number attribute
are mutually exclusive. If both are entered on create,
employee_number takes precedence.