My Oracle Support Banner

Incorrect Count In Custom Object Infolet For M:M Relationship (Doc ID 2405510.1)

Last updated on JUNE 19, 2018

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.12.1.0.0 version, Accounts, Contacts, Households

ACTUAL BEHAVIOR
---------------
Incorrect count in custom object infolet

We have a custom object under Common in Application Composer. Now we have created an M:M relationship for this custom object with Contact(renamed as Individuals) object. This has created an Intersection object under both custom object and Individual object. Now when we expose the intersection object sub tab on the Individual overview page and create a Infolet for the same to show the count, somehow the count in infolet is not showing the correct number of records in the sub tab.

 

EXPECTED BEHAVIOR
-----------------------
Infolet should show count of only the records created via relationship and not the count of the entire object.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an M:M relationship for this custom object with Contact(renamed as Individuals) object. This has created an Intersection object under both custom object and Individual object.
2. Expose the intersection object sub tab on the Individual overview page
3. Create an Infolet for the same to show the count
4. Open Contact and it will show the entire count of Financial Account instead of the one's created via M:M relationship.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users are seeing incorrect data in custom infolet.

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.