Channel Revenue Management - EBS (MOSC)

MOSC Banner

Trade Management: Budget Dashboard - DFF from different tables - OZF_FUND_TABLES / QP_LIST_HEADERS_B

Hi all,

EBS Information Discovery 12.2.6 (V7) for Trade Management

My client wants to customize the Budget Dashboard in Trade Management by adding some new DFF filters. The base view behind the Dashboards extracts all the attributes from the table OZF_FUNDS_ALL but I would like to add new DFF filter coming from the QP_LIST_HEADERS_B. My issue is that the SQL behind looks like this:

SELECT SUM(AMOUNT), ATRIBUTE1, ATTRIBUTE2,....ATTRIBUTEn

FROM OZF_FUNDS_ALL

GROUP BY ACCOUNT_ID

Being new to EBS Trade Maangement I would like to know if it is doable? How can I look for some new DFF attributes using a different table in the base view when there is already a set of DFF attibutes?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center