ECE CustomerLoader Process Running A Query With A Hardcoded Value/literal Instead Of A Bind Variable
(Doc ID 2721845.1)
Last updated on NOVEMBER 02, 2020
Applies to:Oracle Communications BRM - Elastic Charging Engine - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
On : 126.96.36.199.10 version, Customer, Config, Pricing Migr
ECE customerLoader process running a query with a hardcoded value/literal instead of a bind variable. As a result, each time the query is executed it receives a new SQL ID and a new execution plan is generated.
This is the query:
This behavior has a significant impact on the customer migration process in production, where cutomerLoader is launched every time a new set of subscribers is migrated from the legacy system to BRM.
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