I'm attempting to load around 50,000 new lines into Fixed Assets using the FA_MASS_ADITIONS table and sqlldr.
Although the table increases by the expected number of lines and I don't get any ldr errors, Assets isn't recognising the data.
I think it's to do with the MASS_ADDITIONS_ID value but I can't work out how to access a sequence using sqlldr if this is what the problem is.
Has anyone had success with this process before ?
I desperately need a reply - the accountants want this for end of Financial Year (next Friday)
Since you are not getting any errors, it appears as you said, the assets are not being recognized by Fixed Asset module. I advise you to set up a tar at metalink with severity 4 so that someone from Oracle can help out immediately. It is strange that the assets get loaded fine and yet canít be seen in Apps. How did you load these assets? Where are they coming from? Did you use any kind of mapping? The answers to these questions may be helpful to resolving the problem.
Click Here to Expand Forum to Full Width