Hi All,
We have a requirement in BIP report where user need to enter the date along with time (hours, minutes and seconds).
Does anyone come across similar requirement or any thoughts please let us know.
Thanks in Advance
Satya.M
Set the date format of the date parameter to a valid JAVA format that includes time.
Ex: MM-dd-yyyy hh:mm:ss
You can also read about Date Paramters here:
https://docs.oracle.com/middleware/bi12214/bip/BIPDM/GUID-0D9ECE19-8672-43FD-B4E2-68074296C54F.htm#GUID-1FA3A641-1CE3-4B91-B788-F46E5E5B7777
Rgds,
Kevin
Hi Kevin,
Thanks.
Timestamp is working now. but we also need to select the timezone.
Tried this syntax yyyy-MM-dd hh:mm:ss.SSSZ. But it is not working as expected.
Let us know if you have any working syntax for the same.
Regards,
Hi,
I have tried yyyy-MM-dd hh:mm:ss.SSSZ as well, it did not work.
Can someone through some inputs on this one.
Hi everyone, We configured a SOAP connection in Oracle Integration Cloud (OIC) using OAuth authentication. However, when we run our integrations, the SOAP invocation fails intermittently. Some integration iterations fail. Most iterations succeed. Sometimes, all iterations complete successfully without any issues. When we…
OTM/GTM Product is currently using OAC for reporting. We wanted to know what is the limitation for oracle BI Publisher rtf template size. We already have verified the documentation : https://docs.oracle.com/en/cloud/paas/analytics-cloud/acpmr/top-faqs-design-publisher-reports.html But wanted to know if this generic figures…
Hi, We are trying to retrieve the complete history Bip report of assignment updates where the same assignment record has been modified multiple times with an unchanged Effective Start Date. We are currently using PER_ALL_ASSIGNMENTS_M and PER_ALL_ASSIGNMENTS_M_; however, the data returned does not consistently reflect all…
Hello Team, I am generating a BI Publisher report scheduled through an ESS Job with the output format as CSV. When the report returns no data, I need the output file to contain only the column headers. However, the generated CSV contains the headers followed by an additional first data line with delimiters only, which is…
Anyone facing issue with calling the https://xxxanalytics-[tenant]-ia.analytics.ocp.oraclecloud.com/xmlpserver/services/ExternalReportWSSService?wsdl with runReport operation with WSS-Username Token after recent upgrade with OAC ? The Basic Authenticaiton works from SOAPUI , however the WSS-Username Token does not work and…
