Reports
Discussion List
-
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 835 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 511 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 131 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 367 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 62 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… -
Query Original value of Transfer orderHi, We're trying to query the original value of a Transfer order. So it should be the UNIT_COST_AVERAGE value at the moment of creation of the transferorder line. Is the…MennovD 21 views 3 comments 0 points Most recent by Venkat Jagan Pakala-Support-Oracle Supply Chain Financial Orchestration
-
Mutiple conditions applied at the same time in conditional formatSummary: I am trying to use color code for one column, where two conditions need to apply for the conditional format, meaning that both conditions have to be met at the …JohanneAM 21 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
HCM Infolet Tab unavailableSummary The HCM Infolet tab is missing from the pageContent Hi, I am having trouble in adding an infolet to the HCM infolet tab. The Service Infolet tab is present but I…Ian Rumble 205 views 14 comments 0 points Most recent by SUBHRASISH KANTHA Reporting and Analytics for HCM -
Comments from "Data Forms" not appearing in "Management Report"Summary: We migrated to OCI 2 months ago and we noticed a strange behaviour with comments on forms. When comments are entered in a data form, they only intermittently ap…
-
Created new Measure with conditions incorrect result, Workforce Management - Workforce Assignment RTSummary: Hello all, I have created a new measure - Count of Female Managers - FILTER("Worker Assignment"."Assignment Count" USING ((DESCRIPTOR_IDOF("Workforce Management…Ian.Gooderham 11 views 2 comments 0 points Most recent by Ian.Gooderham Reporting and Analytics for HCM
-
can't import MS word file into reports in fccs(only files of type .des are supported)Summary: Cannot add TOC to the book we created from reports since we cannot add a word file getting error 'only files of type .des are supported' Content (please ensure …Sanjana Ravihara 3 views 1 comment 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
List of standards reports and infolets in Oracle HCMHello, Is there a list of standard infolets and reports in Oracle HCM that companies can use please ? Thank youHiba Ghoualmia 342 views 4 comments 0 points Most recent by Hiba Ghoualmia Reporting and Analytics for HCM
-
Conditional Formatting in OTBI AnaylsisSummary Conditional Formatting in OTBI AnaylsisContent Hello, I am using conditional formatting to show when a field is NULL by changing the color of the field box. I ha…Shanna Oppenheim 58 views 7 comments 0 points Most recent by Ivony Ann Paula Salango Reporting and Analytics for HCM -
Passing parameters to a Report Writer scriptSummary: I'm trying to create a universal data extraction process that will utilize Report Writer. The idea is to have a standard extract layout (placement of dimensions…
-
Is there any way to get all BI folder level permission details via report?Hi Team, I have a requirement to fetch details of folder level permissions set on each folder in BI catalog. I see different roles/users have different level of access o…Narula Shray 471 views 5 comments 0 points Most recent by Narula Shray Reporting and Analytics for HCM -
Request to provide the PVO and VO attribute name corresponding to the Fusion Table and ColumnHi Team, I need the column "Newly Separated Veteran Discharge Date" from to OTBI to FAW. I am trying to achieve it by Data Augmentation route by extending dimension. The…