Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners click HERE | EMEA/APJ Partners click HERE |
06/17/2024 09:26 AM
Hi Team,
We have 2 Applications where App B is dependent on App A.
For App A the AccountNameRule is Systemusername will be Account Name. E.g: T123456
But for App B AccountNameRule is EmployeeID will be Account Name. E.g: 123456
For App B though it is set EmployeeID for AccountName but still it creating AccountName with Systemusername.E.g: T123456
As we passing EmployeeID in custom Jar while Account creation it creates additional entry in Accounts after Recon job. The Previous Account T123456 became Suspended and and a new entry 123456 is created with Status Active.
So is there any way to create Account for App B with EmployeeID as the Account Name?
Also I used below correlation rule for App B as in some cases employeeid can be less than 6 digit. So need to append 0's to generate systemusername.
Below correlation rule used...but the substring part not working.
(users.employeeid)=(accounts.name)#(accounts.name)=substring(users.systemusername,1,7)
So can someone please help for above issues?
Regards,
Soumya.
06/17/2024 09:57 AM - edited 06/17/2024 09:57 AM
Hi @soumyabrata , is endpoint B a mapped endpoint? Or a child endpoint?
Did you deploy a custom jar or using an ootb connector?
06/17/2024 10:16 AM
06/17/2024 02:18 PM
Using Mapped Endpoint. If in App A Account not there don't allow to submit the Request for App B.
06/17/2024 06:33 PM
Mapped endpoint follow parent endpoint account name
06/21/2024 06:48 AM
Ok thanks for the update.
Can you help on the correlation rule...is there any issue with below rule?
Substring portion not working
(users.employeeid)=(accounts.name)#(accounts.name)=substring(users.systemusername,1,7)
06/21/2024 07:36 AM
users.employeeid=accounts.name#SUBSTRING(users.systemusername,1,7)=accounts.name
Left side is always users and right side is accounts.
06/21/2024 06:54 AM - edited 06/21/2024 07:53 AM
Try this
(users.employeeid)=(accounts.name)###SUBSTRING (users.systemusername,1,7)=(accounts.name)
06/21/2024 10:37 AM
I think substring not working in EIC 24 versions. In 5.5 version it was working.
Tried with substring_index and it worked.
06/21/2024 02:28 PM
both works . You can validate same in data analyzer or when you run import job towards end of job correlation works
06/21/2024 01:33 PM
Hi @soumyabrata ,
For reference:
If this helps your question, please consider selecting Accept As Solution and hit Kudos