Reports
Discussion List
-
Formula for NOT Current Year ("Worker"."Employee Hire Date")Summary: OTBI report - Filtering on YEAR for field name "Worker"."Employee Hire Date" Content (required): I have an OTBI report where the data returned should be for emp… -
Extracting data using BIP Publisher Report for REST API Load (Creating Timecard)Team, We have a requirement to create bulk time entries for employees (Copying previous timecard and creating the same timecard for current week - Dates differs) and we …
-
Is there a report/subject area/table/view that pulls all role/data access auto-provisioning rules?Summary: I am in search of a way to pull in all of the active auto-provisioning role/data access rules (rule name, conditions, assignments (associated roles, associated …
-
Can we restrict otbi reports such that only manager can be able to see direct reportees?Summary: Manager should be able to see complete details of an employee who is reportee to him/her? Can we use any restrictions in otbi reports such that only manager can…Kurva Paramesh 13 views 2 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
How to find the difference between two date attributes in eText templateSummary: We need to find out the difference between two dates and add 1 to the result in eText template. Content (required): We need to find out the difference between t…Meenakshi K 1.2K views 6 comments 0 points Most recent by User_CTDSJ Reporting and Analytics for HCM
-
Query bursting combined with Union AllI prepared a report using more than one UNION ALL and I want to send it as a notification, for this I prepared bursting and used it from the FROM condition of the first …Cansel Karasoy 191 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Calculating Past Experience of employees in HCM BISummary Calculating Past Experience of employees in HCM BIContent Hi; I was trying to calculate the total past experience of the employee in BI with the below formula bu…User_2025-01-22-18-29-47-758 126 views 3 comments 0 points Most recent by Vishnupriya Reporting and Analytics for HCM -
Reporting on approval transaction commentsSummary Reporting on approval transaction commentsContent Is it possible to report on the comments submitted under Attachments and Comments section for approvals not yet…Emily Robinson 184 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BIP - Organization HierarchySummary: Hello, Does anyone tried creating report in BIP with organization hierarchy details? For example: Enterprise Division Business Unit Department Level 1 Departmen…
-
Query to get time card approver name and approved dateSummary: I need query to get time card approver name. Content (required): I need query to get time card approver name. Version (include the version you are using, if app…Swati U 2.1K views 4 comments 0 points Most recent by Durgadevi-Oracle Reporting and Analytics for HCM
-
New hires are not showing in SQL reportSummary: New hires are not showing in SQL report. We created report by using Data model. When we export the report, there are not some new hires in it. Content (required…
-
Report for Equal Pay Registration Certificate in IllinoisSummary: Has anyone built a report for the Equal Pay Registration Certificate now required in Illinois? Attached is the template we were provided, which is missing quite…Melissa Gettman 11 views 1 comment 0 points Most recent by Jeremy Miller-Oracle Payroll and Global Payroll Interface (GPI)
-
Custom report to see who is listed as Read Only AccessSummary: Hi, Our Audit team would like a security report that lists everyone we have setup for READ ONLY access under Manage Administrator Profile Options Content (requi…Darrin N 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Core HR Seeded report.Summary: Hi Expert, Does anyone one have core hr seeded report path, where I can see all seeded report. If possible, please share the document. Thank you! Content (requi…Mohammad Afghan 51 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Learning item access group -BIP table to fetch Person Number List details for Learning access groupSummary: I am working on one BIP report where I am fetching one column to learning access group members using Person Number List options. In which table the person numbe…Kamini Kaushik-Oracle 41 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM
-
Change of Owner in Catalog FoldersSummary: What are all the actions that trigger the change of ownership for folder, sub folder and reports under it? Please explain in what all cases "System Account" is …
-
Find and Replace PROD path reference in extractsSummary: Find and Replace PROD path reference in extracts Content (required): Hi Team, Greetings! We have multiple extracts with reference to Production path on SFTP or … -
How to export all pages on a dashboardHello, Is there any way we can export a full dashboard and it return the full table of results rather than just the rows shown on the dashboard page? Thanks, Stacey
-
Could please help me on to find FTE cloumn in OTBI subject areaSummary: Hi Team, We need FTE column in OTBI report, I have taken worker assignment real time but I can't find out FTE column. Any help me on . PFA. Content (required): …AjayKumar Maddipati 31 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to retrieve the OLD payroll frequency and NEW Payroll frequency in the BIPHi ALL, Kindly support me to resolve below issue: I have a requirement to retrieve the OLD payroll frequency and NEW payroll frequency in BI report. Following with other…RamkumarKadhiravan 21 views 2 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM -
SQL to retrieve fields for BI ReportSummary: Hi All Please share SQL query to fetch below details for generate bursting report. Thankyou, Ram Content (required): SQL to retrieve Employee Number, Employee N…RamkumarKadhiravan 71 views 8 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM
-
SQL for Environmental health and safetySummary: Team, Does anyone have the sample environmental health and safety BI report (SQL). Please share Content (required): SQL for Environmental health and safety SQL …
-
The user request exceeded the maximum query governing execution timeSummary: The user request exceeded the maximum query governing execution time Content (required): Hi Team, Greetings! We get error on OTBI report as 'The user request ex…Parag Hiremath 121 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Table name to get Element CategorySummary Table name to get Element CategoryContent Hi Team, Can someone help me with the table name to get the "Element Category", i was able to get this information inOT…User_2025-02-04-07-00-18-658 401 views 12 comments 0 points Most recent by Veerachari Reporting and Analytics for HCM
-
Absence category and absence types under this category query.I need a SQL query that returns information about the absence category and the absence types connected to this category. I would be grateful for the query you can share …Cansel Karasoy 314 views 11 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Sending Bursting pdf as an e-mail body instead of outputI have a notification work that I have prepared, the report returns table type employee data and absence detail.I can send this tabular report as a pdf output, but I wan…Cansel Karasoy 31 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
AS-OF-DATE on Prompt - CURRENT_DATE_REP_OTBI-Session DateSummary: I am using CURRENT_DATE_REP_OTBI in the calendar prompt # As of date . The date is is not defaulting correctly. The session date defaults to 01-Nov-2021. While …
-
Is there any table/way to find the tables used (data set details) in BIP reportSummary: Is there any table/way to find the tables used (data set details) in BIP report Content (required): Hi Team, Greetings! Is there any table/way to find the table…Parag Hiremath 923 views 16 comments 0 points Most recent by HarshithDarla Reporting and Analytics for HCM
-
Looking for a Workflow transactional Report where Self Approval is enabled.Hi Team, I'm Looking for a Workflow transactional Report where Self Approval is enabled. Either the report should let me know about on which workflow rule self approval …
-
Extract description of lookup in OTBISummary: Content (required): Hi everyone, we are having problems extracting the value of a dff configured for the JOB. Is it possible to extract the description of the r…Gerardo Peluso 1 view 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM