Category 81
Discussion List
-
OTBI report logic to fetch Employees who were in current position as of 1st June,2019Summary: We have a requirement to create an OTBI report which will fetch all Employees who were in current position as of 6/1/2019. I was looking at the subject area - '…Sovan Mishra-Oracle 131 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Query to extract expense reports which are reassigned to different approverSummary: We are trying to expense reports which are reassigned from one approver to another approver. Content (required): I tried to query below tables but could not fra… -
Query to extract expense reports which are reassigned to different approverSummary: We are trying to expense reports which are reassigned from one approver to another approver. Content (required): I tried to query below tables but could not fra… -
Report on all the comments that the enrolled users have done in Enrollee Self-service conversationSummary: Content (required): Hi there I want to run a report on all the comments that the enrolled users have done in Enrollee Self-service conversation in a course. Is …Bobby Jourdan 11 views 2 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM -
Project Report focused on people project historySummary: Content (required): Hi team, I'm an HCM consultant so I have no experience about ERP - Project, sorry in advantage if I will say something not correct. A client…Gabriele Falso-Oracle 31 views 5 comments 0 points Most recent by Andy May-Coates-Oracle Project Management -
How to find 'User Defined Column' within Compensation PlanSummary: Can anyone help locate this field within a Compensation Plan. I need to find "Numeric Column 18", preferably within a Subject Area or if it's only within a tabl…Andrew_Schmitz 41 views 5 comments 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
What’s New in EPM Cloud Narrative Reporting and Reports Release 21.11Summary: Learn about what’s new in the EPM Cloud Narrative Reporting and Reports 21.11 release. Content: Please refer to the November 2021 What’s New guide to understand… -
Join "Approval Notification Archive Real Time" & "Transaction Administration Real Time" subject areaSummary: How to join Human Capital Management - Approval Notification Archive Real Time & Human Capital Management -Transaction Administration Real Time subject area Con…Nikhil Bhandari 371 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Performance Task Next Step BIP ReportSummary: Creating a BIP report for Performance Tasks showing Step/Next Step Content (required): We have a BIP report for the Performance Task Steps which include Task St… -
Report to Audit object migrationsSummary: A report that shows who created/updated application objects (i.e. Fast Formulas). Content (required): Version (include the version you are using, if applicable)…Wayne Smith 31 views 2 comments 0 points Most recent by Paidiparthi Ravindra Reporting and Analytics for HCM -
Logo in BI Publisher RTFIs there any way of embedding a logo dynamically in BI Publisher RTF ? We wish to show different logos based on different legal entities. -
To develop a BI report with calendar functionality.Summary: Need to develop a BIP report which uses bursting functionality and when ever mail triggers, it gets automatically saved in the the calendar of the mail just lik… -
How to see multiple values in new line in Oracle SQLSummary: Content (required): I need to develop a BIP report for talent profiles. As per the business requirement, I need to display multiple values (Ex. Skills, Language…Prajna Hegde 21 views 2 comments 0 points Most recent by Prajna Hegde Reporting and Analytics for HCM -
Subject Area filtering - empty valuesSummary: Subject Area filtering - empty values Content (required): Subject Area filtering of Assignment Type filters out empty values as well. For example, if we have pe…User_2025-02-11-21-40-21-159 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need SQL to get Element Duration DatesSummary: Need SQL to get Element Duration Date, that is at assignment level. Content (required): Need SQL to get Element Duration Date, These dates are present in 3 leve…Raghavendra M 211 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
BI Publisher - How to pivot to display questions horizontally using answers instead of measuresSummary: BIP - How to pivot to display questions horizontally as the heading using answers instead of measures, displaying respondents as the first column Content (requi… -
OTBI including an header sectionSummary: We have defined an OTBI that exports lines with the images uploaded in the Fusion Product Hub module (SCM). Can be possible to include before the table section …adelsorbo-Oracle 41 views 5 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
21D known issues - Just a thread to note down any issues ppl with this release have facedSummary: Opening this thread to note down issues with 21D. Currently we have this release in our lower environment and are testing - so I thought to have a thread that c…Dhruvjoshi23 11 views 3 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Is supplier audit report available in fusion payables?Summary: We are looking for standard report to track old value and new value when supplier name, supplier bank number, etc is changed. Please let us know is there any st… -
Can we pull Formatted Description attribute at the Item Level into a OTBI Report?Summary: Is it possible to pull the Formatted Description attribute at the Item level to be pulled into a report? This is an rich-text attribute and wasn't showing up in… -
Succession Planning BIP ReportSummary: Content (required): Hi All, As per the client requirement, I am trying to create a BIP report for listing the incumbent (person) specific and position specific …Prajna Hegde 22 views 8 comments 0 points Most recent by Prajna Hegde Reporting and Analytics for HCM -
Data StrategySummary: I am in need of running a report that pulls how many minorities in a certain grade were promoted to an officer status. Please help guide me to the correct subje…User_2025-02-11-00-58-38-371 21 views 2 comments 0 points Most recent by User_2025-02-11-00-58-38-371 Reporting and Analytics for HCM -
PBCS Invoke Fusion Financials BI Publisher report from Financial ReportSummary: As an alternative to drilling to Fusion Financials is there any way to invoke a BI Publisher report in Fusion Financials passing appropriate parameters? Content…User_2025-02-10-15-12-48-631 21 views 7 comments 0 points Most recent by User_2025-02-10-15-12-48-631 Planning -
How to embed Logo/Images in BI Publisher RTF Template in HTML Output formatSummary: How to embed Logo/Images in BI Publisher RTF Template in HTML Output format Need to Embed Logo in HTML output format for BI reports Template. Options Content (r…Kaustubh Deshmukh 11 views 7 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM -
Need sample analysis/SQL to get various balance values for each assignment for EE with multiple GTSummary: When global transfer happens for any employee, we need to validate various balances to confirm if they are transferred to the new LE. During a year if an EE is … -
Can I create a button to print or cancel, when executing a report in BI?Summary: Can I create a button to print or cancel, when executing a report in BI? If possible, what would be the next steps? Content (required): Version (include the ver…