BI Publisher
Discussion List
-
Query underlying UCM tableSummary Query underlying UCM tableContent Is there an available table or view that gives access to the UCM? I don't care about the actual attachment and the contents wit… -
Parameterized Bi Report Within A Dashboard Is Not WorkingContent Hi Team, Greetings of the day!! I have created a dashboard with BI Report having one parameter. The report is working as expected with the same parameter but in …Divya Kollipara 41 views 4 comments 0 points Most recent by Divya Kollipara Reporting and Analytics for HCM
-
Need a query for a date parameter dependent to another date parameter.Content Hello all, There's a query I need to get the month names separately with one parameter and another parameter to select a date range. The month name parameter sho…Sushan Peiris 552 views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM -
Subledger Period Close Exceptions Report query timeoutSummary SQL query time exceeds the limit (2400 sec). Stopped processing.Content Hi, just wondering if anyone has any experiences with the Subledger Period Close Exceptio…User_2025-02-10-13-18-56-927 32 views 0 comments 2 points Most recent by User_2025-02-10-13-18-56-927 Reporting and Analytics for ERP -
report of all data access set access given to usersSummary Can we get a report of all data access set access given to users, along with current access and history of terminated accessContent Can we get a report of all da…User_C3J94 45 views 2 comments 1 point Most recent by User_C3J94 Payables, Payments & Cash Management
-
Course File Path ReportSummary Need to identify the file path of all SCORM and AICC courses in Taleo Learn.Content We are transitioning content and need to identify the file path for each of t…
-
How to calculate the Bonus amount only for asset cost adjustments and not for asset additions?Summary How to calculate the Bonus amount only for asset cost adjustments and not for asset additions?Content Hi Experts, How to calculate the Bonus amount only for asse…
-
Report to find requisition approval reassignmentsContent Hi, We need to create a BI Report showing which requisitions were reassigned to other users. The FND_BPM_TASK_VL/HISTORY tables don't seem to have this informati…
-
Oracle BIP DataModel -> Default views 'Table View' and '200' rows - PossibleSummary BIP Default ViewsContent Hello, Just wondering if there are any default settings available to achieve 'Table View' and '200' rows. Attached a picture. I don't an…SantoshKumarBhairi 87 views 10 comments 4 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
How to create a label called "ALL" when selecting all from a parameter in BI reports.Content Hello all, I want to know if there is any way that I could display a word called "ALL" when I select all from a LOV of a parameter in the BI report in ORACLE FUS…Sushan Peiris 801 views 4 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
BI Data Model: finding all reports that this is attached toSummary How to know all the reports that use xyz data model?Content Hello, I have a data model in BI Publisher. I assume 3 reports are connected to it. But how can I be …User_2025-01-28-21-53-32-678 29 views 3 comments 2 points Most recent by User_2025-01-28-21-53-32-678 Reporting and Analytics for HCM
-
BIP Report job's output in PDF format is not getting downloaded but opened in the browser.Summary BIP Report job's output in PDF format is not getting downloaded but opened in the browser.Content We have created a report with bursting logic to split a pdf fil…Mandavi Shrivastava 293 views 2 comments 1 point Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM
-
Conditional Logic in RTFSummary Conditional If-Then-Else and Looping logic in RTF TemplateContent Hi All, I am trying to add conditional logic, specifically using If-Then-Else statements, in an…Denise Izzi 379 views 6 comments 3 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM -
BIP Data Sources accessSummary BIP Data Sources accessContent Hi Experts, Does anybody know if it is possible to restrict access to the Data Sources in the BIP data model UI? I appreciate any …Volodymyr Faranosov 43 views 7 comments 1 point Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM -
How do we distinguish between custom reports and standard reports?Summary We want to know how many custom reports are created in reporting center. How do we distinguish between custom reports and standard reports?Version Oracle Fusion …Patrick Chrabieh 234 views 2 comments 7 points Most recent by Skolli-Oracle Reporting and Analytics for ERP -
How to embed hyperlink from OTBI report - data column field into Apps Composer CRM custom formSummary I need the ability to drill into some Custom App Composer CRM data from a Dashboard Report on that data set. Non Standard Oracle Cloud App FormsContent I need th…User_2025-01-30-01-01-15-242 33 views 2 comments 0 points Most recent by User_2025-01-30-01-01-15-242 Reporting & Analytics for Sales
-
Audit DahsboardSummary Need help finding Audit DashboardContent I remember seeing Audit Dashboard. I can't seem to find it. Does anyone know is there a Oracle delivered Audit Dashboard…User381997 66 views 1 comment 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Edit Grand total in pivot tableContent Hi there, we made a Pivot table in OTBI analysis with pay elements in column. We have been able to add the Grand Total of them but we would like to exclude an el…Chiara Arcidiacono 22 views 7 comments 1 point Most recent by SimonTomey Reporting and Analytics for HCM -
Department HierarchyContent Hi all - I have a great report that we use for Department Hierarchy through OTBI, but we need this report through BIP. We have users that will pull this data the…Prudence K 64 views 12 comments 1 point Most recent by Nivya Mathire Reporting and Analytics for HCM -
Compensation Components table for BIContent Hello experts, do you know the Oracle tables to extract compensation components values and components name? Thanks in advance for your time! Kind Regards, ValerioValerio Curzi 36 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Learning Admin not able to access Non-catalog item from Approval Notification LinkSummary Learning Admin not able to access Non-Catalog item from Approval Notification Link.Content Hi Folks, Scenario Employee submits a request for non-catalog item. As… -
Query to fetch sum of debit memos and credit memos for an original invoiceSummary Am looking for a query to get sum of credit memos linked to original invoice ie Original invoice -HCS1 Credit memo-HCS2 as shown in below screenshots.Content I w…Sankeerthana Anumasula-Oracle 939 views 2 comments 1 point Most recent by Sankeerthana Anumasula-Oracle Reporting and Analytics for ERP
-
Is it possible to send two attachments in single bursting?Summary Is it possible to send two attachments in single bursting?Content We had a requirement to send same output with two different formats (Ex: Excel and PDF). we nee…Koteswararao Yenikepalli 68 views 4 comments 0 points Most recent by User_KM4LK Reporting and Analytics for SCM -
Query to find Product Family of ItemSummary Query to find Product Family of ItemContent Hi All I wanted to find the table or query which hold the Product_family details of an items: Below is the screenshot…User_2025-02-11-07-07-59-045 934 views 1 comment 0 points Most recent by User_2025-02-11-07-07-59-045 Reporting and Analytics for SCM