Scheduled OTBI report missing in month of first day but when manually extract that report no issue

AjayKumar Maddipati

Summary:

Hi Team,

we have custom OTBI report, so we started scheduling to business with filter of April first on words only so when we scheduled that report April 1st missing(its coming april 2nd onwords ) and when we extract same report we get April 1st also.

Please assign India IST avaialbe enginer

Could you please assit on ?

PFA

Output.docx

Thanks,

Ajay

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Amrita Gupta-Oracle

Hi Ajay,

Could you please share the xml of the report.

Also, could you trying setting the format for the date column and then re-running the report.

To set format go to -

Column Properties -> Data Format -> select a date format based on what value you are passing to it -> Save as Default -> the below highlighted option.