BI Publisher (MOSC)

MOSC Banner

BI Publisher - Bursting issue after converting rtf template to excel template

edited Nov 5, 2019 4:37PM in BI Publisher (MOSC) 5 commentsAnswered

Existing process creates one xml file with 2 .rtf templates that creates excel output.   Bursting template takes the one XML file --- and based on a field in the xml, creates 2 files (ADDITIONS or UPDATES).     Both of these two files have 4 rows per 'Award Number', with each row containing different Award information.

From the same bursting template, a third file is created that uses only 'ADDITIONS' and only selects 1 'Award' row out of the 4 to create 'AWARD_NUMBERS' file.   This selection of only 1 award number happens in the layout template (rtf) of the third file, using an IF statement.  

We have converted the .rtf layout templates to EXCEL layout templates.  The bursting command that creates the ADDITIONS and UPDATES files is working as before.   However, I am unable to filter out only 1 of the 4 rows for the third burst file.   The third file (AWARD_NUMBERS) is being created, but it has all 4 rows for each Award Number, and it needs only 1. 

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