Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

When creating Custom FDMEE Report custom columns not displayed

2886698Mar 22 2016 — edited Apr 12 2016

I am in the process of creating a custom FDMEE  report but when generated is missing data in fields from a query. steps to create the report were:

1. generated the query

2. created the RTF template and converted to XLF in BIP desktop.

3. uploaded and tested the query in sqldeveloper and query definition

4. In report definition i created the standard report parameters for POVLOC, POVCAT, POVPERIOD and POVRULE. and pointed to uploaded XLF template and previous query

5. When executing the report only the parameters specified are populated in the generated report.

I'm not sure what the issues could be as everything seems to be correct.

Here is my query:

select distinct

t.loadid,

p.partname,

p.partdesc,

c.catname,

per.perioddesc,

r.rule_name,

r.file_path,

a.execution_start_time,

a.execution_end_time,

a.records_processed,

a.status,

a.last_updated_by

FROM tdataseg t

INNER JOIN aif_process_details a ON t.loadid = a.process_id

INNER JOIN TPOVPARTITION p ON t.partitionkey = p.partitionkey

INNER JOIN TPOVCATEGORY c ON t.catkey = c.catkey

INNER JOIN AIF_BALANCE_RULES r ON t.RULE_ID = r.RULE_ID

INNER JOIN TPOVPERIOD per ON t.PERIODKEY = per.PERIODKEY

WHERE   (~POVRULE~ IS NULL OR r.RULE_ID = ~POVRULE~)

AND

((t.PERIODKEY)=~POVPERIOD~ )

    AND ((t.CATKEY)=~POVCAT~)

    AND ((t.PARTITIONKEY)=~POVLOC~ )

I am using FDMEE version 11.1.2.4.0

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 10 2016
Added on Mar 22 2016
5 comments
1,252 views