Kevin M-Oracle

See the prerequisites section of Adding a Bursting Definition to Your Data Model https://docs.oracle.com/middleware/bi12214/bip/BIPDM/GUID-A926D588-426F-47C7-8A9A-B0A7959C5814.htm#GUID-A926D588-426F-47C7-8A9A-B0A7959C5814 Rgds, Kevin

in How to burst BIP Report output based on a web service based data model Comment by Kevin M-Oracle Oct 16, 2024 3:27PM

Please log an SR include the payload and response. Rgds, Kevin

in How to override existing the BIP report using Webservices Comment by Kevin M-Oracle Oct 14, 2024 2:44PM

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

in Need timestamp along with date as input parameter in Oracle BIP report Comment by Kevin M-Oracle Oct 9, 2024 6:54PM

That is correct, Fusion Applications does not have RestAPIs for Publisher. Fusion Applications has SOAP UIs, See: Available Public Webservices in Fusion Applications(Doc ID 2086077.1). Rgds, Kevin

in How to call BIP report using REST API? Comment by Kevin M-Oracle Oct 2, 2024 2:43PM

Analytics Publisher Rest APIs are not available in Fusion Applications. See: Fusion Applications: How To Access Reports Using REST API? (Doc ID 2327020.1) Rgds, Kevin

in How to call BIP report using REST API? Comment by Kevin M-Oracle Oct 2, 2024 1:26PM

Test the LOV SQL as a dataset. What does it return? Rgds, Kevin

in what are the values passed to dataset in parameter multiple selection in BIP report Comment by Kevin M-Oracle Oct 1, 2024 1:41PM

Multiselect parameters pass a comma separated list of values wrapped in parenthesis and square brackets. Ex: ([value1, value2, value3]). Rgds, Kevin

in what are the values passed to dataset in parameter multiple selection in BIP report Comment by Kevin M-Oracle Oct 1, 2024 10:47AM

This is not Publisher. What application are you using? Rgds, Kevin

in After Create trigger is not working in the custom object triggers in Fusion Comment by Kevin M-Oracle Sep 30, 2024 12:58PM

Easiest method is to select customize for the data model and then edit the SQL data set. Rgds, Kevin

in How to edit the sales order Report data model Comment by Kevin M-Oracle Sep 26, 2024 1:09PM

Hi Fabio, That's great! Rgds, Kevin

in BI Publisher RTF Template, the Tag:"if then else" create return carriage in Word, I do not want them Comment by Kevin M-Oracle Sep 25, 2024 12:40PM

Hi Fabio, I used if@inlines for each condition. The elements all lined up on a single row. Ex: <?if:number(B1_SDG_1)=1?> was changed to <?if@inlines:number(B1_SDG_1)=1?> Rgds, Kevin

in BI Publisher RTF Template, the Tag:"if then else" create return carriage in Word, I do not want them Comment by Kevin M-Oracle Sep 24, 2024 4:03PM

To refresh data in the header (and also to reset page numbers), use for-each@section. See Creating Batch Reports https://docs.oracle.com/middleware/bi12214/bip/BIPRD/GUID-A229808F-D2F6-458E-8E52-9E7FA156FF0E.htm#GUID-A229808F-D2F6-458E-8E52-9E7FA156FF0E Rgds, Kevin

in RTF Template Requirements for PDF Generation Comment by Kevin M-Oracle Sep 24, 2024 1:22PM

Put the repeating section into the Header, and loop using for-each@section. The header will refresh with each new iteration of the loop. See Creating Batch Reports https://docs.oracle.com/middleware/bi12214/bip/BIPRD/GUID-A229808F-D2F6-458E-8E52-9E7FA156FF0E.htm#GUID-A229808F-D2F6-458E-8E52-9E7FA156FF0E Rgds, Kevin

in Repeating a Header When Lines Overflow to the Next Page in an RTF Template Comment by Kevin M-Oracle Sep 24, 2024 12:41PM

Yes, if you upload the sample file to the BIP Plugin in Word. You should be able to select the data element using the Field dialog. Rgds, Kevin

in Field is in DM but not showing on BI Publisher to add to template Comment by Kevin M-Oracle Sep 19, 2024 8:28PM

What type of template are you modifying: RTF, XPT, Excel..? Open the sample data file in the data model, is there data in the field you ant to add? Rgds, Kevin

in Field is in DM but not showing on BI Publisher to add to template Comment by Kevin M-Oracle Sep 19, 2024 3:06PM

Submit the bursting job from BI, under the Diagnostics tab: Select Enable Data Engine Diagnostic and Enable Report Processor Diagnostic. Test, if the output is not generated, check the diagnostics.log. Also test your layout with the bursting chunk of data (defined by the split-by). Rdgs, Kevin

in ESS job Is not generating the PDF file in the output section Comment by Kevin M-Oracle Sep 18, 2024 1:15PM

This is not currently a feature we support. You can register an Enhancement in Idea labs. Rgds, Kevin

in Using BI Publisher I would like to export a "protected" word document Comment by Kevin M-Oracle Sep 17, 2024 1:46PM

Any parameter has to be declared in your package and defined in the data model. What error is being returned. Rgds, Kevin

in How to add a parameter when calling a function from the trigger section Comment by Kevin M-Oracle Sep 12, 2024 5:15PM

Again, if you do not see the data you expect, the data engine log can be a very helpful tool in troubleshooting your custom data model. Rgds, Kevin

in BI Publisher report doesn't fetch data for a global level function. Comment by Kevin M-Oracle Sep 10, 2024 6:19PM

See Formatting Dates in https://docs.oracle.com/middleware/bi12214/bip/BIPRD/GUID-F926959D-B7A5-41DE-8388-2951666A38EE.htm#GUID-2E9599CF-7066-4181-940F-F03C09DD37B5 Rgds, Kevin

in Excel is not considering my date value as date even after I tried many formatting? Need suggestion Comment by Kevin M-Oracle Sep 10, 2024 2:05PM

Welcome to the Oracle Analytics and AI Community

Kevin M-Oracle Rank 6 - Analytics & AI Lead

Comments