Difficulty in Uploading Fixed Asset Data (183,000 records)

Content

Hello,

I am uploading 183,000 fixed asset records and I have issues that I cannot resolve.

Though I have uploaded everything, I still have issues on the assets that were duplicated in upload because the system didn't recognize it as an update to what I already uploaded but it treated these assets as new ones.

I also cannot run a complete report because OTBI is limiting the number of records to only 180k. I cannot see the entirety of the report in order for me to know what assets are POSTED, POST, ERROR and NEW. I did try an OTBI with separate SQL statements (one with rownum >180k and rownum <180k). It did work but I still cannot figure out why some of the assets already uploaded are not appearing.