Fetching deleted records in Integration center

[rezadwi]

Hi Everyone, 

Hope you all doing great.

I'm currently wondering if there is possibility to fetch deleted records in Integration center?

In my case, I use IC (integration center) to store all relationship type from EC Dependent portlet to custom mdf.

this mdf is used for validating benefit reimbursement eligibility for employee's dependent, because currently fetching dependent data for Benefit Reimbursement is not possible. (actually possible, but SAP recommends using lookup to mdf object due to heavy employee count for our client).

However, I feel like there is potential issue where if one record is deleted in EC Dependent portlet, IC won't possible to fetch this deleted record. (delete access is granted to ESS role).

So, any feedback how to solve issue like this?

Thanks,

Reza

[zengshaofeng · Accepted solution]

Dear Customer,

Thank you for reaching out. This is Hannah from Employee Central Team.

It is NOT possible to fetch deleted records in Integration center.

It is possible to fetch deleted records via "Change audit reports" tool or Table report(domain = Person and Employment Audit). 

Best regards,

Hannah

[rezadwi · Accepted solution]

Thanks for clarifying.

[YahiaElsenosy · Accepted solution]

Hi rezadwi

1. In MDF, make the standard field mdfSystemStatus editable.
2. In Dependents, create a custom field named status with values Active/Inactive.
3. Configure a business rule in Dependents so that instead of deleting a record, its status is set to Inactive.
4. In Integration Center (IC), map:
   • The status field in Dependents
   • The mdfSystemStatus field in MDF
     This ensures that records are marked as Inactive rather than deleted.