Reports
Discussion List
-
EPM Formula/Conditional Suppression in ReportHi, I want to create a formula/conditional suppression wherein whichever Period they have selected would grab and add all Actuals from that Period and prior closed month… -
User login details reportContent Hi Team, We have a requirement to see the list of users logged into the Fusion application on a specific day, in a format like the below sample: User Name | Logi…Arun Kumar Krishnan [AK] 653 views 3 comments 2 points Most recent by Naveen.yadav Reporting and Analytics for HCM -
Selection Process Internal vs External - OTBISummary: Hi Expert, I have a requirement to show no application to the respective phase name and with the filter criteria month, year, and candidate Selection process na… -
Prompt in report shows member name instead of alias nameIn Oracle Planning Cloud, we have "Reports" with prompts, when opened the prompt shows "Member name" instead of "Alias name", is there a place to set the property for wh…User_2025-03-10-22-57-31-218 111 views 10 comments 0 points Most recent by Patrick Northcraft Planning -
Duplicate lines of data for employee in Worker Assignment Real TimeSummary: I have developed an analysis export which brings all current assignment data for an employee based on the Worker Assignment Real Time subject area. However, the…Dan_Hinsley 22 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
We are taken the backup of BI report before cloning but now unable to edit the reportSummary: Hi Team, We are taken the backup of BI report before cloning but now unable to edit the report and I'm able to get below error ? PFA. Thanks, Ajay Content (plea…AjayKumar Maddipati 11 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Reporting: Active on a requisition within candidate pool reportingSummary: We have a candidate pool report utilising 'Recruiting Events Real Time' Subject Areas which lists all candidates in our Pools, their current state/phase, prefer… -
Need to edit the NewHireReport data model to include the SecurityFinal tableSummary: In the AssignmentChangeReport datamodel (EmploymentUpdateProcess), there is a table called "SecruityFinal". This table provides the following data (see below) o… -
Using Formulas to Reference a Grid in different Report in narrative reportingSummary: I created a book containing multiple reports. On the cover page/table of contents page, i would like to reference the period (eg. May 2024) for which the book i… -
Looking for query to fatch the specific security profileSummary: Content (required): Hi Expert, We are looking for a SQL query to get the list of roles that are attached with a specific security profile like a document securi… -
can we use the regexp_replace function in a xsl bi publisher template?I'm trying to use the regexp_replace function in my xsl template to replace special characters and I receive an error. Is the regexp_replace supported by the xsl templat… -
Report to get active staff as end of actual month vs their situation in the previous monthSummary: I want to create a BI Publisher report each month that allows me to track the situation of each employee if there is any changes between end of actual month vs …
-
ora_pay_transform_file_type_list is not provided. use max seq num from pay_file_detailsSummary: ora_pay_transform_file_type_list is not provided. use max seq num from pay_file_details This is fusion HCM extarct BIP report related issue, Can anyone please h…User_2025-07-18-07-07-18-338 3.3K views 6 comments 0 points Most recent by Stefan v. Glabbeek HCM Extract -
Line Chart Data Label Overlapping IssueSummary: I am reaching out regarding an issue I encountered while creating a line chart. The data labels for closely related data points consistently overlap, despite my… -
Dynamically update one dimension based on selection of anotherSo we have a requirement where the data sits at different intersection, for example All data in "Actuals" Scenario is in "Total Actuals" Plan Element and All data for "F… -
Can we change the Date format to Text in OTBISummary Can we change the Date format to Text in OTBIContent Hi I would like to know to know if we can use any of the functions in OTBI to change the date format to Text…User_2025-01-30-21-52-52-008 285 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is there a known limitation for HCM Extract Output generated in .txt format?Currently, we have an extract that makes use of the user entity, PER_EXT_SEC_ASSIGNMENT_BASIC_UE, and runs on system date; and the data model, globalReportsDataModel, to… -
RePorts: CurrentPOV not working in HeaderSummary: Content (please ensure you mask any confidential information): Hi All We have an issue where if we use CurrentPOV in header without a MemberAlias it does not re… -
BI report paramters not working in DasboardSummary I attached BI report to dashboard and created date paramter in dasboard prompt with same name as BI parameter.But not getting ouputContent Hi, I attached BI repo…User_6I33I 28 views 4 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Approval Path- Info is locked- Recruiting.Summary: Is there a way to see the approval flow on pending requisitions. Right now, only the person who submitted it is able to see where it is in the approval path, No… -
How to remove decimal value in BAR CHART - RTF Template - BIP Report?Decimal value is displayed in the Bar chart of RTF Template - BI Report. How to remove decimal values in the chart?SARAVANA KUMAR T-Oracle 11 views 0 comments 0 points Most recent by SARAVANA KUMAR T-Oracle BI Publisher Learning Center -
Date Range Parameter value should be defaulted to previous year in OTBI ReportHi Team/Raghavendra Raghunath-Oracle, We have created an OTBI report it's working fine. However in the Prompt parameter we wanted to default the filed values as below; S…Mahendra Y 52 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to edit and disable delivery option of Oracle HCM Fusion HCM Extract in 24BWe would like to disable the delivery option of HCM Extract and edit one of the Data group filter in 24B. As we do not have Advance edit option enable.Bindu Janoti-Oracle 91 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Identify Hire Dates that are any date in the Next WeekSummary: I have an OTBI report using subject area Workforce Management - Work Relationship Real Time. On the Advanced tab, I have already entered the prefix SET VARIABLE… -
How to see from front end or fetch data through query for schedule information of hcm extractSummary: How can we see from front end or fetch data through query for schedule information of hcm extract like the schedule date, frequency etc. -
Navigation flow for NRCS in EPBCSSummary: We are having reports and books in NRCS instance. We created a connection in EPBCS with NRCS and did navigation flow to run the reports and books in EPBCS. For …