How to modify the SCP External system Collection Entity extract data?
Business is using EBS Order Management and Cloud SCM. we are moving Collection data from EBS to Cloud SCM using Middleware tech. Collection data generated through standard concurrent Program "'Extract data for Oracle Supply Chain Planning Cloud" we are just picking file from MSC_TOP and pushing it to Cloud using Import bulk process.
Now Business wants to make transformation in extracted data it's difficult to handle in middleware due to file size (more than 2 gb without zip) so we are looking for some workaround where we can modify data in EBS itself using any Custom hooks.