MFCS-REST- /service/items/create And Service/item/location/create Too Slow in v24.x (Doc ID 3042623.1)

Last updated on DECEMBER 06, 2024

Applies to:

Symptoms

On : 24.0 version,

ACTUAL BEHAVIOR
---------------
MFCS-REST- /service/items/create and service/item/location/create too slow

The time of response of two WS /service/items/create and service/item/location/create are too long and can't be used on time-real application requests.

Using an ESB API that calls :
reserve WS
create ITEM WS
Create Item loc WW

When doing many iterations , the time of response on the 2-3 first ones is really bad (even a timeout > 1 min)
But it's better afterwards, that's why the average time is around 5 sec in the end and even 2sec for 290 iterations.

The problem is that for this specific use case : You need to create one item only so it's really bad performance in this case.

The ESB is a synchronous one used to create items immediately before sale so if calling the WS it times out so you can't create the item and you can't sell it.



EXPECTED BEHAVIOR
-----------------------
The performance should be of 400 ms and it was never like this before



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1- Call the reserve WS
2- Use the json joined to create the item (item_level= 1 and 2 )

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot quickly create an item on demand in order to sell it straight away.

Cause

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