Collected data does not display when using Collections Workbench (Doc ID 756241.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.9 and later
Information in this document applies to any platform.
FORM:MSCFNSCW.FMB - Planner Workbench

Symptoms

Item shows up in msc_system_items, but find the item on the Collections Workbench.
Other items that have similar setups appear in the Workbench.
(While this example is based on the Collections Workbench, it also applies to the Planner's Workbench.)

STEPS
1. (R) Advanced Supply Chain Planner
(N) Collections / View Collected Data
query on item - equals - <item name>

2. Check msc_system_items and see that item appears in SQL output

select * from msc_system_items where item_name like '&item_name';

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