Review EBS product's new releases & features, troubleshooting tips & tricks, best practices, upcoming webcasts

Tips On Using The Service Contracts Import Program

Guest Author

Prior to release 12.1 there was no supported way to import contracts into the EBS Service Contracts application - there were no public APIs nor contract load programs provided.  From release 12.1 onwards the 'Service Contracts Import Program' is provided to load service contracts into the application. The Service Contracts Import functionality is explained in How to Use the Service Contracts Import Program - Scope and Limitations (Doc ID 1057242.1).  This note includes an attached document which explains the program architecture, shows the Entity Relationship Diagram and details the interface table definitions.

Contracts Import Program Architecture

The Import program takes data from the interface tables listed below and populates the contracts schema tables:  


These interface tables must be loaded via a custom load program.

The Service Contracts Import concurrent request is then submitted to create contracts from this legacy data. The parameters to run the Import program are:

 Parameter Description
 Mode Validate only, Import
 Batch Number
Batch_Id (unique id populated into the OKS_HEADERS_INTERFACE table)
 Number of Workers
Number of workers required (these are spawned as separate sub-requests)
 Commit size
Represents number of successfully processed contracts commited to database

The program spawns sub-requests for the import worker(s) and the 'Service Contracts Import Report'.  The data is validated prior to import and into the Contracts tables and will report errors in the Service Contracts Import Report program output file (Import Execution Report).  Troubleshooting tips are provided in R12.1 - Common Service Contract Import Errors (Doc ID 762545.1); this document lists some, but not all, import errors.  The document will be updated over time.  Additional help is given in Debugging Tip for Service Contracts Import Errors (Doc ID 971426.1).

After you successfully import contracts, you can purge the records from the interface tables by running the Service Contracts Import Purge concurrent program. Note that there is no supported way to mass delete data from the Contracts schema tables once they are populated, so data loaded by the Import program must be fully tested and verified before the program is run to load data into a Production system.

A Service Contracts Import Test program has been provided which will take an existing contract in the application and load the interface tables using the data from that contract.  This can be used as an example for guidance on how to load the interface tables.  The Test program functionality is explained in How to Use the Service Contracts Test Import Program Provided in Release 12.1 (Doc ID 761209.1).  Note that the Test program has some limitations which do not apply to the full Import program and is not a supported program, it is simply a testing tool.  

Join the discussion

Comments ( 4 )
  • guest Tuesday, August 6, 2013

    Rare(Unique) and excellent post

  • LuciaC Monday, August 19, 2013

    Glad you liked it! If you have ideas for more posts like this that you'd like to see, let us know. We'd love to hear from you.

  • guest Wednesday, February 15, 2017

    I am having an issue. I am unable to define a service item. The field service type in inventory item screen is un-updatable. Can you please suggest what setups need to be done to do this.

  • JimG Wednesday, February 15, 2017

    Sorry to hear you are having setup issues. To get help with this issue I would suggest you use the My Oracle Support (MOS)site and log an Service Request or better yet go to Oracle E-Business Suite (MOSC)in My Oracle Support Community and post your questions there. Select the community you think best represents the experts that will be able to assist you. I would suggest starting with the Contracts and Lease Management - EBS (MOSC)community.



Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.