Extract all data from PAY_RUN_RESULT_VALUES and PAY_RUN_BALANCES tables — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!