OTBI
Discussion List
-
Is there a document for creating a report for Oracle Digital AssistantSummary: We have received a requirement from one of our clients and they want to create a report for ODA Content (required): Basic requirements from the report - What qu…Avik Roy Chowdhury 52 views 3 comments 2 points Most recent by Dr Surlina Yin-Oracle Digital Assistant -
Hi! How can I run a query to pull data within 90 days from the effective date?Summary: I need to create a query to pull data less than 90 days of effective date to use as agent and decrease the number of lines in the reporting. Content (required):… -
How to get location for position in OTBISummary: How to get location for position in OTBI Content (required): I tried using location name column under Position folder from position real time subject area but i…Swati U 160 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
we have head count nearly 9000 employees and coming to this report only showing 5700 plus employeesSummary: Hi team, we have head count nearly 9000 employees and coming to this report only showing 5700 plus employees may i know how to check the issue. person real time…AjayKumar Maddipati 51 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Not able to find column as Pending changes in Position subject areaSummary: Not able to find column as Pending changes in Position subject area Content (required): In manage position, we have "Pending Changes" column. see attached. Does…Swati U 41 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can I calculate Absence Sickness for Employees for 4 absences of 3 days or more?Summary: I need to produce a report for employees that have had more than 4 sickness absences of 3 days or more within a rolling 12 month period. I have managed to creat… -
Logical SQL querySummary: Content (required): I am trying to join the candidate person number to their employee person number to get their days of service since I need this data by recru…Riti Malhotra 41 views 1 comment 0 points Most recent by Riti Malhotra Reporting and Analytics for HCM
-
Is there a way to extract the Manage Privileges details?Every oracle maintenance we are manually checking the Manage Privileges (OBIEE > Administration > Security) if still intact. Are there any way to extract all the details…
-
Questionnaire Score - 360 FeedbackSummary: Hello everyone, Does anyone know how to fetch Questionnaire Score in a performance document using OTBI? What is the subject area and column folder for this? You…Hazel De Castro 61 views 15 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
Deep Links in narrative textSummary: Content (required): Hi, I would like to insert a deep link inside an alert with narrative text. For example: https...fscmUI/faces/deeplink?objType=DOCUMENT_RECO…Alberto Americi 71 views 12 comments 0 points Most recent by Alberto Americi Reporting and Analytics for HCM
-
Restrict Participation in Another Plan Fast FormulaSummary: Content (required): Hello everyone, I'm currently trying to create a Fast Formula that will restrict population's eligibility for Compensation Plan B if they ar…Maria Xydopoulou 31 views 0 comments 0 points Started by Maria Xydopoulou Reporting and Analytics for HCM -
Created Eff for Extra internal info in candidate application details section in a requisition,Summary: I have created a eff under person extra info it is BI enabled . Content (required): I have run the ESS Job Import Oracle Fusion data extension for transaction B…Rajib_Samanta 183 views 4 comments 0 points Most recent by Rajib_Samanta Reporting and Analytics for HCM -
Checklist QuestionnaireSummary Provides the details of the questionnaire assigned to the worker, questions and responsesContent You can report on the questionnaire questions and responses from…Raghavendra Raghunath-Oracle 857 views 13 comments 5 points Most recent by Shweta Reporting and Analytics for HCM -
Does anyone know how to prevent BI Folder being accidently moved?Summary: Any strategy to prevent the BI folder structure from being accidently manipulated. When a folder is accidently moved, the reports that use a BI Publisher data m…
-
Is the performance goal section possible to pull in OTBI?Summary: I was able to pull the overall summary rating and rating from the competency section which is the behavior office (refer to the screenshot) however, I cannot fi…Christian Suarez 32 views 3 comments 0 points Most recent by Christian Suarez Reporting and Analytics for HCM -
OAC vs OTBI best for reporting ?Summary Soliciting comments and feedback as to when OTBI is best for reporting vs. Oracle Analytics CloudContent Hello Forum: I'm looking for feedback when OTBI might be… -
Unable to Join Multiple Subject AreasSummary: Unable to join "Workforce Management - Absence Real Time" Subject Area with "Workforce Management - Worker Assignment Real Time" Content (required): Our require…Jyothi Gorantla 31 views 4 comments 0 points Most recent by Jyothi Gorantla Reporting and Analytics for HCM
-
Reports for Goals Completed in Plan YearSummary: I'm looking for the best way to report on all goals completed based upon the plan year. I've attempted to use the 'Goal Status Overview Real Time' subject area.…Lauren K. 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Recruiter ScorecardSummary: Content (required): Has anyone created a recruiter scorecard before? How do you deal with requisition metrics if there was recruiter turnover and the new recrui…Riti Malhotra 31 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
'Performance Document Rating Distribution' report not runningSummary: Hi Peers, I'm trying to make use of the seeded report 'Performance Document Rating Distribution'. It is not running whereas other seeded reports (e.g. 'Performa…S Shree 51 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Can we define hierarchies in OTBI reportsDear , I have a requirement to do hierarchies in OTBI report, it is possible in otbi report? For example if i am login and open report its shows only my and under my emp…Mirza_Adeel 51 views 28 comments 0 points Most recent by Mirza_Adeel Reporting and Analytics for HCM -
EEO Reporting for Federal, State and LocalHi all, Is there any document which tells us more about "Submit EEO-4 State and Local Government Report for US". Thanks, Sathish
-
Trying to create a simple analysis or report to view the performance document questionnaire questionSummary I am trying to create a simple analysis via OTBI to view the performance document questionnaire questions, but it will not pull up 2019 performance documents whe…Andy Rayburn 67 views 11 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM -
Where can I find "Job Definitions" for ESS jobs?Summary: I'm looking for a list of ess job definition names such as: 'JobDefinition://oracle/apps/ess/hcm/users/SyncRolesJob' Content (required): The end goal is to crea… -
OTBI: Questionnaire ScoreSummary: Trying to pull the overall score from a questionnaire tied to performance document Content (required): Hello all, I'm trying to build a report in OTBI where I c…Hazel De Castro 41 views 9 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
OTBI Report: Matrix manager as participantSummary: Hello, Has anyone created an OTBI report regarding matrix manager as participant: overview for HR for which performance documents a matrix manager/stakeholder i…Hazel De Castro 31 views 2 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
Last_updated_by column is showing user name not full name in OTBI reportSummary: Last_updated_by column is showing user name not full name in OTBI report Content (required): Does anyone know how to get full name of the person in last updated…
-
Educational Major meaning in OTBISummary Only code is available in Person ProfileContent Hello Everyone!I need your help again. We are building and Educational report and the Major information a code ("…Alvaro Couto 31 views 5 comments 1 point Most recent by User_2025-03-07-05-33-11-638 Reporting and Analytics for HCM -
HR Action Original creation dateSummary Report on HR Action original creation dateContent Hello, Has anyone written a report of HR Actions history that includes original action entry (creation) date? I…User_2025-02-04-15-06-22-759 81 views 5 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM