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!

Open interfaces for service contracts

Discussion in 'Oracle CRM' started by Bharat, Apr 16, 2012.

  1. vkothamasu

    vkothamasu Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Hi Bharat,

    Attache a sample insert script .

    BR,
    Pavan.
     

    Attached Files:

  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,750
    Likes Received:
    148
    Trophy Points:
    1,805
    Location:
    Redondo Beach, California
    Hi Pavan,

    Which type of contract you are trying to create ? Like Service or Usage or Subscription or Warranty or for which one you are looking into ?
     
  3. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,750
    Likes Received:
    148
    Trophy Points:
    1,805
    Location:
    Redondo Beach, California
    Hi Pavan,

    Is this issue Fixed ? Please let me know what type of contract you are trying to do using interface if not fixed. Then I can assist you on this.
     
  4. vkothamasu

    vkothamasu Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Hi Bharat,

    The issue is not fixed yet, i am creating a service contract. i was able to create the same with API, but not with the import
    program.

    BR,
    Pavan.
     
  5. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,750
    Likes Received:
    148
    Trophy Points:
    1,805
    Location:
    Redondo Beach, California
    Are you passing the same values as what you passed to API or any values missed ?

    Tell me, What type of contract you are trying to create, like Subscription/Usage/Service/Warranty Items you are using to create the contract?
     
  6. Nidhi25

    Nidhi25 Forum Genius

    Messages:
    82
    Likes Received:
    7
    Trophy Points:
    835
    Please refer API guide for Service Contracts. Applicable fo rR12 as well.
     

    Attached Files:

  7. Nidhi25

    Nidhi25 Forum Genius

    Messages:
    82
    Likes Received:
    7
    Trophy Points:
    835
    Additional Details below:

    Presently there are no Supported Public APIs for Service Contracts other than the 3 APIs below that are published in the*Oracle Service Contracts API Reference Guide (Release 11i B12095-01).* OKS_ENTITLEMENTS_PUB* OKS_CON_COVERAGE_PUB* OKS_OMINT_PUB* All other Service Contracts related APIs (including any other '_PUB' APIs) are not supported by Oracle Support or Oracle Development. Use of any unsupported APIs is done at customer's own risk.* As noted above, there are currently*no*published and supported APIs available for performing*bulk or transactional contract import.* There is a Service Contract Import process available from release 12.1.1 onwards (see*Note 1057242.1*for details).* If a requirement exists to import contracts from a legacy system or custom front-end, it is recommended that Consultancy be engaged for help in this area.*
     
  8. vkothamasu

    vkothamasu Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Yes, i am passing the same values to the interface table too, but not able to know wat the issue is. i want to create a contract of category Service.
     
  9. Nidhi25

    Nidhi25 Forum Genius

    Messages:
    82
    Likes Received:
    7
    Trophy Points:
    835
    Thanks. It was useful discussion
     
  10. dineshbhadra

    dineshbhadra Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hi All,

    Requirement :- We are planning migration of service contract and install-base data from release R11i to R12

    Need your help for below questions:-

    1) Is there any mapping document from 11i to R12 available for service contract tables(OKC,OKS and CSI)
    2) Is there any mapping document available for the contract import interface tables to extract data from oracle apps 11i
    3) Is there any document \scripts available for rule data migration

    Appreciate your quick response on this. Also please share your experiences.

    Regards,
    Dinesh.
     
  11. Mahendra

    Mahendra Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    75
    Hi Bharat,Jana

    Will you please send me sample .CSV file for service contract interface tables, so that i can used it to load data into application.

    Please send it to my gmail id as : mahyapatil1979@gmail.com

    Thanks,
    Mahendra.
     
  12. Aradhya

    Aradhya Newly Initiated

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    30
    Location:
    India
    Need help in Service Contracts Conversion

    Only the headers and sales credits are getting loaded. What will be the issue?

    I have the attached the Interface table data.
     

    Attached Files: