Use case
Default mapping for EBS connector
Solution
Below is the default account and entitlement mapping used. The columns are mapped to the Source tables (FND_*).
ACCOUNT_MAPPING
{
"ACCOUNTID": "USER_ID",
"CREATED_ON": "CREATION_DATE",
"CREATOR": "CREATED_BY",
"CUSTOMPROPERTY20": "EMPLOYEE_ID",
"CUSTOMPROPERTY21": "EMAIL_ADDRESS",
"CUSTOMPROPERTY22": "CUSTOMER_ID",
"CUSTOMPROPERTY23": "SUPPLIER_ID",
"CUSTOMPROPERTY24": "PERSON_PARTY_ID",
"DESCRIPTION": "DESCRIPTION",
"LASTLOGONDATE": "LAST_LOGON_DATE",
"UPDATEDATE": "LAST_UPDATE_DATE",
"UPDATEUSER": "LAST_UPDATED_BY",
"VALIDFROM": "START_DATE",
"VALIDTHROUGH": "END_DATE"
}
ENTITLEMENT_MAPPING
{
"RESPONSIBILITY": {
"ENTITLEMENT_VALUE": "RESPONSIBILITY_KEY",
"ENTITLEMENTID": "RESPONSIBILITY_ID",
"DISPLAYNAME": "RESPONSIBILITY_NAME",
"DESCRIPTION": "DESCRIPTION",
"UPDATEDATE": "LAST_UPDATE_DATE",
"CUSTOMPROPERTY6": "APPLICATION_ID",
"CUSTOMPROPERTY7": "APPLICATION_SHORT_NAME",
"CUSTOMPROPERTY8": "APPLICATION_NAME",
"CUSTOMPROPERTY9": "MENU_ID",
"CUSTOMPROPERTY10": "CREATION_DATE",
"CUSTOMPROPERTY11": "CREATED_BY",
"CUSTOMPROPERTY12": "LAST_UPDATED_BY",
"CUSTOMPROPERTY13": "DATA_GROUP_APPLICATION_ID",
"CUSTOMPROPERTY14": "DATA_GROUP_ID",
"CUSTOMPROPERTY17": "GROUP_APPLICATION_ID",
"CUSTOMPROPERTY18": "REQUEST_GROUP_ID"
}
}
