Reports
Discussion List
-
Query to get Scheduled BIP Jobs in Oracle Fusion HCMHi All, Is there a way to retrieve the schedule details of BIP reports like job name, report name, schedule start date, schedule end date, frequency etc. using a sql que…Dhanuka Chamal 1.6K views 4 comments 5 points Most recent by gclampitt Reporting and Analytics for HCM -
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 34 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 334 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 61 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 56 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 1.2K 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 243 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 …
-
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 …MariaStanciu 12 views 0 comments 0 points Most recent by MariaStanciu Reporting and Analytics for HCM
-
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…
-
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 52 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… -
Need to know the logic behind the seeded report parameters of Payables Trial Balance ReportSummary: Just wanted to know the logic behind seeded 'Payables Trial Balance Report' parameters which are mentioned below 1.Include Bills Payable 2.Negative Balances Onl…SireeshaJaladi 111 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP