My Oracle Support Banner

How To Create Report By Using Dynamic Table (Doc ID 2593071.1)

Last updated on AUGUST 28, 2023

Applies to:

Oracle Demand Management Cloud Service - Version 11.13.19.04.0 and later
Information in this document applies to any platform.

Goal

Business requirement is to fetch data(Shipments Forecast,Final Shipment History,WFT:DEM Mgr Forecast Update) from the plans.

Plan will be a input parameter of the report  and an each plan will create new DYD table like (MSC_DATA_1234_DYD)

How can we build a BI report which will extract information from the DYD tables. As the DYD tables are plan dynamic can we achieve by passing only the Plan name?

Solution

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
Goal
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.