Project Management

Get Involved. Join the Conversation.

Topic

    Raj Mohanraju
    REST API to update contracts
    Topic posted June 20, 2019 by Raj MohanrajuRed Ribbon: 250+ Points, last edited June 20, 2019, tagged Project Billing & Revenue, Project Contracts, Project Management 
    192 Views, 3 Comments
    Title:
    REST API to update contracts
    Summary:
    REST API to update contracts
    Content:

    We have a need to bulk update contracts used in project billing and I would like to receive your thoughts.

    These are typically what we are looking to update for over 1000+ contracts. Some contracts will have 100's of new lines to be added. So it is an impossible task to turnaround manually.

    1. Close contracts by passing Status Code = CLOSED; Close Date = 04/01/2019; Close Reason Code = CONT_COMPLETED.

    Sample attached.

    I have attempted this using the contract loader template but received error messages like below:

    OKC-OKC_ODI_INVALID_STATUS (OKC- -1) Details: OKC-OKC_ODI_INVALID_STATUS

    Cause: The message, OKC-OKC_ODI_INVALID_STATUS, can not be accessed. Action: Report this problem to an administrator.

    I have logged an SR, but less likely to be a quick fix.

    2. Add a new project into Contracts > Contract Lines > Associated Projects Tab

    I was told this is not supported by contract loader upload process as any update that would trigger an amendment is not supported by the contract import process.

    As a result we are now exploring opportunities using REST API's and any guidance will be useful.
     

     

    Document:

    Comment

     

    • Rajesh Choudhary

      Hi Raj,

      You can use the SOAP services that are available for contracts.

      To close the contract you can use the closeContract operation in the contract service. Details are available at : https://docs.oracle.com/en/cloud/saas/engagement/19a/oesws/contract-service-version-2-ContractService-svc-8.html

      closeContract

      The custom close operation for the contract header SDO.

      Life Cycle Status: Active

      Request Payload

      Element Name Type Description

      contractId

      long

      The identifier of the contract.

      contractLineId

      long

      The contract line identifier.

      headerExternalSourceKey

      string

      The external source key of the header.

      headerExternalReferenceKey

      string

      The external reference key of the header.

      lineExternalSourceKey

      string

      The external source key of the line.

      lineExternalReferenceKey

      string

      The external reference key of the line.

      closedDate

      {http://xmlns.oracle.com/adf/svc/types/}date-Date

      The date when the contract was closed.

      closeReasonCode

      string

      The close reason code of the contract.

      trnCodeSetId

      long

      The transaction code set identifier.

      Response Payload

      Element Name Type Description

      result

      {http://xmlns.oracle.com/adf/svc/types/}MethodResult

      The result of the close operation that also includes the warning or information message.

      To associate a project to a contract you can use createContract, mergeContract, mergeContractInAllStatus operations in Contract Service Version 2.

      Details are available : https://docs.oracle.com/en/cloud/saas/engagement/19a/oesws/contract-service-version-2-ContractService-svc-8.html

      Sample payload is attached to this reply.

      Do let me know if you would need more details.

      Regards,

      Rajesh

       

    • Clara Horvath

      Hello,

      I'm also interested on this solution through SOAP web service. We would need to adjust contracts, to remove billing resources from one specific line. My question is if we do this update by SOAP, will this create a new contract version? because we don't want to create new version which needs to be approved.

      regards,

      Clara

       

       

    • Rajesh Choudhary

      Hi Clara,

      We can amend the contract with/without versioning through the SOAP service.

      But, either way, the contract will go into under amendment status and needs approval.

      Regards,

      Rajesh