I do not think any workaround worked me for this one. I had to tell my users that if you have a lot of columns to be shown on a report, I suggest they go for an excel or csv extract. It simply would not make a lot of sense to force ourselves to use rtf and keep those pdf outputs with congested columns. if you were to use…

@Federico Venturin - Please see below for reference. Does it mean the Dataset with these types above will be discontinued?

This is possible and we had used this in one of the engagements with the method that @Sandeep S. Chauhan-Oracle mentioned in this thread. We had added the piece of code in footer.

You can create an custom ESS Job with BIPJobType

Hi Mak, I am not aware of that.

Conditional formatting is not supported in excel templates as its done for RTF. You will have to go via RTF route for conditional formatting requirements.

Hi @Salma Ashraf, Could you try like this instead of the SQL statement you used for Person number? Since you use NULL values as passed radio button, I doubt it would pass 'All' back to the query. It will send NULL. Try revising the statement like this and let know if it works. AND (person_number IN (:person_number) OR…

check these if it helps FOS_AGREEMENT_DEFINITION_VL FOS_QUALIFIER_RULES FOS_AGREEMENT_FTR_F FOS_PRICING_OPTION_F

Hi @User_CFV13 , Can you try using the test option? Like this for example, to hide a description field when its null. <xsl:if test="DESCRIPTION and string-length(DESCRIPTION) &gt; 0"> <xsl:element name="description"> <xsl:value-of select="DESCRIPTION"/> </xsl:element> </xsl:if>

We decided to modify the query with conversion of the timestamp columns so we reduce the load of the post processor. thanks all.

As Gianni pointed out above, please give some details while submission of the question so we have all the necessary info to provide some assistance in the forum. It improves the quality of the forum when there is a question with all details so someone can chime in and help. If its a scheduled BI job, you may be able to…

I am not very sure on this with OEM 13c cloud, in ERP Cloud, you can create a global variable and get the count in the xml. And use the bursting query with your dataset query and fetch count using query and you would use in subject. you can find a sample bursting query below Let us know if this is of any help. Best…

@Renuka Nuguru-Oracle - Usually, if we use a transformation on where clause, it calls for a performance test. Is there anything simple to accomplish this for PST clients? It appears odd that we do not have an option to workaround this without a code change.

Hi @Renuka Nuguru-Oracle , Thanks for the update. Our users are requesting that both UI and report output show the same time and date. We are looking for options which would enable us to report data in PST time which is by now 7 hours behind UTC. Users are seeing the date changing to next day when they create transactions…

@Renuka Nuguru-Oracle Application preferences.

Please review attachment

I have not used it that way. Our requirement was not to mark job as error when there is no data.

We did both with no success @Renuka Nuguru-Oracle . Any other suggestions?

Hi @User_M9N9X , I think that option is currently not there in the environment. The trigger works on executing a query based logic. if data found file would be generated, if not then the run will end in Skipped status. Since that is the case, i think it would not be needing a no data message for the user.

Hi @User_M9N9X , You can also try adding a schedule trigger with your query. If the query in the trigger returns a record, it will make it true for execution and else the bursting job would be skipped. Reference Link: https://docs.oracle.com/cd/E29542_01/bi.1111/e22258/add_event_trig.htm#BIPDM330 Thanks, Abhilash