OTBI
Discussion List
-
Not able get information in "Workforce Succession Management - Talent Pools Real Time" subject areaSummary Not able get information in "Workforce Succession Management - Talent Pools Real Time" subject areaContent Hi Expert, Not able get information in "Workforce Succ…User_2025-02-05-01-04-36-989 40 views 4 comments 0 points Most recent by Riyaz Ali-Oracle Reporting and Analytics for HCM -
Drill down in OTBI Dashboard does not work correctlySummary: Drill down in OTBI Dashboard does not work correctly Content (please ensure you mask any confidential information): Hi, we created a Dashboard based on a OTBI R…Barile Alberto 38 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Learning Management replaced by the Learning Record subject areaSummary: Can't find mappings for the new Subject Area Content (required): Goodmorning, in reference to "APRIL MAINTENANCE PACK FOR 21A" document which states: "Be aware … -
HR own position data not appearing for HR rolesSummary: Position Report is showing positions to the HR teams but its not showing their data Content (please ensure you mask any confidential information): I have a posi… -
Report to trace the elements costed from Journal entries along with transaction numberSummary: Report to trace the elements costed from Journal entries along with transaction number Content (required): Hi Team, Greetings! Once the entire payroll cycle is …Parag Hiremath 29 views 3 comments 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP -
How can we add Date Prompt to DB prompt without using column from Subject areasSummary: We need to add a Dashboard prompt for Start Date and End Date. These two fields are just a Date parameter. We dont want to use any OTBI analysis column. How can…Abhishek Jois 34 views 6 comments 0 points Most recent by Abhishek Jois Reporting and Analytics for HCM
-
what does below hint mean?Summary: SET VARIABLE OBIS_ORACLEDB_HINTS_FOR_TOP_SELECT='OPT_PARAM(''_push_join_predicate'',''false'') OPT_PARAM(''_complex_view_merging'',''false'') GATHER_PLAN_STATIS…Pritha 8 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
SQL/OTBI query to get the Organization Payment Method and Payment sourcesSummary: SQL/OTBI query to get the Organization Payment Method and Payment sources Content (please ensure you mask any confidential information): We are looking a report…Visu 883 views 5 comments 0 points Most recent by GajavalliKoteswararao Reporting and Analytics for HCM
-
Report on Parent Position's Current Incumbent when Position is vacantContent We need a way to report on the parent position's current incumbent when the position itself is vacant. The report that we created shows the incumbent name for bo…Joanne Chung 484 views 13 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Dashboard Reverted to Old UISummary: Hi team, We have a dashboard that has reverted to an older UI in both Test and Production environments. However, the same dashboard in DEV looks fine and retain…Josel Pleyto 113 views 3 comments 0 points Most recent by Josel Pleyto Reporting and Analytics for HCM
-
Birthday reportSummary Birthday report worked exampleContent Hi there I have a requirement to create a birthday report, that can run two weeks before the employee birthday month. This …User_2025-02-04-15-07-59-505 476 views 22 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to extract person images in .jpg format from Oracle HCM Cloud?Content I have a requirement to extract the person images from the Oracle HCM Cloud in the .jpg format. Please can anyone guide on this. -
BIP Report or Dashboard for Data at Security Console with RolesHi Team, I am trying to create a report for the below columns using either Subject Area or SQL Query. Trying to mimic the page of the Security Console as well as include…Swapnil Kashid 55 views 6 comments 0 points Most recent by Iann hick Reporting and Analytics for HCM -
Historical report on positions held by active and inactive employee within a date rangeSummary: Looking for a historical report on positions held by active and inactive employee within a date range Content (please ensure you mask any confidential informati…M.Naing 10 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Matrix manager dimension in worker assignment real time subject areaHello Team, I have used attributes in matrix manager dimension of "Workforce Management - Worker Assignment Real Time" subject area to get all direct and indirect report…VMahesh 41 views 6 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Talent Review Rating HistoryHello, I need to pull a historical record of Talent Review ratings. I know it's possible to pull Performance Document rating history, but I'm specifically being asked fo…Nick Dorfner 59 views 5 comments 0 points Most recent by Nick Dorfner Reporting and Analytics for HCM -
Dashboard on Development Area: hrr_tmpl_metric_configSummary: Goodmorning, we're fancing a problema with the Talent Review Matrix in the Dashboard Standard The matrix is empty: analyzing the query from the log, we've seen …AM HRE 13 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
Female turnover rates of DashboardI'd like to ask that if I select the Female as the Gender, how is the female turnover rates calculated? Is the denominator of the ratio in relation to all employees or o…Chen, Reyna 27 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Time spent per approver in workflow approvalsSummary: We have a requirement to report out how long a specific workflow proves (Approve Job Requisition) remained with each approver within the workflow. Is there a re…Audrea Miller 15 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to Remove Duplicate Rows from Pivot table in OTBISummary: In excel - once you add the data to the row it makes it one to one - in OTBI how would I ensure there are no duplicated rows of data? Content (please ensure you…THawkins_LGI 118 views 10 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Access to Reports and Analytics section - Roles and privileges requiredSummary: Hi All, We had the requirement to build a custom data role which will give the user the access to Reports and Analytics work area and role should provide access…Sreeram V 5.5K views 10 comments 0 points Most recent by Jose Aguilera Reporting and Analytics for HCM
-
Scheduling FTP report - How to schedule multiple reports with one job?Summary: Our purpose is to launch only one job for multiple reports Content (please ensure you mask any confidential information): Hello experts, We have a requirement t…Giuseppe Casalino 16 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
Report for Missing TimecardsSummary Employees without time card associationContent Hi All, We have a requirement to identify and report those employees that are missing time card association. I am …Sowdha Murugan 310 views 3 comments 0 points Most recent by Pennie Spies Reporting and Analytics for HCM -
Help in Query to get Variable Rate for a Benefit of an EmployeeSummary: Hello, Customer Connect! I am in need of developing to get these scenario: If the employee John is enrolled in the Benefit A with the option B, it have a rate v… -
Impact Assessment of Redwood on the Core HR reports and dashboardsHello experts, we are now planning to implement Redwood for Core HR. Can you advise what we should watch out in the Reporting side? Like Changes in the Subject Areas, or…Maria Cristina L. San Jose 36 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Cumulative Salary ReportSummary: Financial report of cumulative salaries per reporting period Content (please ensure you mask any confidential information): Hi experts I have a request to provi…
-
OTBI Report - Need Query Transaction Console Approver Name for Job Requisition & Job OfferSummary: Need Query Transaction Console Approver Name for Job Requisition & Job Offer i have tried this query select htce.object_name, htce.task_id task_id_hdr, htce.con…Herman Fersendy 29 views 0 comments 0 points Started by Herman Fersendy Reporting and Analytics for HCM
-
Report on Duplicate Contacts in BenefitsSummary: I'm looking to see if anyone has come up with a clean way to report on duplicate contacts in Benefits. I have read a few other posts about this issue, so I know…Jessica D 18 views 2 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM