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!

Deleting Set of Books

Discussion in 'Oracle Financials' started by mimi_miao, Sep 4, 2009.

  1. mimi_miao

    mimi_miao Active Member

    Messages:
    32
    Likes Received:
    0
    Trophy Points:
    80
    Hi guys!
    I just want to ask if is it possible to delete a certain set of books in GL11i?
    Coz there are some set of books that have been made for testing and we not using it right now. might as well delete it if its possible to save some space and prevent from mistakes.
    Thanks and regards!
     
  2. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    It is not possible to delete a set of books from the General Ledger. Since the link between the User and the SoB is via the Responsibility, an appropriate workaround is to disable the Responsibility which attaches to the SoB in question. Alternately you can change the set of books the responsibility points to.
     
  3. mimi_miao

    mimi_miao Active Member

    Messages:
    32
    Likes Received:
    0
    Trophy Points:
    80
    will it cause an error if i delete it thru tables?
     
  4. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    No if your SOB is new and hasn't been used anywhere. But if it is an old one and you are not sure, i wouldn't recommend deleting the row from the table/
     
  5. mimi_miao

    mimi_miao Active Member

    Messages:
    32
    Likes Received:
    0
    Trophy Points:
    80
    hmm... then there's no way to remove the no-longer-needed set of books and its flexfields and transactions?
     
  6. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    Short answer: NO :)
     
  7. mimi_miao

    mimi_miao Active Member

    Messages:
    32
    Likes Received:
    0
    Trophy Points:
    80
    hehe. dead end. many many thanks Sir for your response!
     
  8. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    :) the thing is, the whole point of an ERP application is accountability. SO if people were to delete transactions, imagine what would an Auditor say!