@scsharath2  The standard ILMT integration passes through the ILMT PVU calculations "as is". From your description is sounds like you've created a custom ILMT integration that stages the data somewhere else. I think that the forum members will need more details about your custom integration to be able to provide any guidance. Please, would you be able/willing to share more details? Thanks, ... View more

Thanks for the quick response 🙂 ... View more

The SQL query should select data from various tables  and then insert data to staging table where the Business unit = 'ABC'. So it's doesn't insert data to staging table when it's  scheduled but when i run it manually it works fine. ... View more

Sure , thank you ... View more

Thank you ... View more

Hi @scsharath2 , Is the information available in the Database Schema reference what you are looking for? Regards Vas ... View more

As @mfranz mentioned you can use the XML files to review the data, However is there any particular reason you are importing HPUD data twice daily? My observation there is negligible impact on the HPUD server for the import and will hardly take a few seconds for the import.  You can you use the "prestaged" method to import the existing XML files to staging DB.  ... View more