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!

PO History Table

Discussion in 'Oracle Apps Technical' started by jagadekara, Nov 18, 2014.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi All,

    I need PO history tables....

    I find po_headers_archieves_all table. But I want to know when this table will populate?

    Because I find some po's which are not in this archieve table.
     
  2. yowancristo

    yowancristo Forum Advisor

    Messages:
    103
    Likes Received:
    10
    Trophy Points:
    305
    Location:
    Bangalore
    Hi Jagadekara,

    Have you checked the table po_action_history,

    It will have history of all actions performed on each POs.

    Regards,
    Yowan Cristo
     
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Thanks Yowan,

    I checked po_action_history table but it is not useful to me.
     
  4. yowancristo

    yowancristo Forum Advisor

    Messages:
    103
    Likes Received:
    10
    Trophy Points:
    305
    Location:
    Bangalore
    Hi Jagadekara,

    Have you used po_action_history.object_id = po_headers_all.po_header_id ?

    This table will have details of POs on what actions were performed on it.

    Regards,
    Yowan Cristo