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

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

Received Response
16
Views
1
Comments
edited Aug 7, 2021 4:04PM in Assets 1 comment

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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