OTBI
Discussion List
-
How can we hide edit link on analysis?Summary: Content (required): How can we hide edit link on analysis. I know how to do this from a dashboard by using the page report links but how can we achieve this fro… -
How to get - when the employee was created in the applicationSummary: Hi Everyone! Is there any way via (BIP/OTBI) to fetch when the employee was created in the application ? Version (include the version you are using, if applicab…ShawShankk 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Create OBTI Analysis for Learning to be automatically assigned to New Hires so many days in.Summary: We would like to start assigning initiatives or courses (whichever will work best) to New Hires within the following days into their job: Upon Hire with 7 days …
-
Do we have subject area to develop OTBI report for EDI related attributes:Summary: We want to create one OTBI report with below sample: Supplier Name Supplier Site Supplier Number EDI documents Name enabled for this Supplier site Content (requ…
-
how to query for this attributes from which table we can get these attributesSummary: Content (required): We want to fetch blended instructor led and self paced from bip query Versio n (include the version you are using, if applicable): Code Snip…
-
Helen Tilling 11 views 5 comments 0 points Most recent by Helen Tilling Reporting and Analytics for HCM
-
Costs for goods sold was not available in analyze product gross margin reportSummary Costs for goods sold was not available in analyze product gross margin reportContent Hi Costs for goods sold was not available in analyze product gross margin re…
-
Is there any reason why OTBI analysis report is not able to fetch details of some supply plans?Summary: In our case, in production environment, we have 2 supply plans and in both of them "Enable for OTBI reporting" is "checked" but our OTBI analysis report is able…Soumya_Gharei 34 views 1 comment 0 points Most recent by Prateek_16-Oracle Supply Chain Planning and Collaboration
-
Error when Combine 2 Subject AreasSummary: Hi All, I am trying to create an OTBI analysis by merging 2 Subject Areas: Worker Assignment Real Time and Person Real Time. The report will display employee wo… -
Show all Lines in Report ExportSummary: I have a large OTBI report that I need to export, and I need it to show all lines. Usually I just change the Data Viewing under Table Properties to Content Pagi…
-
Audit Report using BIP and shadow tables for Assignment ChangesSummary: Looking for a custom BIP report query for Audit purpose using shadow tables. Content (required): We enabled the Audit for multiple products using the task 'Mana…
-
Facing issue in performance goal dashboard reportsSummary: Facing issue in performance goal dashboard reports Content (required): Hi All, We are facing the issue in performance goal dashboard report. Even employee has e…Venkatesan 21 views 4 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Setting custom check format for APSummary: I am setting up custom AP check format first time. Need to know the steps, any document showing steps. Content (required): I need to add custom layout for AP ch…
-
In OTBI report when I schedule the report through agent to me or others all records not coming?Summary: HI Team, We have head count details report with nearly 41000 records and we are used only one subject area(worker assignement real time ) with 25 cloumns so iss…AjayKumar Maddipati 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Sick Leave Duration greater than XX days over a rolling periodSummary: We are trying to report on employees who have recorded more than 40 days of sick leave in a rolling 365 day period. Content (required): We have used Leave Durat…Emily Robinson 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Custom Project Role missing the ability to create a Report using Subject AreasSummary: Custom Project Role missing the ability to create a Report using Subject Areas Using this role when the Users tries to Create a report they can only create the …
-
Default Language in OTBI subject areasSummary: Hello, Do you know which subject area contains employee's "Default Language"? I've created a report presenting default languages in BIP, but it needs to be recr… -
OTBI Agent Sender Name ChangeHello Experts, Need your help & suggestions for the below issue that we are facing recently. We changed the OTBI Agent Sender Name by raising an SR to Oracle Support. It…Bhaskar Konar 52 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Need OTBI report showing all active employees AND whether or not they are enrolled in MedicalSummary: I have been asked to develop a report that shows all active employees (Assignment Status Type = Active) and include a column showing the medical plan name they …JHaden3 332 views 2 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
Need help with CASE formulaSummary: I'm using this formula in an OTBI report (using WFM Worker Assignment Real Time subject area). The formula should do this: If an employee hire date is
-
Not able to add the BI report in View Analytic pageSummary: Content (required): Hi All, We have created a BI report and we want to add this report in the talent review meeting in View Analyst option, but when we are tryi…Faizan Rashid 21 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Serial numbering in the reportHello, In a notification I prepared, I would like to give a serial number to the document that will be sent to the people in that month. For example, document no;01 docu…Sinem Kara 21 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
Subject areas to make analysis of BPM Transactions in OTBISummary: Subject areas to make analysis of BPM Transactions in OTBI Content (required): I need to make an OTBI Report to show the detail of BPM Transactions, including t…Hameed 81 views 1 comment 1 point Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
We need basic details of time card submission details in BI or OTBISummary: HI Team, We need basic details of time card submission details in BI or OTBI. person details. time card submission details, project name, etc. Thanks, Ajay Cont…AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
Consolidated List of OTBI and BI Publisher Reports Posted (10 February 2015)Content The following is the list of published OTBI and BI Publisher reports between 10 December 2014 and 10 February 2015: * Bradford Factor * Extract Manager Hierarchy…Julian Challenger-Oracle 319 views 8 comments 5 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need to calculate Age in BI AnalysisSummary What is the formula needed to calculate age within a BI Analysis?Content I am trying to complete a report to calculate the age levels of employees. I pulled in h…User_2025-01-28-20-43-56-568 209 views 6 comments 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need SQL Query to fetch the Advanced Mode Absence Duration in Absence RecordsHi Experts, Could you please help me on SQL Query to fetch the Advanced Mode Absence Duration in Absence Records. Thanks, Nagaraju.Naga raju Ibba 331 views 4 comments 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
source table for last acceptable promised dateSummary: Unable to find details of last acceptable promised date (change from data) for PO schedule line . Content We have a requirement to present last acceptable promi… -
Export entire dashboard from a custom pageContent Hi Guys, I see that is possible export the entire dashboard from the OTBI by clicking on the Option export to excel. But, my question is: Is it possible export t…Giuseppe Iacono 216 views 18 comments 3 points Most recent by User_VLBBP Reporting and Analytics for HCM