T2T CSM_GROUP_DIMENSION_MAP: Incorrect Join Condition on Coverage Type (Doc ID 2972310.1)

Last updated on SEPTEMBER 08, 2023

Applies to:

Symptoms

As per Download Specifications, Stg_Ins_Group_Dimension_Map.v_coverage_type column mentioned as DL-OPT and NULL values allowed. A Null value is being populated in the data. This causes T2T CSM_GROUP_DIMENSION_MAP: Query to not pick up the records as the OOTB T2T uses an inner join condition on DIM_COVERAGE_TYPE

1) Is this an IAA product expectation that Coverage Type will apply to cohorts and hence an Inner Join used?
2) If not a IAA product expectation, then the join condition needs to be modified to have a left Outer Join condition instead?

T2T CSM_GROUP_DIMENSION_MAP defined with inner join with above stage column on DIM_COVERAGE_TYPE.V_COVERAGE_TYPE.

"inner join DIM_COVERAGE_TYPE on DIM_COVERAGE_TYPE.V_COVERAGE_TYPE = STG_INS_GROUP_DIMENSION_MAP.V_COVERAGE_TYPE"

Cause

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