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!

Service Contracts Approved and Signed by fields

Discussion in 'Oracle CRM' started by Bharat, Aug 7, 2012.

  1. Bharat

    Bharat Community Moderator Forum Guru

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

    Where can we find who approved and who signed the service contracts once it is submitted for approval. I didn't noticed those fields in any of the tables. Can anyone help me to get those values to identify them?
     
  2. sowji.kanagala

    sowji.kanagala Active Member

    Messages:
    21
    Likes Received:
    1
    Trophy Points:
    90
    Bharat,if am not wrong this we can see in Work flow rth ?
     
  3. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Yeah you are right.. But If they try to purge the workflow records then we are not able to get the data. So we need to look for other solution on it. Thanks for your valuable reply sowjanya. If you have any more ideas on it please share it. May be they are useful for me.
     
  4. sowji.kanagala

    sowji.kanagala Active Member

    Messages:
    21
    Likes Received:
    1
    Trophy Points:
    90
    Bharat,Can't we see the same in Contract History tab ?please find the attachment,please correct me if am wrong .
    i am just sharing my thougths
     
  5. Bharat

    Bharat Community Moderator Forum Guru

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

    Where is the attachment?
     
  6. sowji.kanagala

    sowji.kanagala Active Member

    Messages:
    21
    Likes Received:
    1
    Trophy Points:
    90
    sorry bharath, i am trying to attach the file,but it is exceeding the maximum size.
     
  7. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Apologies Sowji. What is the file type (word or pdf or excel etc) and what is the file size. Let me know so I can increase the attachment file limit.
     
  8. sowji.kanagala

    sowji.kanagala Active Member

    Messages:
    21
    Likes Received:
    1
    Trophy Points:
    90
    Bharath,
    Please find the attachment
     

    Attached Files:

  9. sowji.kanagala

    sowji.kanagala Active Member

    Messages:
    21
    Likes Received:
    1
    Trophy Points:
    90
    since the attchemnt is not opening, i am providing the navigation that where we cn see the History of conttract


    In contract search window->double click on contract --->a window will open --->in the down we can see overview,historytabs

    In the history we can see what are the changes made on that contract,and who have done the changes
     
  10. Bharat

    Bharat Community Moderator Forum Guru

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

    Thanks for your document. Can I know in which tables that information is going to save. I need tables where it is going to save that information like signed by and approved by.
     
  11. sowji.kanagala

    sowji.kanagala Active Member

    Messages:
    21
    Likes Received:
    1
    Trophy Points:
    90
    Hi Bharath,

    I am not very sure like in which tables these details will be saved (who signed a contract),but as of my knowledge a contract will be approved by many pepople,so those approval details we can see in it in WF_NOTIFICATION table(you migth know this).Please correct me if i am wrong


    Thanks,
    Sowjanya
     
  12. Bharat

    Bharat Community Moderator Forum Guru

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

    Yeah we can see those details in that table. But when we purge them we are not able to retrieve them. So I need to know is there any permanent table which stores that information. If yes please tell me the table name. Thanks in advance.