BI Publisher
Discussion List
-
AP_HOLDS_ALL record deleted from the tableSummary: Hi All, we are trying to build a dashboard for AP invoices and related holds. During some tests, we notices that some record in the table ap_holds_all disappear… -
General Guidance on BICC/BIP for PVO JoinsSummary: General guidance on Fusion BICC/BIP for PVO joins & if Fusion supports AI/ML analytics? Content (please ensure you mask any confidential information): My unders…Abdullah Munaz 15 views 2 comments 0 points Most recent by Abdullah Munaz Reporting and Analytics for ERP
-
Why do scheduled reports with a daily frequency cannot be received on a weekend (Saturday & Sunday)?Summary: The business users created a schedule for the daily backup of a report, but the backup mail is being received only from Monday to Friday. Mail for Saturday and …Czarina Morales 12 views 2 comments 1 point Most recent by Czarina Morales Reporting and Analytics for ERP
-
How can I configure "All" prompts in BI PublisherSummary: Content (please ensure you mask any confidential information): I have a report with some parameters, I would like them to come with the default value "All" and,…
-
Error when performing a multiplication on a calculated measure in OTBISummary: Hello, When trying to perform multiplication on a calculated measurement of the items in the image, An error occurs that I have not been able to resolve. Conten…
-
How to remove special characters in the output of a e-text templatesSummary: We want to send all the open POs to a third party system in .txt format. The item description have a lot of special characters, how to remove it in the output w…
-
Can I change the date format in the BI Publisher data model to 'DD/MON/YYYY'?Summary: In the Fusion, publisher reporting → data model→ SQL Query "select to_char(to_date('12/09/2024','DD/MM/YYYY'),'DD/MON/YYYY') from dual;". It always returns 12/0…Amanda H5KKO 31 views 4 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
How to use multiple delivery channels in Bursting query -Fusion BISummary We would like to explore the option to set delivery channel as SFTP and also we want to send delivery status notification to one particular email address .Conten…Sankeerthana Anumasula-Oracle 432 views 6 comments 2 points Most recent by Gurujothi D Reporting and Analytics for ERP
-
Dyanmic Deep Link in OTBISummary Need to identify mechanis to have dynamic deep links in OTBIContent Hi There, We have developed around 15 reports in OTBI having a deep link embeded in each of t…
-
PL/SQL Query to ADD Month to a Period NameSummary: I have a scenario where a user will pass input period name. The query should return data of both the current period entered by the user and the previous period.…
-
How to add a header to the e-text outputSummary: By default the e-text layout output doesn't have column headers. We have a requirement to add the headers as well for the integration file with the third party.…SuniChacko 11 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
How to add 2 columns in group by in Excel templateSummary: Need to add 2 columns in Group by expression in EXCEL template Content (please ensure you mask any confidential information): below condition is working for 1 c…Thanigainathan R 21 views 2 comments 0 points Most recent by User_6NK6Y Reporting and Analytics for ERP
-
Want to embed only bip report output and not the header sectionSummary: Hi Experts I want to embed below bip report in the supplier page but i could see that when i embed the bip page the header containing web page, home, catalog,fa…mudassirsOrc-Oracle 11 views 5 comments 1 point Most recent by Aishwarya1990 Reporting and Analytics for ERP
-
Inquiry AP ReportSummary: Is there a Payables report that I can run that provides a clean listing of invoices as of a specific date that make up the balances shown on the Payables Trial …
-
How to create a parent schedule for multiple schedule of one BI Publisher reportClient has created multiple schedule of one one BI Publisher report using different parameters ex-cost centres and different recipient in each schedule. Is it possible t…
-
How to get Amount in Words in Arabic language in excel template with Saudi currencySummary: I have total eg: 21113.75 and it should show in output 'Twenty-One Thousand One Hundred Thirteen Saudi Riyals And Seventy-Five Halala' Can someone please assist…Rahul K-Oracle 11 views 0 comments 1 point Started by Rahul K-Oracle Reporting and Analytics for ERP
-
Fixed Assets To and From Period range parameterSummary: I'm editing a DM for a fixed assets report. My task is to create a "To Period" and "From Period", the issue is in the SQL no matter how I've written it in to be…
-
can not find new option under file menu in FRS to create a batch in BI cataloguecan not find new option under file menu in FRS to create a batch in BI catalogue
-
Not able to add Budget Values(amount) column in FRS Report.We have an FRS Report for Profit & Loss Account where the accounted values are reflected. We have a requirement to add Budget Values also in the FRS, but we have tried e…Jagjit Singh Arora 31 views 4 comments 0 points Most recent by Jagjit Singh Arora Reporting and Analytics for ERP
-
How to get IP address of Fusion SaaS BI server that sends out email via burstingSummary: How to get IP address of Fusion SaaS BI server that sends out email via bursting. This is needed for white listing the From address to allow email to reach corp…Nirmal Ignatius 11 views 0 comments 1 point Started by Nirmal Ignatius Reporting and Analytics for ERP -
No Data Found when Other Users run BIPSummary: I created a simple vendor report with BIP. I can run it fine and see the data such as vendor name, number, address, etc. I have another user, Employee B, who on…
-
ORA-06512: at "SYS.XMLTYPE", line 169Summary: Hi, i have created the AR Invoice Auto Mail by taken the reference of "Print receivable transactions", if i schedule the report the report should send the invoi…Siva BVP-Oracle 11 views 0 comments 1 point Started by Siva BVP-Oracle Reporting and Analytics for ERP
-
Supplier bank country field in OTBI reportSummary: Supplier bank country field not found in "Supplier-Supplier Real Time" OTBI Subject area Content (please ensure you mask any confidential information): Version …
-
how to use SQL to create otbiI have Created an sql query for BI report , but I want to convert it to OTBI analysis is there any way to achieve this ?Mohamed Abdelbar 21 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
sql query to fetch sales order(export order) related details from oracle fusionhow to get delivery mode(FOB,DDP etc), Exporter(To ship) address,fumigation status(YES/NO) and type of certificate required for a sales order export compliance from orac…
-
how to add multi line text using interface text in sandbox in oracle fusion applicationReplace multi line text using interface text in sandbox in oracle fusion application. output: Expectation: it should print 2 lines with a line gap i. Attach supporting d…Pooja K-Oracle 11 views 2 comments 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Inconsistent running time of BIP reportsHello Everyone, We have an existing Custom BI Report that we are monitoring, running this report thru Scheduled Jobs 10 times to check how long this report run. Sometime…Michael_B 31 views 3 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
How to call an OIC integration from BIP reportSummary: I have created an app driven integration with two request parameter. How can I submit the integration from BIP report? Content (required): I got a blog https://…Ananya Sadhukhan 2.5K views 16 comments 0 points Most recent by Charan K Reddy Reporting and Analytics for ERP
-
Oracle BIP Report Not SummingI need your help in my RTF template that has a sum for every each segments. I added the field in the cell, set the Calculation to Sum and checked the Grouping. Generated…Sofia Danielle Sarmiento 11 views 0 comments 1 point Started by Sofia Danielle Sarmiento Reporting and Analytics for ERP
-
Is there a Oracle DB package / function to retrieve a country code from a given location_id?Summary: Hello, I'm looking for a Package / function which I can use in a BIP datamodel to retrieve a country code for a given location id. Some of the seeded datamodel …