My Oracle Support Banner

Unable To Generate Billing Schedule Using A Rest API Call From OCI Integration Due To An Error (Doc ID 2949989.1)

Last updated on MAY 22, 2023

Applies to:

Oracle Fusion Subscription Management Cloud Service - Version and later
Information in this document applies to any platform.


Getting an error while the Rest API call is triggered from OCI integration


Input Payload:
  "GenerateBillingSchedule" : "Y"


PATCH /crmRestApi/resources/{SubscriptionNumber}/child/products/{SubscriptionProductPuid}/child/coveredLevels/{CoveredLevelPuid} returned a response status of 400 Bad Request]]><![CDATA[Failed to lock the record in table OSS_PRODUCT_ASSOCIATIONS with key oracle.jbo.Key[...], another user holds the lock..A 400 Bad Request Error indicates that the target service is unable (or refuses) to process the request sent by the client (Oracle Integration Cloud), due to an issue that is perceived by the server to be a client problem. You can trace the cURL representation of the request sent to the target service from the Oracle Integration Cloud server logs. Try invoking the target service using cURL. It may also be that one of the intermediaries (proxy, LBR) could be returning this code.

The issue can be reproduced at will with the following steps:
1. Trigger the Rest Call from OCI
2. Getting error


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.