Extract all data from PAY_RUN_RESULT_VALUES and PAY_RUN_BALANCES tables
Summary:
We have a requirement to extract all data from PAY_RUN_RESULT_VALUES and PAY_RUN_BALANCES tables since go live. We tried to build a BIP Report and running them in chunks in 40 to 50 files. But the report is erroring out with below error. We have observed that with the amount of data in these tables, it would take 200 to 300 files to generate the data in chunks. I am looking for any other better options to extract this data. We have also checked BICC option, but none of the PVOs have this data.
Below are the current record counts present in these tables