This is my snippet of my added code. Both SUCCESS SCHEDULE
USING HARDCODED DATES
USING LINE2 PARAMETER
Hi
Just to test if it is a datatype issue , can you check if below format works
WHERE TRUNC(htrgs.START_TIME) BETWEEN TO_DATE(:p_startDate, 'DD/MM/YYYY') AND TO_DATE(:p_endDate, 'DD/MM/YYYY')
You can also capture diagnostic log to check the processing
Regards,
Prabhu
@Prabhu Krishnamoorthy -Oracle Hi, Thank you for your response, it shows error when running the DM,
Also this is the Diagnostic if using the the Parameter above.
Thanks. So it appears to be format mismatch
From BI Publisher documentation https://docs.oracle.com/middleware/12211/bip/BIPDM/GUID-69D7FAA1-1C7E-4683-AC4A-D796D2483687.htm
Oracle BI Publisher always binds date column or date parameter as a timestamp object.
To avoid timestamp conversion, define the parameter as a string and pass the value with formatting as 'DD-MON-YYYY' to match the RDBMS date format.
Hope this helps
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
Our Requisition OTBI analysis is having many values Requisition Number Requisition Title Requisition Status Hiring Manager Full Name Recruiter Full Name am able to see values for all. When am passing Prompt(Hiring Manager Full Name or Recruiter Full Name) am not able to see the data. Am sure we have values/data for passed…
Hi Experts, We are using Oracle BI Publisher Email Bursting to distribute reports via email. Currently, one of our bursting outputs generates a report of approximately 20 MB, and we are trying to understand whether there are any size limitations that could impact email delivery. Scenario: Report Delivery Method: Email…
Team, We have a requirement to select below PVOs HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfileItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfilePVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentTypePVO Do we have any documentation around these?
We have a requirement of enabling OTBI report in Purchase Requisition Redwood page similar to classic UI.How can that be done?
