Resource OBS mapping missing in DWH_RES_OBS_MAPPING and reports

book

Article ID: 141581

calendar_today

Updated On:

Products

STARTER PACK-CLARITY PPM Clarity PPM SaaS

Issue/Introduction

I can see resources in the DWH_RES_RESOURCE but when I look in the DWH_RES_OBS_MAPPING table I do not see entries for some of the resources.  I can see the resources in clarity with an OBS why are not all of the resources in the OBS mapping table? I am running a Full Load of the Data Warehouse job.

Cause

The reason the resources do not come up in Data Warehouse is that few of the OBS units last_updated_date comes up as null which is not expected. We're not sure how this happened. Might be due to using custom job to create the OBS assignment or Resource Adaptor. 

We found that the reason we see nulls is that for some OBS units the parent Level 1 unit is missing in PRJ_OBS_UNITS. It's not set up to be a level 1 parent so the parent is set to be #2 which still shows the correct OBS path. 

OBS path for the affected resources is  (example)

| Broadcom | Software | BU | Support | Distributed | Clarity

 

Compare to non-affected resource:

Broadcom | Software | BU | Support | Distributed | Clarity

Note top level is a true top level.

You can see how it displays for you here:

select obs_path from

dwh_res_obs_mapping_v

where dw_resource_key in (xxxxxxx,xxxxxx etc)

Environment

Release : All supported releases 

Resolution

Workaround:

Move the Child OBS (the last level) in the the hierarchy and then back. This should fix the issue.

If this does not work we may have to recreate the OBS.

Additional Information

Please also see the attached query on the ticket that will return the faulty departments/levels (you have to add the affected IDs). For things to properly work we need the level 1 and level 2 to be available for the ones that go deep.

Attachments

1575999458157__obs_levels.sql get_app