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.
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
where dw_resource_key in (xxxxxxx,xxxxxx etc)
Release : All supported releases
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.
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.