My Oracle Support Banner

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 JANUARY 11, 2024

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.

Symptoms

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:

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.

Changes

 

Cause

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

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

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