When creating Custom FDMEE Report custom columns not displayed

2886698

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

Francisco Amores

HI

is this solved?

you will need some troubleshooting.

did you check the aif webapp log in the server?

Francisco Amores

Is it working fine if you set point the template to the RTF file?

2886698

Hi, this is still not working. I have both uploaded RTF and XLF in the relative locations. But the template is still only populating fields selected when running the report.

I looked in the aif webapp log and the query looks like its running correctly, no errors.

Balakumar7

did you try the generate xml in the query defintion field and check if the custom fields are populated?

Thanks,

Bala

2886698

I did not try that. I'll give that a go.

Thanks