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!

External_reference in cs_incidents_all_b and create_ServiceRequest API

Discussion in 'Oracle CRM' started by M_Anas_O, Nov 26, 2009.

  1. M_Anas_O

    M_Anas_O Forum Advisor

    Messages:
    95
    Likes Received:
    9
    Trophy Points:
    160
    Location:
    Austria
    Hi,

    What information is stored in the External_reference column in cs_incidents_all_b and in record type service_request_rec_type of create_ServiceRequest API?
    And where do we see this field in SR form?

    Regards,
    Mohammed
     
  2. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    The External_Reference is the Tag Number and it is stored in cs_incidents_all_b table only if the SR is created for a non installed base item, otherwise it is derived from csi_item_instance using the instance_id.
     
    M_Anas_O likes this.
  3. Shilpi

    Shilpi Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Gurgaon
    Can someone please help , how to derive external_reference using instance_id.
    We have instance_id value store in column customer_product_id of table CS_INCIDENTS_ALL.
     
  4. raovk13

    raovk13 Premium Member

    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    100
    Hi Shilpi

    Sharing the pseudo code..

    Regards,