Isn't it the creation date available in "Purchase Receipt Header Details"."Creation Date"? I am referring to the "Receiving - Purchase Receipts Real Time" SA.

Are you trying to include a link to the attachment in the report?

Is there an option to select the output format while submitting the scheduled process?

Are you seeing it this small at 100%? in the layout you could try changing the font size. You can also try creating a RTF template in Word, style it they way you want and then upload that as a template to be used to generate the output.

Hey Shane, Thank you for your response. This is what I have used in both instances. Not sure if this has something to do with access? I am able to see the POs in the OTBI analysis, so I am assuming I have access to view the PO. https:/../fndSetup/faces/deeplink?objType=@{1}&objKey=poHeaderId=@{2}&action=@{3} I also tried…

Thank you, Shane. It seems to be working in one instance. Not the other. Any ideas what could be the reason.

This will be a great feature to have.

It will be great to have report output as the Report Name and not include the Template Name at the end while downloading the output file. This will provide a better user experience.

OTBI is a powerful tool. Most of the reporting needs can be met by OTBI. Keep in mind that it is not meant for high volume reporting. If your report has millions of rows then BI Publisher is the better tool in that case. You can take a look at this tutorial. 

Thank you. This is awesome.

and all the files have the same data?

Thank you for the explanation. This totally make sense. 

Did you type in "year" or was that a member from the subject area? Is there a time hierarchy in the SA, if yes try to use "time hierarchy.Year" in the formula?

I was able to achieve this. * Create Data Model (Make sure to provide bursting details). Refer to this document * Create Report (Make sure enable Bursting in Report Properties) * Create ESS Job (Make sure to enable Bursting) If you have provided the details of SFTP Server in the Bursting definition SQL, you should be able…

Can you take a look at this link. I believe this is what you are trying to achieve.

Can you upload a screenshot?

Not sure about a book. However here is a great resource if you want to learn more about Groovy and EPM. Groovy Series by Kyle Goodfriend Thanks, Arun

Hi Rhea, You have to select "Is Greater Than" condition and then add SQL Expression as TIMESTAMPADD(SQL_TSI_DAY, -7, CURRENT_DATE) See the attached image. Hope this fixes the issue. Regards, Arun

Here is a post that may be helpful https://cloudcustomerconnect.oracle.com/posts/c7acda6e57

Hi Divya, * Create a Data Model * Create 2 Data sets in the data model * Use excel template. Here is a link to Creating Excel Template * On one sheet of the Excel Template fetch data from Data Set 1 * On 2nd sheet of the Excel Template fetch data from Data set 2 Thanks, Arun