Understand Joins to S_CON_ADDR and S_DEDUP_RESULT in Select Statement Generated when Querying Account Business Component (Doc ID 3031072.1)

Last updated on JUNE 30, 2024

Applies to:

Goal

The Account business component is configured to have joins to S_CON_ADDR and S_DEDUP_RESULT. 

There is no Force Active fields for these joins and those fields are not expose in applets. However, they are still included in the underlying query that should return 1 account record.

Why is the Account business component configured to add this unnecessary overhead. We are having to fetch 3,888 records when 1 record should be returned.

Solution

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