Unable to add new field in RTF template due to the previous grouping structure

Vrinda Choraria

Hello,

In the existing RTF template, I am unable to insert the new field (Transaction Type) due to the previous grouping structure. While the report runs successfully in the AP view, including the Transaction Type field, no output is being captured for the Transaction Type field in the AR view.

Below i have attached the RTF and report output screenshot.

Mallikarjuna Kuppauru-Oracle

Hi @Vrinda Choraria

Are you done the column mapping after adding the column to template? and Same column is available from DM level and are you able to see sample data ?

Regards,

Arjun

Vrinda Choraria

hi @Mallikarjuna Kuppauru-Oracle

Please see response below:

Are you done the column mapping after adding the column to template- Yes 

and Same column is available from DM level- Yes

and are you able to see sample data  - Yes , we are able to see the sample data in oracle fusion before adding the field in RTF format

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/62411#Comment_62411

Hi Vrinda,

The issue lies in the underlined:

The 'E' is end for loop which is ending before your newly added column.

Please cut the 'E' part and paste it under Type, next to Transaction_type tag and it should work.

Thanks.

Vrinda Choraria

Hi @MandeepGupta

Thank you for your solution. However, I tried implementing it, and the issue still persists. I also attempted adding it in the middle of the table, but it didn’t work.

I have attached the RTF file for your reference. Could you please help me add the field to the RTF?

ATL MPV Recon Report (8).rtf

ATL MPV Recon Report (8).rtf

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/62538#Comment_62538

can you share the sample XML as well?

Thanks.