Reports
Discussion List
-
OTBI > Ability to get the work schedule assigned to Employee in reportContent Hello All, I will appreciate your support in the following issue: Do you have an idea if possible to get the work schedule assigned to employee in OTBI or via SQ… -
Table to pull the Highest Education Level in BIPSummary: Need to determine the table that retrieves the Highest Education Level under Person details Content (required): Version (include the version you are using, if a…RenzelkeithCoquia 841 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Audit log or report for configuration changes to the systemSummary: Is there a report or change log that can be obtained from system on application configuration changes ? Does anyone know of an audit log or report for configura…MilanMohanty 761 views 4 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Query to get statement of earningsSummary: Can someone share query to get all the balances on statement of earnings screen along with its element and values. I wrote a where I am getting the expected val…Jaeyshree Kumaran Kalpana 543 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Report for Performance DocumentSummary: Hi Folks, I would like to access a report that will display any 'transferred' performance documents within the Performance System. We would also like to filter …Sowmiya Velusamy 41 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Work Schedules for non-primary assignments in Person Real Time Subject AreaSummary: I'm trying to report on the work schedules for employees with multiple assignments. However the OTBI Person Real Time Subject Area / Person Schedule Assignment …Richard Kemp-Eyre 61 views 2 comments 0 points Most recent by Richard Kemp-Eyre Reporting and Analytics for HCM -
Oracle Standard Reports - Who to ContactContent Hi all - who do we contact about making an adjustment on the Oracle delivered standard reports? Our team was looking at the Line Manager Dashboard (Shared Folder…Prudence K 88 views 11 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to obtain Source System ID for absence entriesSummary: Content (required): I have a requirement to use HDL to delete and then re-submit a large quantity of annual leave absence entries. I have an HDL file that I can… -
Getting error when person extra info flexfield is pulled in OTBI reportSummary: Getting error when person extra info flexfield is pulled in OTBI report Content (required): I am getting following error when I dragged and dropped one of the p…Swati U 22 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Report Prompt in Smart ViewSummary: When running a report from the Reports module in Smart View, only the default value for the prompt is available and users cannot change it. The Choice List for … -
Customizing "Run Third-Party Payment Register"We have a requirement to add Person Number to existing output of seeded Run Third-Party Payment Register. Challenge is that we couldn't see the HCM Extract being run on … -
Query to find All grade Rate values with Grade codeSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Sowmiya Velusamy 3.1K views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Failing to retrieve data from presentation layer when trying to export BIP folderSummary: Our team is using the VBS pipeline to export BIP reports from the dev region to the sat region. Everything was working correctly and then it stopped working on …User_2025-03-07-05-28-28-079 42 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Change Period/Scenario/Year in PCMCS QuerySummary: Need help on automatically changing the Period/Scenario/Year in PCMCS Query. Content (required): Hi Friends. We have a script to calculate markup which runs a q…Amit Agarwal-158816 41 views 7 comments 0 points Most recent by Amith Kumar Madisetty Profitability and Cost Management -
Project Manager viewing other ProjectsSummary: Hello, Is there a seeded role in Oracle that allows a Project Manager to view the Projects of his direct reports in the application as well as through reporting…
-
Learning ProgressContent we are trying to mimic the reporting for learning on the front end that shows progress (1/5) for the specialization or course but I can't find this field. see sc…Riti Malhotra 50 views 3 comments 1 point Most recent by Lanette Frank-Oracle Reporting and Analytics for HCM -
Does anyone how to saved search in BIP parameter?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Hazel De Castro 31 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
How to put the information into one row and limit the duplications?Hi All, I've been working on building a report to show the employee's personal information (address, contact number etc) and include their emergency contact information … -
Manage Seniority Dates subject areaSummary Need to know the subject area for reporting the dates in the Manage Seniority Dates action menuContent I'm looking for the subject area that can be used to repor…User_2025-01-29-22-47-27-383 136 views 18 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM -
How to create Report Filter that only provides results based upon Current DateSummary: I have a BI report with I need to retrieve all transaction created on current date Content (required): Report is BI Publisher Report based upon Receivables Tran…LE 31 views 7 comments 0 points Most recent by Ramneek Grover-Oracle Reporting and Analytics for ERP -
RTF Template - To Display Total Amount in last row of the pageSummary: Hi All, We have requirement to display Total Amount only in the last row of the last page, even if the report data ends middle of the page Total should be displ…User_T8NOH 572 views 1 comment 0 points Most recent by Ramneek Grover-Oracle Reporting and Analytics for ERP -
Union for 2 reportsSummary: How can I combine the output of 2 reports into one output Content (required): I have two reports, both using the same 2 Subject Areas (Workforce Management - Wo…Joe Dorrian 32 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Usage of BI System RoleSummary: Usage of BI System Role Content (required): Hi Team, We would like to know the usage of BI System Role. Please share your knowledge on the same. Version (includ…Vasanthakumar Ravi 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Master Detail Web ReportHi All Trying to setup a Master Detail Report, Division1 Entity 1 SubEntity 1 Subentity 2 Subentity 3 Entity 2 SubEntity 4 Subentity 5 Subentity 6 I would like to throw … -
No option to output format in excel 2007+ .xlsxSummary: Hello! From my online research online (I'm not an MS history expert) - "XLS and XLSX extensions represent popular Excel file formats that were introduced by Mic…Kevin M Storrie 41 views 5 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM