Issue while adding contacts to Service Lines through API

Hi All,

We are adding Billing and Shipping contacts to Service Contract line using API OKS_IMPORT_LINE_PUB.create_k_line_contact. It is working fine in most of the scenarios. However, at times, the contacts are not created and the API throws error "OKC_CONTRACTS_INVALID_VALUE (COL_NAME=cro_code)"

We checked the procedure OKS_IMPORT_LINE_PUB.create_k_line_contact and below are our findings:

1. PROCEDURE OKS_IMPORT_LINE_PUB.get_line_rle_code is being called internally and below cursor query is used to fetch the party roles attached to contract:

CURSOR get_party_role_csr IS