BI Publisher
Discussion List
-
Accessing user-defined tables in OTBIContent Hi All, I have few user defined tables in HCM.Department ID and Department Name. Now I want to access this user defined table and user defined columns and put a …User_DYMHE 329 views 1 comment 0 points Most recent by MandeepKGupta Reporting and Analytics for HCM -
Calling UDT in OTBISummary We need to get UDT values on OTBI AnalysesContent Hi All, I am working on an OTBI analyses where we need to derive values from UDT. I am not able to see these UD…Vibha Pandey - Oracle 682 views 19 comments 0 points Most recent by User_F1ZIP Reporting and Analytics for HCM
-
Sql to find Learn content without a course, Offering and Selfpaced ActivitySummary Sql to find Learn content without a course, Offering and Selfpaced ActivityContent It would be a great help if you can give me the sql which can find the Content…Mansur Khalil 105 views 2 comments 1 point Most recent by Akash Kiran Jana Reporting and Analytics for HCM -
Search Prompts for Direct Database AnalysesSummary How do you add filters to an analysis created from a direct database query?Content When putting search prompts / search parameters on an analysis based on the OT…User_2025-02-04-06-02-17-038 27 views 3 comments 1 point Most recent by User_2025-02-04-06-02-17-038 Reporting and Analytics for HCM -
Audit for multiple open assignment-related transactions on same associateSummary Audit for multiple open assignment-related transactions on same associateContent Good afternoon. Wondering if anyone has built an audit (in either OTBI or BIP) t… -
Number of days left of vacationsSummary Number of days left of vacations for a person who's been let go or has resignedContent Hi, I'm trying to get the number of days left of vacations from a person w…User_2025-02-05-01-30-45-449 39 views 5 comments 0 points Most recent by User_2025-02-05-01-30-45-449 Reporting and Analytics for HCM
-
Query to find recent payroll actionSummary Query to find recent payroll actionContent For a particular employee, on the same day, they have processed payroll actions such as "Regular Normal" once and "Pro…SuryaMuralidharan 484 views 1 comment 0 points Most recent by Thiru Ch Reporting and Analytics for HCM
-
Date prompt is getting passed in invalid format to BI report used in Dashboard.Summary Date prompt is getting passed in invalid format to BI report used in Dashboard.Content Hello, We are facing an issue in while using dashboard as BIP as content. …~ GK ~ 349 views 4 comments 1 point Most recent by Vinod Andhavarapu Reporting and Analytics for HCM -
BIP report issueSummary SQL query time exceeds the limit (2400 sec). Stopped processing.Content Hi Team, As an Admin, I can run a report and it completes sucessfully for me. Users can't…Alvaro Couto 146 views 8 comments 1 point Most recent by Sergio Arizmendi Reporting and Analytics for HCM -
We are not able see the BIP report jobs scheduled by othersSummary We are not able see the BIP report jobs scheduled by othersContent Hi All, We are not able see the BIP report jobs scheduled by others in Manage Jobs screen. We …
-
Plans to move from OBIEE 11.1.1.9 to 12.xSummary When does Oracle plan to move the OTBI/BIP cloud platform from version 11.1.1.9 to 12.xContent Is there a Statement of Direction or a blog post that states if an…User_2025-01-30-04-37-05-780 42 views 10 comments 3 points Most recent by Aaron Leggett Reporting and Analytics for HCM
-
1-Click Enrollment URLSummary Report generates entire url with Enrollment IDContent We use almost exclusively the Learn Center Designer pages which don't allow an easy option to direct people… -
Audit Log on reportsContent Hi Experts, We are having multiple BI publisher and OBIEE reports set up in UAT and production environments. What is the most efficient way to run audit on the r…User_2025-01-30-00-14-06-021 145 views 7 comments 0 points Most recent by User_2025-01-28-16-10-52-033 Reporting and Analytics for HCM
-
Unable to select Data Source from Data ModelSummary Unable to select Data Source from Data ModelContent All --> I am facing issue with OTM BIP cloud Catalog. Issue: Not able to choose/select Data source from Data …
-
Email Subject line/Body with year and monthSummary Email Subject line/Body with year and monthContent Hi All, We have a requirement in which BI report output(excel attachment) need to be send to user (one email i…nitin Sharma 57 views 4 comments 0 points Most recent by nitin Sharma Reporting and Analytics for HCM
-
BI Publisher Report Not Sent Via EmailSummary BI Publisher Report Not Sent Via EmailContent We currently have a custom BI Publisher report set up to run on the Scheduler. The report is set up to be sent to t…Daniel McMillian 31 views 10 comments 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Learner start date in oracle learn ?Summary Learner start date in oracle learn ?Content How do we get the date the learners started an online course? This isnt in the WLF_ASSIGNMENT_RECORDS_F table?
-
BI Publisher Handle No Data in RTF TemplateSummary BI Publisher Handle No Data in RTF TemplateContent How to handle no Data in RTF template to show a message in RTF instead to generate the report. The XML has 2 l…Misael Gutiérrez-Oracle 85 views 4 comments 0 points Most recent by Misael Gutiérrez-Oracle Reporting and Analytics for HCM -
OTBI reporting on expired approvals/transactions not workingSummary The delivered subject areas do not allow for 'expired' status to be reported upon.Content We have recently configured our approvals to expire after 21 days if th…Denise Rae 50 views 7 comments 0 points Most recent by Manivannan Ramar Reporting and Analytics for HCM
-
Legal employer table/viewSummary Legal employer table/viewContent Hi everyone! Could you please tell me in which table or view can I find the legal employer of a worker? Thanks, Cin. Version Ora…User_2025-02-05-01-30-45-449 43 views 4 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Group and Sum using XSLT TemplateSummary Group and Sum using XSLT TemplateContent i would like to get distinct element_name and summarized hours for selected element_name. Thank you.. …
-
How can i edit or see database query for a pre-defined Subject Area in OBIEE?Summary How can i edit or see database query for a pre-defined Subject Area in OBIEE?Content Hi, I need to know about a SCM predefined subject area backed query or form …
-
BI Publisher : Edit button on the Search windowSummary How to enable the Edit button on the Search box in BI Publisher reportsContent Hello, Has anyone Know how to enable the edit button on the search dialog in a BI …Eduardo Nava 60 views 2 comments 0 points Most recent by Eduardo Nava Reporting and Analytics for HCM