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. ronniekyan

    ronniekyan Active Member

    Messages:
    15
    Likes Received:
    1
    Trophy Points:
    110
    Hi Bharat,
    I'm still having difficulty to perform service contracts import.

    I have existing records in database. I'm just trying to preform a update to the record by adding cancellation_date.

    I have use fill-up OKS_HEADERS_INTERFACE, OKS_LINES_INTERFACE, OKS_COVERED_LEVELS_INTERFACE
    and OKS_SALES_CREDITS_INTERFACE.
    But everytime when I validate it, it only shows

    Interface table Interface id Error message


    I don't know what is the error still occurring. Is there any other tables or report log which shows what is the error?

    Thanks
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,750
    Likes Received:
    148
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    You want to update the existing contract with cancellation date ?
    What all the steps you are doing ?
     
  3. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,750
    Likes Received:
    148
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    If possible make a document with what the data you are trying to pull in?
     
  4. ronniekyan

    ronniekyan Active Member

    Messages:
    15
    Likes Received:
    1
    Trophy Points:
    110
    Hi Bharat,
    1) I have use fill-up OKS_HEADERS_INTERFACE, OKS_LINES_INTERFACE, OKS_COVERED_LEVELS_INTERFACE
    and OKS_SALES_CREDITS_INTERFACE.

    2) Perform validation on run request.

    3) View output.

    When I saw the error, I will
    update OKS_HEADERS_INTERFACE
    set parent_request_id = NULL
    , interface_status = NULL

    to rerun again.

    But I'm not sure what error or any missing data which needs to be loaded to interface table which cause the error to occur.
     
  5. ronniekyan

    ronniekyan Active Member

    Messages:
    15
    Likes Received:
    1
    Trophy Points:
    110
    Hi Bharat,
    I have attached my input. Can you please have a look if there is anything missing?

    Thanks
     

    Attached Files:

  6. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,750
    Likes Received:
    148
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    As of your data provided, I didn't see any contract start date, end date and duration and all. Please go through the application level with service contracts form and try to analyze which fields are mandatory. Then provide those values to import the record successfully. And also go through the below metalink note:
    How to Use the Service Contracts Import Program - Scope and Limitations [ID 1057242.1]
     
  7. ronniekyan

    ronniekyan Active Member

    Messages:
    15
    Likes Received:
    1
    Trophy Points:
    110
    Hi all,
    Does anyone has any scripts/tables/etc which can map against the Service Contracts Interface table on what are the values that should be populate?
    Please do share on how to populate the information for all the column required.

    Thanks
     
  8. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,750
    Likes Received:
    148
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Are you looking for mandatory columns information on interface tables for the service contracts??
     
  9. ronniekyan

    ronniekyan Active Member

    Messages:
    15
    Likes Received:
    1
    Trophy Points:
    110
    Hi Bharat,
    I'm not looking for mandatory columns, I'm looking for from Interface table where will it store to the based tables.
    eg: OKS_HEADERS_INTERFACE.CONTRACT_NUMBER => apps.okc_k_headers_all_b.contract_number
    OKS_HEADERS_INTERFACE.START_DATE => apps.okc_k_headers_all_b.start_date

    Currently I'm looking for all the columns in Interface tables (OKS_HEADERS_INTERFACE,OKS_LINES_INTERFACE,OKS_COVERED_LEVELS_INTERFACE,OKS_USAGE_COUNTERS_INTERFACE,OKS_SALES_CREDITS_INTERFACE) because I need to map which is the based tables and columns to put as input for the Interface tables.

    Thanks,
    Regards,
    Ronnie
     
  10. ronniekyan

    ronniekyan Active Member

    Messages:
    15
    Likes Received:
    1
    Trophy Points:
    110
    Hi,
    May I know, how would you all know what are the values to be key-in to the mandatory column?
    eg: like all those XXX_ID, BILL_TO_SITE_USAGE_ID, SHIP_TO_SITE_USAGE_ID, PRICE_LIST_ID and etc.
    Does anyone has a sql to query all those mandatory column values?

    Thanks,
    Regards,
    Ronnie
     
  11. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,750
    Likes Received:
    148
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Ronnie,

    We can identify them from form level. By creating new one successfully we can identify the mandatory fields. This is my assumption. Because while creating interfaces, I have followed this way to identify them.
     
  12. ronniekyan

    ronniekyan Active Member

    Messages:
    15
    Likes Received:
    1
    Trophy Points:
    110
    Hi all,
    Does anyone know what is the packages/validations when executing concurrent program for "Service Contract Import Test Program" ?

    Thanks.
     
  13. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,750
    Likes Received:
    148
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Ronniekyan,

    It uses OKS_IMPORT_TEST_INSERT package and Insert_Interface_Records procedure from that package.
     
  14. ronniekyan

    ronniekyan Active Member

    Messages:
    15
    Likes Received:
    1
    Trophy Points:
    110
    Thanks Bharat for the info
     
    Bharat likes this.
  15. ronniekyan

    ronniekyan Active Member

    Messages:
    15
    Likes Received:
    1
    Trophy Points:
    110
    Hi Bharat,
    Do you know how could I run Service Contracts Import by calling concurrent program manually?

    fnd_request.submit_request(application => 'OKS'
    ,program => 'OKSIMPRT'
    ,description => 'OKSIMPRT'
    .......
    );

    Thanks.
     
  16. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,750
    Likes Received:
    148
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Ronnie,

    Like you want to submit the concurrent program from backend ?

    If yes, Let me know what program you want to do it ?
     
  17. ronniekyan

    ronniekyan Active Member

    Messages:
    15
    Likes Received:
    1
    Trophy Points:
    110
    Hi Bharat,
    Program is Service Contracts Import.
    From the screen, I can see the parameter is Mode, Batch Number, Number of Workers, Commit Size.

    Please let me know how can I run from backend.

    Thanks.
     
  18. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,750
    Likes Received:
    148
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
  19. vkothamasu

    vkothamasu Active Member

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

    I need to do a conversion on service contract which are ACTIVE. The interface_status is S in the OKS_HEADERS_INTERFACE table but i am not able to see the contract created in Front end. In the Service Contract Import Report is no invalid records and no error. Can you please provide me any hints so that i can analyze more.
    Let me know what all info you requir for this.

    Thanks,
    Pavan.
     
  20. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,750
    Likes Received:
    148
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Pavan,

    Can you please provide the data you have used.. Like in excel sheet what you passed to conversion for creating it.