Category 81
Discussion List
-
How to make a totals columnSummary: Hi, I am trying to have a column that totals the values for a deduction at a Cost Center level. However, in my report, i continue to have repeating rows per Cos…Darrin N 23 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
where can i locate HR rep emailSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Adam Calvert-Oracle 3 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How do I pull the exact same timecard data that appears on the Oracle Team Time Cards screen?Summary: I need to create a data model that pulls the exact same data that appears on the Team Time Cards screen. We have OTBI reports that use the "Workforce Management…BeachDreamer 88 views 1 comment 0 points Most recent by Mohamed Mahrir Reporting and Analytics for HCM -
How to report on days since assignment status changeSummary: Hello! I am looking to report on days since Leave. We track leaves using the Assignment Status field, so I am looking to report on days since assignment status …
-
Any report that can show all quickpays that do not have a prepayment?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
"SQL or ORA exceptions caused due to invalid sql" Error MessageSummary: "SQL or ORA exceptions caused due to invalid sql" Error Message Content (please ensure you mask any confidential information): Hi, we built a report based on th…
-
Candidate’s application Question code in OTBI or data moduleI am looking to build a report that has the candidate’s application questions and answers and I need the question code on it for analytic purposes. I can build an OTBI b…Chris Pomager-27736 34 views 7 comments 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM
-
Sorting OTBI Report Worker Assignment Event Real Time Subject AreaSummary: I am struggling to sort my OTBI reports by more than one column, I am able to sort by Person Number OR start date but not Person Number then Start Date. It seem…
-
OTBI Report - Workforce Management - Worker Assignment Real TimeHello anyone, can we fetch Inactive - Payroll Eligible employees in OTBI using Workforce Management - Worker Assignment Real Time also their Annualized Salary Real Time?…Hazel De Castro 52 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
A comparison is being carried out between non-compatible types DATE and INTEGER. (HY000)Summary: I have an OTBI report using the Payroll Balances Real Time subject area. The below formula does not return any errors however when running the report I'm gettin…JHaden3 14 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Manager Hierarchy starting with CEOSummary: We are looking to get the manager hierarchy with CEO as level 1 of the organization. The Flattened Hierarchy table (PER_MANAGER_HRCHY_DN) has data with manager …User_2025-03-07-06-12-02-972 153 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Generate Check Payment statusSummary: We have Gnerate Check Payment Status as "Void" or "Paid and not Reconciled". Need to know in which table/OTBI suject area holds this exact value. Content (requi…
-
Any Functional or Technical Design document for Seeded ORC DashboardAs we can see the seeded Dashboard for ORC - Recruit to Hire. But do we have any technical or Functional document available to see the logic (calculations) used in each …Venkatesh S S 54 views 1 comment 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
How to Get Flow Submission Date/Creation Date in OTBI ReportHow to Get Flow Submission Date/Creation Date in OTBI Report. I am using payroll Run Result Real Time Business Area. Scenario: Employee Resigned in the month of Sept2023…Jithindev 33 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
In what particular subject area can Date of Fill, Time to fill and Time to Hire be found?I'd like to pull the following columns within the Recruiting Subject Areas: Date of Fill - Returns the date/time when the requisition was most recently filled. Time to F…Welsey 12 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Check Working Day QuerySummary: Dear All, I have a requirement to check if a specific date is a working day for the employee or an off day. So basically I need a query with a parameter called … -
when trying to edit a report getting error: Error Codes: OAMP2OPY:U9KP7Q94Unable to run or edit a report getting error
-
Unable to find 'Activity Attempt ID ' In OLC ModuleProblem Description We have requirement to fetch the column 'Activity Attempt ID' in OLC module basically Activity Attempt ID is a part of activity learning item but bac…AbhishekLahoti 12 views 1 comment 0 points Most recent by Jeff Thomas-Support-Oracle Reporting and Analytics for HCM
-
No results for some Facts-Candidate Tracking Activity such as number of applies, number of submits.Summary: Running a basic query against Recruiting - Candidate Tracking Real Time subject area. Number of successful submits does display, however Number of Applies, Numb…Melody Herbert 22 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Is there a report that can show user accesses to a specific Oracle Cloud app (Learning)?Summary: Request has been raised by business stakeholders who want to show usage of the new Learning platform. We can report on learning enrolments but this does not sho… -
Need help finding field in OTBI reportSummary: I have everything done on a custom OTBI report out of Performance Task Status Real Time except I need to pull the "Step" as shown in my image below. I cannot fi…Aaron Reynolds 21 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM -
Subject text update of standard notificationSummary: Subject of standard notification update Content (please ensure you mask any confidential information): Hello experts, does anyone know how to change the subject…
-
Need to Add board members in system and Pay Quarterly onceSummary: My requirement is to add Board members in System who are not actually employees and i want to pay them only Quarterly once. what is the Best way to achieve this…Laxman Doppalapudi 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Data Not fetching when joining cross subject areas with a DFF attributeSummary: We have encountered an issue while join two cross subject areas. Workforce Management - Worker Assignment Real Time and Workforce Performance - Performance Rati…Atul#620 14 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Employee hierarchy under a manager - need help passing manager person number as a promptSummary: I am writing a report to show all reports (direct or indirect) under a manager. I am getting the list by hard coding the manager ee# in my OTBI report. Since it…Anita Modi 14 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How do we update default expense account information for a person in Fusion HCM in Responsive UIPlease point to any screenshots/ links/documentation as i could not find any place which shows default expense account and position for employees.Srihari Manian 6 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
We updated our integration URLs with workers api but not workingSummary: We have rebuild our integration URLs with Worker API but when we are testing getting error like: "Request parameter expand with value workRelationships.assignme…mohityagyik 3 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How is Audit Table of HCM different from events captured in hrc_evt_source_objectsSummary: How is Audit Table of HCM different from events captured in hrc_evt_source_objects and which one should be used when Content (please ensure you mask any confide…Amod Kulkarni 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How do I find out the end date used for a scheduled process that has already endedSummary: We are trying to find out the end date used when a process was scheduled that is already in "finished" status. One of our ESS jobs has stopped running and we wa…Jefferson Yuliat 44 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Hierarchy Report - Top to bottomHi, Is there any way of reporting on the hierarchy from the top to the bottom? In OTBI there is this 'Parent Manager' field that is ordered bottom up. Is there any way o…