DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2001
    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
    Hi All,

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


  3. #3
    Join Date
    Dec 2001
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.