DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: FA_MASS_ADDITIONS load

  1. #1
    Join Date
    Dec 2001
    Posts
    9
    Hi folks.

    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 ?

  2. #2
    Join Date
    Dec 2001
    Posts
    9
    Hi All,

    I desperately need a reply - the accountants want this for end of Financial Year (next Friday)

    Warrick

  3. #3
    Join Date
    Dec 2001
    Location
    Atlanta
    Posts
    175
    Hi Warrick

    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.

    C. K.
    Apps DBA



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width