Need to achieve a link between load interface file for import to Import Project Billing Events

Hi Team,

We are trying to upload project billing events using bulk import API using Bhoomi integrations.

We have designed a common report to give Request_Id (Import Project Billing Events process ID) by passing load interface file for import Process id (Load_interface_ID) . for this we are trying to join PJB_BILLING_EVENTS_INT with ESS_REQUEST_HISTORY.

But i see data is getting purged right after the data is processed. so, we cannot able to see load_request_id and request_id .

Any suggestion to achieve this thing?

Regards

Sarath