OTBI
Discussion List
-
Chart of Accounts Tree Report for segmentSummary: Chart of Accounts Tree Report Content (required): User would like to view Chart of accounts Tree for each segment and download in excel. Do we have any seeded r… -
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 -
Accounts/Transactions That Should Not Be Carried Forward:Purchase Order Balance by Control BudgetSummary: Can't find the following report "Purchase Order Balance by Control Budget report" Content (required): Documentation 'Using Financials for the Public Sector' rel… -
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 -
Payables Trial Balance OTBISummary: Payables Trial Balance OTBI Content (required): How to create Payables Trial Balance from OTBI? How do I get the as at date? How do I get the Original Amount an…CraigX 41 views 1 comment 0 points Most recent by Nagaraju-Oracle Payables, Payments & Cash Management -
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 202 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 883 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 31 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 -
Expense mileage reportDear ALL is there any report by oracle for the expense where it give a warning for the mileage when it will reach a limit so the report will give the name of each user h… -
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 -
expense rule reportDear all kindly help we need a special report where if an expense requested exceed the rule and submit with a warning the report will divide the amount exceeded by the n…