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!

oracle assets location history table

Discussion in 'Oracle Financials' started by Cavishalvb, Mar 6, 2013.

  1. Cavishalvb

    Cavishalvb Active Member

    Messages:
    4
    Likes Received:
    1
    Trophy Points:
    85
    Hello All,
    Please let me know in which table, history of location of an asset is stored? Like if an asset is transferred to Y location from X location, how the that X location can be tracked through tables?
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ,

    Have you checked in FA_DISTRIBUTION_HISTORY table by restricting Asset_id?
     
    Cavishalvb likes this.
  3. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Vishal,

    Have you checked that table ? Do you find your required information ?
     
  4. Cavishalvb

    Cavishalvb Active Member

    Messages:
    4
    Likes Received:
    1
    Trophy Points:
    85
    Hello Bharat,

    Sorry for replying late. Now the requirement has changed and the client is suggested to get Location additional segment. I dont hv backend access hence am not able to check the same.

    Regards,
     
    Bharat likes this.