Forum Stats

  • 3,757,494 Users
  • 2,251,236 Discussions
  • 7,869,844 Comments

Discussions

When creating Custom FDMEE Report custom columns not displayed

2886698
2886698 Member Posts: 50
edited Apr 12, 2016 11:43AM in Financial Data Management

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

Tagged:

Answers

This discussion has been closed.