BI Publisher
Discussion List
-
How can I either hide or remove columns easily in a data model?Summary data model bi publisher reportContent I have a data model that I have copied this over. I am trying to remove and/or hide some of the columns, and then move some…User_2025-02-08-08-55-02-564 142 views 8 comments 0 points Most recent by User_2025-02-08-08-55-02-564 Reporting and Analytics for ERP -
How to control the folder permissions in Reports and Analytics to user levelSummary Need to control users to access the folders within the permissions provided and controlled at the user level, Please provide the details how to control this fold… -
Need Help with E-textSummary Arabic data getting Jumbled in Etext tempalteContent Hi There, We are having a requirement wherein the data in the database is in Arabic. We are preparing the e-…Sahil Makhiza 33 views 24 comments 1 point Most recent by Sudha KOVURU Reporting and Analytics for ERP
-
Show Declaration while running BI ReportSummary Show Declaration while running BI ReportContent Hello Experts Is there a place where we can show declaration before running/scheduling a report ?A checkbox will …Murthy Kodavati 35 views 4 comments 0 points Most recent by Murthy Kodavati Reporting and Analytics for ERP -
Need SQL join to show bank assignment to supplier siteSummary We assign bank accounts to supplier sites, I need the table joins to allow me to create a data model to show which bank account is assigned to each supplier site…User_2025-02-04-14-03-09-386 259 views 2 comments 0 points Most recent by User_2025-02-04-14-03-09-386 Reporting and Analytics for ERP
-
RTF Template Table Overflow - SolvedSummary RTF Template Table Overflow to a different table in the same RTFContent Hi, I am trying to create a report where the data overflows from one table in an rtf to a…
-
what is the role of ar_receivable_applications_all.display columnContent ar_receivable_applications_all.Display = 'Y' or 'N' what will happen in each case. Can anyone explain? BR LuckyLucky Sharma 71 views 6 comments 1 point Most recent by Nishanth B Jain Reporting and Analytics for ERP -
Tables in which Printer name and details are savedSummary Tables in which Printer name and details are savedContent Whenever any Customer facing document/report is sent through a BIP report to the printers, is there any…
-
How to pass field value(s) from Page to OTBI (for report or dashboard generation) ?Summary An iFrame is created in an existing Page layout in order to accommodate a OTBI report. How to pass field value(s) from Page to OTBI (for report or dashboard gene…
-
BI Publisher Group filterSummary BI Publisher Group filterContent I am getting the attached error when i am trying to add two filters. any idea why ?Shlomo Elnekave 51 views 1 comment 0 points Most recent by Shlomo Elnekave Reporting and Analytics for ERP -
How to create custom XML output formatSummary How to create custom XML output formatContent Hi All, We have to generate a custom .xml output file from ERP cloud . How can we generate XML output file from BIP…Najeeb_ACN 254 views 5 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP
-
Spend calculations - Procure-To-Pay Subject AreasSummary How is Spend value calculated in Procure-To-Pay Subject AreasContent Gurus, Looking at seeded 'Top 10 Spend by Category' OTBI report and see Spend column. Wonder…Manoj Acc 48 views 1 comment 0 points Most recent by Nishanth B Jain Reporting and Analytics for ERP
-
How to call oracle functions from BI Data model ?Summary How to call oracle functions from BI Data model ?Content Hi, In EBS i used to build custom functions and i was using it in discoverer. i am looking for function …Shlomo Elnekave 168 views 3 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP
-
R13 Query Open AR InvoicesSummary AR Cloud ReportContent Hello : I was wondering if you can hep me about an AR Invoices Report for Cloud. Please Advise Below is the SQL but it only works for EBS …gabriel kinovisques-163562 467 views 7 comments 0 points Most recent by gabriel kinovisques-163562 Reporting and Analytics for ERP
-
How to increase the query time out in Oracle fusion BIPContent Hi Team, One of report is getting error due to query time out. We want to increase the query time out for this report. Could you please do the needful. Version 2…Jayaprakash Mathakamalli 209 views 6 comments 0 points Most recent by Jayaprakash Mathakamalli Reporting and Analytics for ERP
-
Performance of BI GL balances querySummary Performance of BI GL balances queryContent The Attached BI query timesout when executed with just the tree values. I have passed nulls for the remaining levels c…saravana maneeian subhramaniun 62 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
How to fetch -4 days from to_date without weekend and holidaysSummary Hi, i need to fetch -4 working date from to_date. so here i am using gl_periods table to get start_date and end_date. end date -4 should be my to_date.Content Hi…
-
OTBI dashboard operators link to BI publisherSummary Can we use OTBI dashboard operators in BI Publisher sqlContent We are embedding SQL query based BI publisher report in OTBI dashboard. The OTBI dashboard has an …saravana maneeian subhramaniun 87 views 6 comments 0 points Most recent by Karina Ogata Reporting and Analytics for ERP
-
ESS Job Dependant Parameter LOVsSummary ESS Job Dependant Parameter LOVsContent Hi , I need to create two LOVs for Supplier Name and Its dependent Supplier Site for the ESS Job. Is this feasible ? I ca…Soumya Prakash Parhi 62 views 4 comments 0 points Most recent by Sujan Gutha Reporting and Analytics for ERP -
URL to download expense report attachments from UCMSummary URL to download expense report attachments from UCMContent Hi, I am trying to download the attachments in my expense report from UCM. I was able to fetch the DM_…Shifa Nazumudeen 183 views 8 comments 1 point Most recent by Shifa Nazumudeen Reporting and Analytics for ERP -
Attach Custom List of Value to ESS JobSummary Custom List of Value to ESS JobContent Hi Experts, I have two questions pertaining to ESS jobs and are as follows:- 1) How can I attach a custom list of value to…Sahil Makhiza 63 views 3 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP
-
Anyone has query to link PPM projects with GL in fusion?Summary Anyone has query to link PPM projects with GL in fusion?Content Anyone has query to link PPM projects with GL in fusion?Pradvin Heggar Prabhakar-147626 90 views 0 comments 0 points Most recent by Pradvin Heggar Prabhakar-147626 Reporting and Analytics for ERP
-
Creating Custom Account Analysis ReportSummary Create Account Parameter(Similar to Oracle seeded Account Analysis Report) in Custom BI report(ESS Job)Content Hello, I am creating a custom bI report similar to…User_2025-01-28-02-08-49-904 128 views 1 comment 0 points Most recent by User_QEU3G Reporting and Analytics for ERP
-
ExternalReportWSSService -> runReport failing with error 415 Unsupported Media TypeContent I am trying to run a simple report from pl/sql using ExternalReportWSSService -> runReport and it is failing with error 415 Unsupported Media Type. The same payl…Murthy Kodavati 131 views 1 comment 0 points Most recent by Murthy Kodavati Reporting and Analytics for ERP
-
Remove zero lines from customer statementSummary Remove zero lines from customer statementContent Hi, I am trying to modify the attached customer statement template to exclude lines where F_amount = 0 Any idea ?Shlomo Elnekave 65 views 3 comments 0 points Most recent by Shlomo Elnekave Reporting and Analytics for ERP
-
How to register ESS Jobs in R13 20B?Summary How to register ESS Jobs in R13 20B?Content Hi Everyone, Can you please share your thoughts on How to register ESS Jobs in R13 20B? Thanks, -
Distribution Email List for ESS JobsSummary Distribution Email List for ESS JobsContent Hi Everyone, Can you please share your thought on , how to setup distribution Email List for ESS Jobs? Thanks,
-
oracle.xdo.servlet.data.DataException: ORA-01722: invalid numberSummary oracle.xdo.servlet.data.DataException: ORA-01722: invalid numberContent Hi i have below error in Data model Parameter name: p_JV_NUM oracle.xdo.servlet.data.Data…Mahgoub S.Mohamed 369 views 3 comments 0 points Most recent by Ahmed Mousa Reporting and Analytics for ERP -
Is it possible to link a BIP or OTBI report to an FR report using related contentSummary Recently found that we can drill to a second FR report using related content and the parameters get passed on from the first report cell from which we drill. Exp…Shweta Prithviraj-163613 39 views 0 comments 0 points Most recent by Shweta Prithviraj-163613 Reporting and Analytics for ERP
-
Tracking non-financial information related to a chart of account segment for reporting with GL BalanSummary Does anyone have recommendations for storing non-financial information related to a chart of account segment and related GL Balance?Content We have some non-fina…User_2025-02-04-18-03-15-131 31 views 1 comment 0 points Most recent by ndryden Reporting and Analytics for ERP