Hi everyone,
I'm working on a requirement where we need to create HR person records in Oracle EBS. The system setup requires a user account to be linked to an employee in order to access various screens. As part of this process, we need to:
- Create the HR person.
- Create the user account.
- Link both in EBS.
Since direct inserts into the table HR.PER_ALL_PEOPLE_F
are not allowed, we are using the predefined package APPS.HR_EMPLOYEE_API
. Specifically, the CREATE_EMPLOYEE
function is being utilized.
I already followed this discussion (https://connect.oneidentity.com/products/identity-manager/f/forum/1722/is-there-a-reason-why-we-do-not-have-provisioning-of-ebs-crm-hr-oim-out-of-the-box)
The user has been granted permissions to use the package. I have also created a schema extension to define the insert method, and it looks as follows:
<?xml version="1.0" encoding="utf-8"?>
<EBSF12>
<ObjectNames>
<Object SchemaName="ORA-HRPersonTest" ParentSchemaName="" DisplayPattern="%HR.PER_ALL_PEOPLE_F.PERSON_ID%" IsReadOnly="false" UseDistinct="false">
<ObjectKey>
<Key Column="HR.PER_ALL_PEOPLE_F.PERSON_ID" IsDNColumn="true" X500Abbreviation="PE" />
</ObjectKey>
<Tables>
<Table Name="PER_ALL_PEOPLE_F" Schema="HR" APK="" USN="HR.PER_ALL_PEOPLE_F.LAST_UPDATE_DATE" WhereClause="" JoinParentTable="" JoinParentColumn="" JoinChildColumn="">
<PK Column="HR.PER_ALL_PEOPLE_F.PERSON_ID" />
</Table>
</Tables>
<Functions>
<Insert>
<Function Name="APPS.HR_EMPLOYEE_API.CREATE_EMPLOYEE" OrderNumber="1">
<Parameter Name="P_LAST_NAME" PropertyName="HR.PER_ALL_PEOPLE_F.LAST_NAME" PropertyType="VARCHAR" Mandatory="true" />
<Parameter Name="P_EMAIL_ADDRESS" PropertyName="HR.PER_ALL_PEOPLE_F.EMAIL_ADDRESS" PropertyType="VARCHAR" Mandatory="true" />
<Parameter Name="P_FIRST_NAME" PropertyName="HR.PER_ALL_PEOPLE_F.FIRST_NAME" PropertyType="VARCHAR" Mandatory="true" />
....
The schema definition appears to be correct, and the package function is referenced as required.
However, when attempting to browse the connector and perform the insert on the browse windows (click on +), I’m still unable to complete the operation because parameters are still in read-only. It seems like the schema is accepted, but I cannot perform the insert yet.
My questions are:
- Is there any additional configuration needed after defining the schema to enable the insert operation through the connector?
- Could there be a missing permission or setup step required in the EBS side to allow this integration to work as expected?
I’d appreciate any help or insights on what might be missing or how to proceed further.
Thanks in advance.
Regards,
Elena