Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
How to report on how long a candidate has been in a particular phase and stateSummary: I would like to report on the length of time that candidates remains in each phase and related state. Content (required): A report that shows how long candidate… -
BI Report Access Issue - User Unable to Open and Access Report.Hello Community, I'm facing an issue with a BI Publisher HCM user information report. A specific user is unable to open and access the report, and I'm hoping someone can… -
Is there any way to create bulk users and assign them bulk roles. Also any limitations involved?Summary: Is there any way to create bulk users and assign them bulk roles. Also any limitations involved? Content (required): Is there any way to create bulk users and a… -
Combine Two or more subject areasSummary: I tried to add a new subject area to my report - all I need from the below subject area is the Employees Name which is not in the first subject area for Payroll… -
Top Of Stack Assignment Records - in OTBISummary Top of Stack Assignment Records - in OTBIContent Hello, How do you determine the "top of stack" assignment record? That is, the assignment record that is current…
-
Check Digits field in Payroll - Personal Payment Details Real Time subject areaSummary: The Check Digits field cannot seem to be found in the Payroll - Personal Payment Details Real Time subject area. Content (required): The Check Digits field cann…
-
Results to be displayed vertically instead of horizontallySummary: Whenever I create a new OTBI Analysis it displays horizontally Content (please ensure you mask any confidential information): How do I change this to show verti…
-
The Requirement is to get the Approval history for the Job Offer approvalSummary Approval status and the approval date with the respect to the approver for a job Offer in BIP ReportContent Requirement is to fetch the below for Candidates Job …
-
XML Publisher/BI Publisher make text bold in XDOFX IF condictionSummary: Content (required): Hi I have this field COMPONENT_NAME from my data model. I've created a table wizard with a repeating group for all the values in COMPONENT_N…
-
OTBI-ORC report issue on filter of candidate job application dateSummary: HI Team, when we apply the filter of candidate job application date report running long time without result but when we remove the filter on date it takes only … -
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…
-
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…
-
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… -
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…
-
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?…
-
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…
-
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
-
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 …
-
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…
-
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… -
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 … -
where to find "when is the employee start date" from offer letter in BISummary We need to report "start date" from offer letterContent Hello We have a requirement to include the "When is the employee start date" [hire date] from the offer l…
-
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…
-
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…