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!

what is the difference between OKC and OKS tables

Discussion in 'Oracle CRM' started by sowji.kanagala, Aug 17, 2012.

  1. sowji.kanagala

    sowji.kanagala Active Member

    Messages:
    21
    Likes Received:
    1
    Trophy Points:
    90
    I am creating service contract in r12 instance,data is getting loaded into OKS tables only ,it not loading into OKc tables
    and i am not able to see contract numbers in OKS_CONTRACTS_HEADERS_B table ,can any one let me know what is the difference between OKS and OKC tables and why data is getting loaded into OKS alone


    Thanks,
    Sowjanya
     
  2. Bharat

    Bharat Community Moderator Forum Guru

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

    I have tried to run query with your table what you have posted in OP. But it is saying that table or view does not exists. Please try to post some more details like screenshots for querying two tables and their outputs and also exact table names what you have used. Most of the times we get the contracts data in both OKC and OKS tables. There is no such difference I have seen on them. Please post the details exactly by that we can help you in right way.
     
  3. sowji.kanagala

    sowji.kanagala Active Member

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

    please find the attachment


    I am querying OKC_K_HEADERS_B ,OKS_K_HEADERS_B tables
     

    Attached Files:

  4. Bharat

    Bharat Community Moderator Forum Guru

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

    To access the data in OKC_K_HEADERS_B you need to set organization specified. Or you can use OKC_K_HEADERS_ALL_B in the place of OKC_K_HEADERS_B table.

    To set organization specified use as follows:

    EXEC MO_GLOBAL.SET_POLICY_CONTEXT('S',204);

    Which sets for single organization of 204. Here you can give your required organization id.
     
  5. Bharat

    Bharat Community Moderator Forum Guru

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

    Have you found of the differences between those two tables? Is your doubt resolved?
     
  6. sowji.kanagala

    sowji.kanagala Active Member

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

    Now i was able to found out differences b/w those two tables,Thanks for your help.


    Thanks,
    Sowjanya
     
  7. Bharat

    Bharat Community Moderator Forum Guru

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

    Please post the identified things here by that this thread may help to others who are surfing about this.
     
  8. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Bharatappa,

    She is going to get you arrested for stalking LOL!
    ramji
     
    Bharat likes this.
  9. Bharat

    Bharat Community Moderator Forum Guru

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

    May be she was, but you have suggested her now bhayya Lol.
     
  10. rajreddy

    rajreddy Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    75
    Location:
    Chennai
    Hi bharath.. I need urgent help on service contracts. i have lot of confusion over billing of service contracts like top level billing sub line level ..how they will effect each other. please share some information, thanks in advance