Reports
Discussion List
-
Add Custom Text to Workflow NotificationSummary: I would like to be able to add custom text to the workflow notifications that would show up conditionally - only when the approve/reject links are shown on the …Kyle Norris 43 views 1 comment 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM -
Analytics > Administration > Manage Sessions > Ability to Trace Sessions for BI Publisher ReportsSummary: Analytics > Administration > Manage Sessions > Ability to Trace Sessions for BI Publisher Reports Content (please ensure you mask any confidential information):…Bernard T 62 views 1 comment 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
Which table holds the value for 'Province of Employment' for Canada Employees ?Summary: Need the Table and column info for the 'Province of Employment' value to troubleshoot and fix card association issue. Content (please ensure you mask any confid…Priyabrata Prusty 81 views 3 comments 0 points Most recent by Priyabrata Prusty Reporting and Analytics for HCM
-
The tentative deprecation date for Oracle Financial Reporting in Cloud EPM has been updatedPlease note that the tentative deprecation date for Oracle Financial Reporting in Cloud EPM has been updated to sometime between mid-to-late CY2024 (subject to change, s… -
I need help with creating New Hires report with some Requsition & Assignment & Offer detailsHello, Could you please let me know what Subject Area/Tables I should use to build a report that shows basically the info on the offer screen under: My Client Groups > H…Ramy Atia 31 views 1 comment 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
Copy and Paste Grids Between Different ReportsSummary Is it possible to copy and past grids between reports?Content I have a number of grids built on the same data across various reports. Is it possible to copy and …
-
How does a matrix manager see the indirect reports for the person set up as matrixed to themSummary: I have set an employee up as having a matrix manager. I would expect the matrix manager to see this employee along with his/her direct/indirect reports in a hie…JoeNalbach 43 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI Report with manager details and Counts of Direct and Indirect ReporteesSummary: OTBI Report with manager details and Counts of Direct and Indirect Reportees Content (please ensure you mask any confidential information): We are able to get c…MadhuLekkala 61 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Could someone please inform me about the table where I can find information on deleted user roles?Summary: Could someone please inform me about the table where I can find information on deleted user roles? In the per_user_roles table, records are permanently removed …
-
Number of Direct Reports that are ManagersSummary Need to generate a report that shows, for a manager, which one of their direct reports is also a manager.Content * There is a requirement to get, for a manager, …Bradley Gray 58 views 23 comments 1 point Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
How to query the Effective Start and End dates of job on job profileSummary: How to query the Effective Start Date and Effective End Date of Job Name/Code added to a Job Profile in OTBI. Content (please ensure you mask any confidential i…Vis Perera 74 views 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM -
Report Path for Audit Reports PageSummary: Could someone please share the report path for the page below? I intend to generate a BIP report to monitor user role deletions and additions. Content (please e…TestUser35 11 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Hide attributes dimensions from member selectionSummary: The FCC administrator would like to hide the attribute dimensions so that it does not appear in the member selection dialog box. Content (required): The attribu… -
Query to extract the list of available Locations based on the Legal EntitySummary: Content (required): Hello experts, is it possible to build a SQL query to retrieve the list of applicable locations based on the legal entity? Thanks in advance…Valerio Curzi 807 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to Organize the BI Publisher reports and create Library and definitions inside HCM?We implemented Oracle HCM back in 2019, and since then we created a lot of BI Publisher reports across the modules. Those reports are very useful, however, the report na…Raed Ibrahim 11 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
need a payroll element costing reportSummary: Need to write a payroll element costing report that includes highlighted information from picture below Content (required): need a report that shows all the inf…Bernadette Dorris 161 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to create from and to date parameter without default and mandatory fileHow to create from and to date parameter without default and mandatory file in BI PublisherRitika.ray-Oracle 21 views 7 comments 0 points Most recent by MandeepGupta BI Publisher Learning Center
-
How to convert bip report out format into JSON format by using e-Text templateDear Experts, I need to convert Bip report out format into JSON format by using e-Text template. Please send me the e-Text template and how to use that template with XML…Ravindr-Oracle 502 views 1 comment 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM
-
how to add prompt of Start Accounting date and end accounting date in FRS reportHi, I am looking out for ways to pass a period range Prompt in FRS report based on which my columns will dynamically be fetched. However i can't seem to find the ways to…
-
How are calculations being made in the predefined Lease Accounting reports?Summary: Analysis of the reports at the functional level is currently complex being that there is not much information on the fields, formulas, and other details in the … -
Etext Report output is not coming correctly.Summary: Hi Everyone. I am trying to create a etext report in the HDL format, EDI(delimited type). When i view the report, instead of getting the output value, i am gett…ShawShankk 133 views 11 comments 1 point Most recent by Ankam Vasantha Reporting and Analytics for HCM
-
In which table I can find this column "Department" ?I'm creating a report with BI Publisher and I need the department column but I've searched several tables and can't find it. I've found the business units and legal empl…Hiba Ghoualmia 309 views 7 comments 0 points Most recent by Hiba Ghoualmia Reporting and Analytics for HCM -
AOR Areas of Responsibilities in OTBIContent Hi All, Can someone help, which Subject area I can find Assigned Areas of Responsibility details in OTBI? Thanks, VijayUser_2025-02-07-19-03-14-525 1.2K views 11 comments 0 points Most recent by Natalie A. Reporting and Analytics for HCM -
Freeze Rows in PBCS ReportingHi I am creating a report in PBCS and I need to Freeze the headers so when I scroll down you can still see them, is this possible?
-
Permission - BI ReportSummary: We need an audit report with information about which user made the changes to the report's permissions in analytics.Mayara Fulquim 21 views 1 comment 2 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Report Prompt Not Appearing in BookSummary: Content (please ensure you mask any confidential information): I have a report that has a prompt for entity/subsidiary. However, when I try to add it to a book,… -
Report to find employees without any presentative (AoR HRBP)Summary: Hi, I'd like to create a report to find if any employees haven't been assigned to any HR Business Partner with an AoR. Do you know if this is feasible and how t…Alberto Americi 61 views 5 comments 0 points Most recent by Alberto Americi Reporting and Analytics for HCM
-
Need query to get who submitted resignation in last 24hourswe have a requirement to get the report of employees who submitted resignation. Can anyone share me the query to get employees data or atleast how can we get data of emp…Dara Nagasai 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to fetch PREVIOUS Grade and Grade Step using BIP?I need to pull the latest previous Grade/Grade Step in a single row because we don't need to back track all the changes on their Grade/Grade Step. How to construct the B…