Reports
Discussion List
-
Need SQL query or table to get Worker details column under configure worksheet page layout.Summary: Hi, Need SQL query or table to get Worker details column under configure worksheet page layout in compensation We need the table where these highlighted(Yellow,… -
SQL Query for timecard approval to BPM workflowObjective : SQL Query to get Approver Name, Approval Date and Status of Timecards Imported in Project Cost Issue : I am unable to find a link between HWM_TM_REC and Work…Palash Kumar Singh 138 views 2 comments 0 points Most recent by Palash Kumar Singh Reporting and Analytics for HCM
-
Query to get ESS job details which are running more than 24 hoursSummary: Query to get ESS job details which are running more than 24 hours Content (required): Query to get ESS job details which are running more than 24 hours, I need …
-
How can I export all comments or notes entered through Note Templates during Inline Grid Entry?I’m able to view the comments in the Notes section of the application, but the interface isn’t user-friendly as I have to click “View” for each combination to see the en… -
When I add filter to query the report goes in timeoutSummary: Slow learning (WARF) query Content (please ensure you mask any confidential information): https://us.v-cdn.net/6034893/uploads/S9IJ8KIYKON0/learning-query.txt I…Stefano_Mazzocca 11 views 1 comment 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
A SQL query of privileged resources in the role FSD sectionSummary: Hi All, Can anyone share a SQL query on how to retrieve privileged resources? inside the role of the FSD section oracle provides information about the privilege…Eliran Hadad 41 views 7 comments 0 points Most recent by Eliran Hadad Reporting and Analytics for ERP
-
Query to get Oracle GL COA Entity Segment, Oracle Legal EIN/TIN ,Oracle Legal Entity NameSummary: Hi Everyone, I need query to create a BIP report which fetches the Oracle GL COA Entity Segment, Oracle Legal EIN/TIN , Oracle Legal Entity Name. Thanks in Adva…
-
Is it possible to Drill through the Journal Data in FCCS?Summary: Hello, We are performing the Oracle Fusion and flat file data loads in FCCS Data Management. I wanted to know if drill through is supported for Journal Data ? H…Sirisha G 71 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
SQL query or Table for Allocation Methods under Configure Modeling in CompensationSummary: I need a table or SQL query to get Allocation Methods under Configure Modeling in Compensation. Table for below fields in highlighted box. Content (please ensur…
-
Parts of report being cut off when using multiple grids and viewing whole reportSummary: We have several reports which use multiple grids. We have found that these are now having parts of them cut off and not visible when viewing the report as a who…
-
Number to name conversion of currency value in RTF templateI have currently developed a BIP report using RTF template for a receipt voucher. It contains values in both Arabic and English. I would like to know whether there is a …Manu Krishna T M 24 views 1 comment 0 points Most recent by Ravi Tilekar BI Publisher Learning Center
-
How is the Threshold calculated in NR Reports to verify the maximum limit?We have a report in Narrative Reporting created with 1800 * 700 cells which is within the limit of 2000000 cells (As per NR Report Limit). Although the cells are within … -
Virus scanner not reachable error when unarchive reportSummary: Virus scanner not reachable error when unarchive report Content (please ensure you mask any confidential information): My Client Groups > Reports and Analytics …Junade_Shujaat 114 views 2 comments 0 points Most recent by Junade_Shujaat Reporting and Analytics for HCM
-
How to handle null values while Summing in RTF TemplateSummary How to handle null values while Summing in RTF TemplateContent Hi Team, Please advise with syntax for to handle null values while Summing values in RTF Template …User_2025-01-29-00-33-34-534 1.1K views 4 comments 0 points Most recent by User_NPE6A Reporting and Analytics for HCM -
OAC lab not found on Core HR implementer courseSummary: no OAC console as it was previously the case when requesting a lab from worforce structures in the Core HR MyLearn Course Content (please ensure you mask any co…Lauriane Massin Whitaker 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Required Table or SQL query to get Criteria under Manage Statement Groups in Workforce compensationSummary: Hi, We are stuck to get the details for Criteria details under Manage Statement Groups in Workforce compensation plan in Compensation Module. Please help us to …Opkey PA 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Looking for a Custom Audit report showing old and new valuesClient is looking for a custom audit report build through BI which shows the old and new values.Meenakshi K 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Workforce scheduling: can't get details of patterns and shifts to show on analysisSummary: Looking for direction on how to find and capture the patterns and shifts in my analysis. Under Define Availability: Work Shifts, Work Workday Patterns and Work …MissHeidiJ 73 views 3 comments 1 point Most recent by Stephanie McInnes Reporting and Analytics for HCM
-
Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiSummary Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiple tabsContent Hi Experts, I have a problem. There is a BI R…Aloka Bhattacharya 2.1K views 26 comments 1 point Most recent by User_C767R Reporting and Analytics for HCM -
How does smart view work with Oracle fusion? are there any conditions to work like license?Summary: How does Smart View work with Oracle Fusion? Are there any conditions to work like a license? Content (please ensure you mask any confidential information): Ver…Mohamed Roshdy 31 views 2 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
can we create Custom Journal report Same as OOTB journal reportcan we create a custom journal report Same as Out of the box consolidation journal report with same labels ? even is it possible to pull the data in debit/credit columns…
-
Common Dimensions between Subject Areas in OTBIanyone has a list of Common Dimensions between Subject Areas in OTBI? at least 2 or 3 different Subject Areas?
-
Expected Effort values not populatingHi team, We are experiencing an issue where we receive really inconsistent results for the 'Workforce Learning - Learning Records Real Time' Expected Effort value. Some …
-
Financial Reporting Studio Issue: 2025 Data Not Appearing CorrectlyDear Oracle Support, We are encountering an issue in Financial Reporting Studio (FRS) that is affecting the display of 2025 data in our reports. Problem Description: Whe…Patrick Chrabieh 86 views 6 comments 0 points Most recent by user10987169 Reporting and Analytics for ERP -
report /audit to track any changes done to auto provisioning rules(HCM role provisioning rules)Summary: We need to get a report /audit for any changes done to auto provisioning rules(HCM role provisioning rules). Please help us on how to achieve this requirement. …Jagadesh S 91 views 5 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Latest data changes are not reflecting in the OTBI report immediatelySummary: Hello All, We have an AOR drill-down OTBI report, but the latest changes to data are not reflecting immediately. For example, when we assign an AOR to an employ…Nusrat Shaheen 93 views 8 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
how to create subtotals in excell template for bipI had a requirement to create subtotals for each individual invoice_numbers , when i try to do sum function or subtotal selection it is not giving subtotal for each indi…Voladri Saikiran 31 views 0 comments 0 points Started by Voladri Saikiran Reporting and Analytics for ERP