Reports
Discussion List
-
OTBI Report coming up with blank dataSummary: We created an OTBI analysis in Recruiting in Real Time and data is coming up blank. Content (please ensure you mask any confidential information): Summary: We c… -
How can I retrieve the full details of each exception?Hi everyone, I’m working on a report that returns schedule exceptions using the following query: SELECT 1 KEY, pse.SCHEDULE_EXCEPTION_ID, pse.SCHEDULE_ID, pse.SCHEDULE_A…Andriampeno Odilon 31 views 4 comments 0 points Most recent by Andriampeno Odilon Reporting and Analytics for HCM -
Is there a reporting function to return the first child of the current POV member?I am trying to figure out a way to return the first child of the current POV member in a report. For example, if the outline below was a dimension hierarchy and the user… -
Syntax for referencing a user privilege in an EL ExpressionSummary: Content (please ensure you mask any confidential information): Hi, I am trying to build a custom menu to access OTBI reports from the Navigator / springboard . …NeenaS25 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
Fixed Assets - Entered PeriodSummary Is the "Entered Period" available in any of the Fixed Asset subject areas?Content I have been searching through the various asset-related subject areas for a fie…ndryden 320 views 7 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
Datedifference formulae function in FCCS ReportsI want to calculate a days difference between 2 dates in fccs reports by the datedifference function available in FCCS reports, I have already used the multiple combinat…Chakresh 63 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Issue with Views in HCM cloud Learning Management (WLF_LRNR_COMPLETION_DETAILS_V) in SpecializationSummary Joins are missing in the Specialization item type part in the Views WLF_LRNR_COMPLETION_DETAILS_V and WLF_LRNR_COMPLETION_SUMMARY_VContent In the code of the vie…Rajesh Ravikumar 58 views 3 comments 1 point Most recent by R Ravichandran Reporting and Analytics for HCM
-
Import Oracle Fusion Data Extensions for Transactional Business Intelligence having an impact.Summary: There's an issue with HCM Reports having said that some columns were not available and the root cause of it was when Import Oracle Fusion Data Extensions for Tr…Franz Marcelo 978 views 8 comments 1 point Most recent by Rich Merkel Reporting and Analytics for ERP -
Table/View for AP Invoice Approval History & Workflow (BPM Flow)We are in the process of creating a customized report to track the complete approval history of AP invoices in Oracle Fusion. The requirement is to fetch details of the …sailesh_cloudare 106 views 3 comments 0 points Most recent by NikhilYadav Reporting and Analytics for ERP -
Headerless csv output in oracle fusion BI reportingSummary: Hi Team, We have a requirement to get the extract in CSV format without header fields in the Oracle BI report. Content (please ensure you mask any confidential …
-
Report dashboard prompt showing error - ACIOA5LNSummary: Report dashboard prompt showing error - ACIOA5LN Content (required): One of the working BI report which uses dashboard prompt, suddenly stopped working and show…
-
How can I write a SQL query in Oracle Fusion Cloud to identify unapproved requisitions?Hi everyone, Please see the full question below. How can I write an SQL query in Oracle Fusion Cloud to identify unapproved requisitions where a specific approver (e.g.,…FlatFish534 21 views 1 comment 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
How to achieve Flexible Hierarchy Selection in Management ReportingHello Community, We have a requirement related to dynamic hierarchy selection in our account reporting structure. Our account hierarchy is structured as follows: AC1000A…
-
[OTBI] "Workforce Performance-Performance Check-in Real Time" SA - unexpected behaviour on filtersSummary: Hello, I have following OTBI analysis : SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT 0 s_0, "Workforce Performance - Performance Check-In …
-
Required table to get Ad Hoc resource name in activities under OfferingsSummary: Hi All, We need a table to get Adhoc Resource name, quantity and description in activities under Offerings in fusion HCM Content (please ensure you mask any con…
-
There is a image placed in Custom/Image folder. How to access this image in the BI report template?Unable to access images from Custom folder in BI report template. We have placed the test image in Custom/Image folder and tried to access this image in the template but…
-
Dynamic Numbering in ReportsHi all, I want to build a P&L Report in PCM for which I want to supress rows with missing values or 0 as a value. I also want to adjust the numbering of the rows, so the…
-
Audit tables for Project Tasks and Sub Tasks in Oracle fusion cloud and policies to enableHi, Are there any Audit tables for Project Tasks and Sub Tasks related in Oracle fusion cloud to create a BI publisher report? I was able to enable the audit policies fo…
-
How can I join the hz_parties table to a project number or contract number table using sql.Hi everyone, I'm creating a work-in-progress report that tracks project costs and needs your help joining several Oracle tables efficiently. I'm working with: PJF_PROJEC…
-
Management Reporting - Member from one dimension to show up as header in another dimensionSummary: In management reporting, we have two dimensions on row, one attribute and standard dimension. We would like the members in attribute dimension to show as header…
-
Insufficient Privileges FA_FUSION_SOAINFRA.WFUserVacationSummary: Getting Insufficient Privileges Error when running below query SELECT * FROM FA_FUSION_SOAINFRA.WFUserVacation SELECT * FROM FA_FUSION_SOAINFRA.WFUserVacation I…Fazil_Shahid_Khan 55 views 6 comments 0 points Most recent by Fazil_Shahid_Khan Reporting and Analytics for HCM
-
SQL code to fetch Overtime, bonus, commissions, merit increases, and locality pay for employeesSummary: Hi Experts, Please provide the SQL code to fetch overtime, bonus, commissions, merit increases, and locality pay for employees. Thanks. Content (please ensure y…
-
How to get employee's co-worker-style contactsSummary: How to get employee's co-worker-style contacts Content (please ensure you mask any confidential information): Hi Experts, Is there any query/tables to get emplo…
-
Manage Geography Hierarchies REST API throwing 401 errorSummary: Hi I am getting an 401Unauthorized error while testing the Manage Geography Hierarchies REST API in postman with valid credentials. API : /hcmRestApi/resources/…
-
We are currently unable to achieve consistent formatting in both the Excel and PDF in FRS reports.Summary: We are currently unable to achieve consistent formatting in both the Excel and PDF in FRS reports. Specifically, we need to center-align the headings in the gri…QuantumPulse1009 21 views 2 comments 0 points Most recent by Dave Roberts_-Oracle Narrative Reporting
-
Can we reference the Consolidation method to pick Ownership % to multiply with the entities?Currently, we have 2 Columns in a Report in Narrative Reporting - one is Bottom members of CurrentPov for Entity in one grid & Consolidation % which has a totally unique…