OTBI
Discussion List
-
How do I get current status of previously terminated employees onto a report?Summary: I have a termination report with all prior terminations on it. However, for rehires, I want it to show that they terminated but I need to know that they are cur… -
Where is 'Last Updated Date' in OTBI for Licenses and Certifications?I am trying to pull a report for all licensure in our organization. I see every field listed on the licenses and certifications UI except 'Last Updated Date'. Where woul…JohnMayo1 1 view 4 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Divide Incorrect OTBIHi All, I have a LSQL report which returns an incorrect value when dividing. I've tried other operators such as addition and multiplication, and the formula calculates t…Nick Dorfner 11 views 1 comment 0 points Most recent by Nick Dorfner Reporting and Analytics for HCM -
Employee with Bank Account but no Payment Method ReportSummary: I have a report that picks up all employees that do not have a bank account and a payment method active, but how do I pick up employees that have a bank account… -
Filter Criteria Changed in OTBI report when i run the schedule processIn OTBI Report ,few DFFs were missing from subject area and also the filter criteria changed to "Assignment Status Type is not equal to / is not in INACTIVE; INACTIVE_PA…Global Support Desk 24 views 2 comments 0 points Most recent by Global Support Desk Reporting and Analytics for HCM
-
OTBI Analysis Report is not giving Salary Information as expectedWhen we are running the OTBI report, the salary information for the terminated employees is not displaying as expected, and for a few employees, salary details are getti…Paul D 55 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to show the "Not Started" in graph even if its 0 count?Summary I have this graph of Document Status (Not Started, In Progress, Completed). I want to show the "Not Started" even if its 0 count. How can I do it? Content (pleas…
-
Using Case Statement on Performance Document StatusSummary: Hello everyone, I need help on my case statement. Can you please check if this is correct. There are errors when I use the statement. I want to only have 3 stat…
-
oracle query for Organization Card/social securityHi, I'm looking for a way to get this information from the following image in an Oracle Fusion queryjesus pacheco ortiz 1 view 0 comments 0 points Started by jesus pacheco ortiz Reporting and Analytics for HCM
-
USING SUBSTRING IN CASE STATEMENTSummary: Trying to extract Working Hours from ORC Requisition Internal Description using SUBSTRING in a CASE statement Content (please ensure you mask any confidential i…Richard Kemp-Eyre 21 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
OTBI learning Report issueSummary: I have imported Learning OTBI report from instance to another In Instance 1 the OTBI report for Learning is working fine Instance 2 OTBI is not fetching any dat…
-
No results using subject area "Workforce Management - Worker Assignment Real Time"Summary: Hello, I'm trying to create a learning report showing employee's division, branch, department. I get results I need except from the 3 criteria. I have both HR A…
-
Performance Issue - per_availability_details.Get_availability_detailsWe've developed a BI Publisher Report, but it's experiencing performance issues. When run ad-hoc, the report times out (Timeout Error), and when scheduled, it takes over…
-
Job requisition report not pulling all job requisitionsSummary: I created a job requisition report to show all open requisitions in a month. I need it to show any that are currently open plus those that were open and filled …
-
How to rearrange row in OTBI report?Summary: Hello, I need some help. I want to rearrange the performance tasks according to the order below per employee but every time I sort, the entire column sorts. Wor…
-
How to fetch content ID generated after running the Mass Create Printable Page Performance DocumentsWe are migrating the performance documents form an old fusion environment to a new one since we cannot load the item level ratings we are planning to load print of the e…
-
calculated measure by multiplying 2 columnsSummary:multipying revenue amount with ledger amount is giving incorrect results. Content (please ensure you mask any confidential information): project billing revenue …
-
Learning Management - Activity Completion DateSummary: Hi - I am trying to build an OTBI report that would show all activities in a course at the employee level and whether or not they have completed that activity o…
-
Subject Area for Question in Question LibrarySummary: Hi Experts, I am trying to look for OTBI subjects areas for reporting on question which are present in Question Library. Main focus of reporting would be time o…Saurabh Pratap Singh 152 views 9 comments 0 points Most recent by KatieH Reporting and Analytics for HCM -
Person Security Profile not Working in OTBISummary: We have created a Employee custom role and attached a person security profile to employee. Employee can only view his own record in UI. We have created an OTBI …Hassan Mohsin 12 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Add Date and Timestamp in OTBI Analysis NarrativeSummary: I did not see this anywhere on the forum, in case anyone else is interested, we preferred to add a timestamp here versus the Title "Started Time" option as this…
-
How to duplicate a page in the dashboard?Summary: Hello, how to duplicate a page in the dashboard? I want to copy a page in existing dashboard so I could have the same layout. Thanks! Content (please ensure you…
-
Ways to securely send OTBI reports through agents?Summary What are the ways to securely send OTBI reports through agents?Content I think this has been asked a few times in the past, but just wondering what are the ways …
-
Goals Subject Areas returning no resultswe have created a simple OTBI report using SA like "Goals Review" or "Development Goal Real Time" with only two columns 1. Person Number, 2. Development Goal Name. It is…RahulMore 23 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BIP or OBTI Auditing Users making changes to their own HCM/Payroll DataSummary: Does anyone have or know of any current reports that will give details on Oracle HCM users who have made data changes to their own Global HR/Global payroll info…
-
Additional Person Info - Historical Reporting in OTBISummary: I'm trying to write an analysis in OTBI that includes historical Additional Person Info Content (please ensure you mask any confidential information): The analy… -
Report on User Name Last Updated DateSummary: I'm looking for a report to tell me the last updated date / last updated by for the User Name, please Content (please ensure you mask any confidential informati…
-
OTBI filter - Two columns don't matchSummary: Is it possible to create a filter (maybe a new column to calculate?) to only provide results if two columns don't match? I can't imagine it's a common thing, bu…
-
Duplicate a page in Dashboard - OTBISummary: Content (required): Hi there How can I duplicate a page in an OTBI Dashboard? Thanks Bobby Version (include the version you are using, if applicable): 21C Code …