Cross-Dataset Filter Propagation Issue Between Work Orders and Invoice Datasets in Oracle ECC v9

I am using:

• Oracle Enterprise Command Center Framework Version 9
• Application: Enterprise Asset Management

Dataset Configuration: I have configured three datasets with the following shared attribute:

1. eam-wo (Work Orders - Maintenance) → work_order_number
2. wo-asset (Work Order Assets - Maintenance) → work_order_number
3. ap-paid (Invoice Payments) → attribute14 (DFF field containing work order number)

Configuration Completed:

• Dataset associations established between eam-wo, wo-asset, and ap-paid following Oracle ECC Extensibility Guide
• Three separate results table subtabs configured: Work Orders, Work Order Assets, and Invoices
• Each results table bound to its respective dataset
• Refinement/filter created on attribute14 within the Invoices subtab

Issue Description:

Filter propagation works inconsistently depending on which dataset initiates the refinement: