My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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