Performance Issue: Price List Item REST API Response Time Exceeds 1.5 Minutes in Real-Time
Dear Cloud Community,
Hope you are doing well!
We are currently implementing a real-time integration to fetch pricing details from Oracle Fusion, using Price List and Inventory Item as input parameters.
As part of this integration, we are invoking the following REST endpoint to retrieve Price List Item details:
Endpoint:
<serviceInstance>/fscmRestApi/resources/11.13.18.05/priceLists/<PriceListId>/child/items?q=Item=<ItemNumber>
This endpoint returns the PricelistItemId, which we then use to fetch the associated charges for that Price List and Item via the following endpoint:
<serviceInstance>/fscmRestApi/resources/11.13.18.05/priceLists/<PriceListId>/child/items/<PriceListItemId>/child/charges
Issue:
The initial REST call to fetch the Price List Item details is taking more than 1.5 minutes to respond. This response time is not acceptable for our real-time integration requirements.