1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Item Import Issue

Discussion in 'Oracle Apps Technical' started by arul2k, Sep 9, 2011.

  1. arul2k

    arul2k Active Member

    Messages:
    11
    Likes Received:
    2
    Trophy Points:
    110
    We are running Item Import conversion. But lagging behind with poor performance. We followed Multi-thread..dividing into batches and running parallel requests..followed metalink notes etc. But didn't help.

    Suggestions are welcome to improve the item import performance, if anyone had faced the similar issue.

    Regards,
    Arul
     
  2. ajay78_hi

    ajay78_hi Active Member

    Messages:
    3
    Likes Received:
    1
    Trophy Points:
    110
    Hi,

    Item import when runs, internally calls Business Intelligence packages and inserts into the tables.
    ENI_ITEMS_STAR_PKG -- package
    ENI_ITEM_STAR_TEMP -- Table
    ENI_ITEM_STAR_VALID_ERR -- Table
    ENI_OLTP_ITEM_STAR -- Table

    If you client is not using business intelligence tools, just truncate the table ENI_OLTP_ITEM_STAR and ENI_ITEM_STAR_TEMP. Try to run the item import., you can see the difference in the performance.

    I have used the above one for one of my client and it reduced the performance whem performing item import.

    Regards,
    AK