INITIAL LOAD FOR PLAN MANAGEMENT DASHBOARD FAILED BECAUSE THERE ARE DANGLING KEYS FOR ITEM DIMENSION (Doc ID 981776.1)

Last updated on FEBRUARY 11, 2015

Applies to:

Oracle Supply Chain Intelligence - Version 12.0.0 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.
***Checked for relevance on 16-MAY-2013***

Symptoms

Problem Statement:

In Supply Chain Intelligence, on R12

  When attempting to run the DBI Intial Load request set for Supply Chain dashboards (specifically the Plan Management Dashboard), the following error occurs in the ISC_DBI_PLAN_F module: Load Plan Management Base Summary concurrent request:

ERROR
-----------------------
Collection failed because there are dangling keys for item dimension

Steps To Reproduce:

The issue can be reproduced at will with the following steps:
1. Login to Daily Business Intelligence Administrator responsibility
2. Create the DBI Supply Chain Intial Load request set (all content) using Generate Request Set functionality within DBI
3. Execute the request set
4. The request set completes with the dangling items error in the Load Plan Management Base Summary concurrent request.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms