For more information, please refer to this announcement explaining best practices for getting answers to questions.
Oracle Extract Output with Duplicate Dependent Rows due to Multiple Legislations
Summary:
Benefits Extract is returning multiple rows for dependents where there is legislative data for multiple countries.
Content (required):
We have several participants due to varying scenarios such as global transfer or expat where the covered dependent may have information populated for multiple legislations. This causes an issue for our carriers as a row is sent for each dependent-legislation combination. We have logged multiple SRs against the issue and it was identified as a bug for a while (Oracle internal Bug 32032546). Recently there's been a change and development has stated this is standard functionality:
"
Per Development:
This is a latent issue and needs Product Management inputs. Cannot be treated as a bug.