Here is the situation: I have BAPI which provides data from SAP and I have Oracle, where some tables are stored. My biztalk interface insers or updates data from SAP to Oracle table. This is working fine. But there is another rule, which has to be implemented. And I’m lost here.
So if a record in SAP is deleted it will not be deleted in oracle, which is as it should be. But this record in oracle has to change some status field. So, how to find which records are in Oracle but not in SAP and how to update them with correct status?
I was thinking about solution with database lookup functoid and go throug all records in Oracle and search for the records in SAP…