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!

Subscription Contract API

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

  1. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ,

    Can anyone please guide me how to create API which creates Subscription Contract or Service Contract.
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ,

    Please anyone help me on this issue, it was urgent. I was trying to do using OKS_CONTRACTS_PUB package and Create_Subscription procedure in that package to create subscription. But Iam facing error like component is not declared. I have attached document which contains API. Thanks in advance.
     

    Attached Files:

  3. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    OKS_CONTRACTS_PUB.Create_Contract_Header:
    This API is used to create contract header information. The API is called using P_K_Header_Rec,
    P_Header_Contacts_Tbl, P_Header_Sales_Crd_Tbl and P_Header_Articles_Tbl. Depending on your conversion
    needs and the available information in the legacy application you would be required to populate each of these
    in-parameters. However if no information is available for sales credit or contract articles you could leave the
    P_Header_Sales_Crd_Tbl and P_Header_Articles_Tbl NULL. However it is a must that you populate the
    P_K_Header_Rec with all the values. At least 1 contact information for the vendor should be created in
    P_Header_Contacts_Tbl. The value for the contact_object_code would be ‘OKX_SALESPERS’. If you need to
    create additional parties on the contract header depending on your billing requirements and other entity
    relationships you may have to call Okc_Contract_Party_Pub.Create_K_Party_Role. Als o you would need to
    determine in advance how do you wish to bring these contracts into the Application. These contracts can be
    brought in as ‘ENTERED’, which would mean the process owners would have to submit the contract for approval
    using Contracts Approval Workflow.

    OKS_CONTRACTS_PUB.Create_Service_Line

    This API is used to create Contract Service Line for each contract header. The API is called using P_K_Line_Rec,
    P_Contact_Tbl and P_Line_Sales_Crd_Tbl. Again depending on your needs and available information you would
    populate each of these parameters. However if no information were available for the P_Contact_Tbl and
    P_Line_Sales_Crd_Tbl, it would be okay to let them be NULL from conversion perspective. The key aspect of
    service line API is to understand the relationships between the shipping entity and the billing entity. Especially
    if the item is serviceable with a usage component and has been leased out using a third party company. Also
    important is to attach this item with the appropriate Install Base record if Install Base application is in use.

    OKS_CONTRACTS_PUB.Create_Covered_Line
    This API is used to create Covered Lines for each service line you create. Before you call this API you are
    required to set values for P_K_Covered_Rec and P_Price_Attribs_In. Depending on your pricing needs values for
    P_Price_Attribs_In will have to be set. If there is no complex pricing requirements it is okay to leave the value
    for this record type null. Values of certain columns of P_K_Covered_Rec should be same as P_K_Line_Rec e.g.
    value for PERIOD in the record should be same as the value for the P_K_Line_Rec.Usage_Type or value for
    Line_Renewal_Type should be either FUL/DNR/KEP.
     
  4. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ramji,

    I have created API using those procedures but after executing that pl/sql we are getting error like its returning U as return status. Please help in this.
     
  5. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ramji,

    I have attached created API. Please suggest me what to change in it to get work successfully.
     

    Attached Files:

  6. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi all,

    It works successfully, issue hides in parameters. I have passed parameters wrongly. After verifying at application level I have passed mandatory column values there, then it works successfully.