Discussion in 'Oracle CRM' started by Bharat, Apr 16, 2012.
Attache a sample insert script .
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 ?
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.
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
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?
Please refer API guide for Service Contracts. Applicable fo rR12 as well.
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.*
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.
Thanks. It was useful discussion
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.
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 : firstname.lastname@example.org
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.