Reports
Discussion List
-
Machine learning files - CausalityAnalysisPromptTemplateSummary: what is the best way to update this machine learning files to show my data without %. Do I take a copy of an existing example, or do I write my response based o… -
How to report on journey task expiration configuration?Summary: Is it possible to report on journey task expiration configuration (i.e. Task 1 expires 10 days after assigned date, Task 2 expires 10 days after due date, etc.)…
-
Lease details report showing values in adjustment column for ROU but not for lease liabilityWhen a lease is amended, the lease details report is updated with the adjustment amount for both ROU and lease liability balances. However, upon amending the same lease …
-
Can we filter the data in reports based on smart list member?Summary: I am preparing one report where i am using smart list. I have smart list member created like - Bank Overdraft,Term Loan, Lease Liabilities and i am recording va…Chakresh 51 views 4 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
How to fetch the survey section from Performance DocumentHello Experts, Does anyone know where in the tables to fetch the Survey section from performance document? Please Help! TIA
-
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 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
-
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.3K 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 275 views 3 comments 1 point 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 11 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 51 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…