Reports
Discussion List
-
BI report - rejected by in Job RequisitionWe are building a report to check the rejected job requisitions and we can't find the field for who rejected the requisition. The field IRC_REQUISITIONS_VL.LAST_UPDATED_…Marta Martinho 11 views 3 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM -
Query to get assessment questionnaire responses for an employee from learn moduleSummary: Query to get assessment questionnaire responses for an employee from learn module Content (please ensure you mask any confidential information): Hello, I'm tryi…Manisha Rajupeta 451 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Courses Link table name for LMS reportFrom which table we can get the course link in bi reports. Can anyone help me with the table name. Thanks, Dara NagasaiDara Nagasai 1 view 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
What’s New in EPM Cloud Narrative Reporting and Reports Release 24.02What’s New in EPM Cloud Narrative Reporting and Reports Release 24.02 Please refer to the February 2024 What's New Guide to understand the new features included in EPM C…Dave Roberts_-Oracle 51 views 0 comments 0 points Most recent by Dave Roberts_-Oracle Narrative Reporting -
Audit of BIP Report ChangesSummary: Audit of BIP Report Changes Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there any available feature to track or audit …Parag Hiremath 51 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Can you sort rows through multiple grids in a management report oracle cloud?Hello, I created a report that is set to bottom levels of all hierarchies within the cube. This causes query limits errors when there is a large number of blocks. The re…
-
Succession Candidate readiness Counts are off in reportSummary: I am trying to get accurate counts of Active Plan candidates (active assignment and active on plan) and while I'm able to pull totals accurately, the candidate … -
Learning Specialist Not able to see employees dataSummary: We have built a custom OTBI report using the subject area - Workforce Learning - Learning Management real time , but when we run the report the Learning special…Veena P 172 views 4 comments 0 points Most recent by Saurabh Pratap Singh Reporting and Analytics for HCM
-
Pivot Table > Sorting Date in Ascending Order Not WorkingSummary: Pivot Table > Sorting Date in Ascending Order Not Working Content (please ensure you mask any confidential information): Hello, We want to display the time card…
-
Financial reporting logo formatting lost when export to excelSummary: Content (please ensure you mask any confidential information): Hi support It seems that this very old bug in FR is still happening where the logo is moved/reduc… -
SQL to pull Number of Days between two dates (one is a Parameter Date)?I'm currently using BIP Report. This sequel works on me if I'd like to use SYSDATE: TO_NUMBER(TRUNC(SYSDATE) - TO_DATE(TO_CHAR(SEN.SENIORITY_DATE, 'YYYY-MM-DD'),'YYYY-MM…
-
Need query to resignation approved employeesHi, I have a requirement to send emails to employees whose resignation is approved. So I want to use bursting to send emails to employees. Can anyone help me out with th…Dara Nagasai 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Payroll - Element Entries Real Time not giving any dataSummary Payroll - Element Entries Real Time not giving any dataContent i am trying to create a report pull the element entries for all the employee. but it is not giving…User_2025-02-05-02-11-29-794 49 views 5 comments 0 points Most recent by Ms_Oracle Reporting and Analytics for HCM -
Has anyone experienced their FRS reports not generating the same values as same report in Reports?Summary: We are noticing one of our reports that has multiple grids embedded within it is not returning the same values when generated via web studio vs reports. Wonderi…Casey Kempel 21 views 3 comments 0 points Most recent by Komala Reddy-Oracle Financial Consolidation and Close
-
FR: reporting prompts only display the NAME of the subvariable and not the VALUESummary: Content (please ensure you mask any confidential information): Hi all We have many report's prompt associated to Subvariables, but want when the Prompt is displ…
-
Start expanded vs not expanded in ReportsSummary: Is it possible to drill into a hierarchy on a report? Or have it set up to not start expanded, like in forms? Content (please ensure you mask any confidential i… -
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…Omran Zeaiter 291 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
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…THawkins_LGI 253 views 19 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Embedded report grids from Reference doclet disappearsI have a Word doclet that contains a reference doclet report grid embedded into it. The Word doclet stopped displaying the embedded report grid, I checked the "Inspect c…
-
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…Nicolas Vahman 281 views 4 comments 0 points Most recent by Prameesha Reporting and Analytics for HCM
-
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 …AjayKumar Maddipati 31 views 6 comments 0 points Most recent by AjayKumar Maddipati 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 91 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…
-
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…
-
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 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How do I fix the POV for financial report "books"Summary: Users are trying to run a book of financial reports but the POV differs for some of the reports Content (please ensure you mask any confidential information): U… -
How do we limit the selection in Run Time Prompt of any Dimension in HFR?Summary: I have created a Report & want to select Entity in RTP. But I want to limit only few entities to get selected by the users. Could you please suggest the limited…
-
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 61 views 1 comment 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle 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 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM