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!

In which view/table the Reassign events [Only after approval of Requisitions] stored

Discussion in 'Oracle SCM & Manufacturing' started by sabya, Jul 18, 2009.

  1. sabya

    sabya Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    We are using Oracle EBS 11i in State-owned Energy Utility Sector for purchasing process.

    Here, we have to Reassign documents even after approval sequence is completed.

    And we have made a 'pdf' report of the whole process, taking data from PO_ACTION_HISTORY table/view. Problem is that the Delegate history after approval is not stored inside PO_ACTION_HISTORY table/view. So, report is incomplete.

    But, these actions are displayed in notification page of that particular document [That means it's stored somewhere else].

    Can anybody tell me where it is STORED...? I need it desperately.
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Re: In which view/table the Reassign events [Only after approval of Requisitions] sto

    This is a BUG in the system. Take a look at BUG No. 1349004 at Metalink.
     
  3. sabya

    sabya Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Re: In which view/table the Reassign events [Only after approval of Requisitions] sto

    Dear Sadik,
    Thanx for ur resonse. I've already gone through BUG:1349004 in metalink.
    But, I like to know the name of the underlying Table/view from where the
    data is fetched to the notification page. That'll solve my problem..