ItemLoc_Fnd_ProcessFlow_From_RMS BDI Job is Having Performance Issues and Failing With "ReceiverResource - Block count(10226) exceeded the block limit(10000)" Error
(Doc ID 2718739.1)
Last updated on OCTOBER 13, 2020
Applies to:Oracle Retail Integration Cloud Service - Version NA and later
Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.
As part of seeding the data from RMS application to downstream applications like OCDS or SIM, ItemLoc_Fnd_ProcessFlow_From_RMS BDI job is running extremely slow and having performance issues. Finally it fails with below error:
ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR ReceiverResource - Block count(10226) exceeded the block limit(10000) for TRANSACTION_ID(Tx#xxxx_xxxx_RMS).
This happens when the source data has millions of records that are to be seeded.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!