Restricting zero Balance records at source while extracting data from ERP to EPM
Summary:
Hi,
While loading data into EPM applications from ERP, is there a way to not extract the records where Period Activity is 0. For the code combination where there is no 'Period Activity', these are coming as zero balance records. We are not loading the 0 balance records in EPM applications and hence these gets rejected but adding to the volume of records due to which data load is failing with threshold limit reached error.
In the logs we can see that almost 80% of the records are getting rejected and 20% are loaded.
Any way to not extract these records from the source