OTBI
Discussion List
-
How to restrict OTBI report output based on employee assignments details for Line Managers loginSummary: Hi, I have created one OTBI report to view the details of PD but line managers are getting two rows for both the active assignments of employees .Ideally the li…Kamini Kaushik-Oracle 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to Remove Person number From Human Capital Management - Approval Notification Archive Real TimeSummary: In Subject area Human Capital Management - Approval Notification Archive Real Time, column Subject "Approval Notification Details"."Task Title" can we remove Pe…RakeshK 31 views 4 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
DoR DDF correlation table HDOR.DEI_INFORMATION_NUMBER2Summary: Hello experts I'm trying to query some Document of records for brazil taht have fixed DDFs SELECT HDOR.DEI_INFORMATION_NUMBER2 as "STATE" HDOR.DEI_INFORMATION_N…Pedro Teixeira 1 view 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
OTBI with Personal Payment Method DeeplinkSummary: Team, I am working on a Personal payment method OTBI analysis with Deeplink enabled. I am finding one issue like while I am selecting then it I select the assig…Mohan Murali 32 views 3 comments 0 points Most recent by Julian Challenger-Oracle Human Capital Management
-
What is the best way to show all employees for a specific element even if they do not have it?Summary: I need to build a report showing all employees, but needs to show a specific element if the employee has it, and leave a blank if they don't Content (required):…Mark Stoker 32 views 3 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
How to use MAX Date in OTBIContent Hi I'm getting multiple work relationship records, I would like to return only the latest work relationship record. How can use MAX function to select the latest…User_2025-02-07-19-03-14-525 2.7K views 8 comments 0 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM -
Expense report numbers have changedWe found that the expense report number have changed somewhere during the month July of 2021. Instead of 10 digits (starting with 00) I see now 12 digits, starting with …
-
Pie Chart Percent Display OverlapContent Hi - I need to display the percentage for each pie chart slice in an OTBI report for export to powerpoint, but some percentages overlap when displayed. Is there …Julia SRI International 65 views 2 comments 0 points Most recent by Ms_Oracle Reporting and Analytics for HCM
-
Workforce Learning - Learning Management Real TimeSummary: Can anyone please help me with the table names that is being used in this subject.we have requirement to convert the OTBi to BIP Reportminati_behera-Oracle 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
workforce management - worker assignment real time returning in correct dataSummary: We are maintain an OTBI analysis which fetches Core HR details adding Grade Step column is fetching incorrect details. PFA snippet for more details Please let m…Manoj Kumar S 31 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Placing a Report Job on HoldSummary: Content (required): I have a report in OTBI that is scheduled to run every Monday morning. I would like to place the job on hold for the next month (December) a…Annette M 21 views 1 comment 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
Is there a Standard report for JE detail that includes Posted by and Final Approver?Summary: Content (required): Auditors are requesting STANDARD Journal Detail report that includes the Posted By and Final Approver fields. Version (include the version y…User_2025-10-31-01-06-05-525 31 views 1 comment 0 points Most recent by Rohan Kamat General Ledger & Intercompany
-
Sample CSV file for Purging Learning recordsSummary: Content (required): Hi there, I am looking for a sample csv file for purging Learning records Is there any available? Thanks in advance. Bobby Here is the featu…Bobby Jourdan 21 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
How to associate an historical event State within a particular Phase in "Recruiting - Recruiting EveContent The requirement is to calculate totals based on Phase/State of historical events for auditing purposes. For example, in a "Job Application Status History" analys… -
Changing Ownership of Scheduled AgentsSummary: We recently had an employee leave the company who was the owner of the majority of our reports and scheduled agents. In an effort to safe time, is there a way t…User_2025-02-11-00-58-38-371 21 views 1 comment 0 points Most recent by Paidiparthi Ravindra Reporting and Analytics for HCM
-
If Springboard infolets for Purchasing page is empty for All buyers that may be missing assigning?Summary: Springboard infolets for Purchasing page is empty for All buyers, Client indicates that in the product presentations this feature are one of the greatest assets… -
Fiscal Year, quarter and Month in OTBI reporting as a parameter and also as a fields.Summary: We have a requirement to report Employee Details based on Fiscal Year, Fiscal Quarter and Fiscal Period. In the subject Area Workforce Management Assignment Eve…Venkateswaran Murali-Oracle 531 views 2 comments 1 point Most recent by Venkateswaran Murali-Oracle Reporting and Analytics for HCM