Category 81
Discussion List
-
OAC Essbase Add-In for Google SheetSummary: Are we able to use smart view in Google sheet? We have heard about OAC Essbase Add-in, Will it replace Smart View for Google sheet? Also, while adding the plug-…Nikhil Bidwaikar 31 views 0 comments 0 points Started by Nikhil Bidwaikar Reporting and Analytics for ERP -
Is there a UE which can provide EEs who are unprocessed in a payroll run?Summary: Looking for a UE which can provide the list of EEs who are not processed in a payroll run i.e. EEs in LOA, Payroll Ineligible status? Content (required): After …
-
Table which stores User password expiration dateSummary: Table which stores User password expiration date Content (required): Hi All, Which table stores the user password expiration date? The user wants to create a re…
-
Is it possible to build workforce compensation approval workflow by OTBI or BI?Summary: Hello experts, our customer would like to represent the workforce compensation approval workflow by report. Do you know if it is possible to do it by OTBI or BI…Valerio Curzi 21 views 4 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
SQL Query to retrieve User Status both Active and InactiveSummary: Query to retrieve User Status both Active and Inactive Content (required): Trying to put together a query that will tell which users and how many of those are e…Edwin Martinez 3K views 2 comments 0 points Most recent by Edwin Martinez Reporting and Analytics for HCM
-
Any BIP reports to pull Tax withholding details. Federal, State, Local tax dataSummary: Any BIP reports to pull Tax withholding details. Federal, State, Local tax data Content (required): Version (include the version you are using, if applicable): …Prabhu Krishnamoorthy 61 views 6 comments 0 points Most recent by Chelsea Holden Reporting and Analytics for HCM -
Count of week days for absence reportSummary: We need to count the weekdays (Mon - Fri) in a selected period to calculate absence percentage. Anyone a suggestion or solution how to get this done? WouterWouter.Schaap 51 views 6 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
Termination report for multiple work relationshipsSummary: I need a true termination report for when someone leaves an organization with multiple legal employers, and they have multiple work relationships. I know there …Jessica D 61 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Using filter with ORSummary: We want to add a filter to a fact column to only return Direct Applications, so no Agency Referrals from Source or Internal Candidates from Job Application Basi…Emily Robinson 21 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
BIP - Non Catalog Item Report (Learning)Does anyone know how to fetch creation date using BIP? Please see screenshot below:Hazel De Castro 41 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
i have this two rows in the result column from union of two subject area i need to divide those rowsSummary: i need to divide the result from subject area 1 (defect as in the screenshot ) above the result of subject area two (total as in screenshot ) Content (required)…Ab_AM 31 views 2 comments 0 points Most recent by Amrita Gupta-Oracle Reporting & Analytics for Fusion Service
-
Error in join subject area Purchasing Real Time and Requisition real TimeSummary: Hi Team, We are trying to join the subject area Purchasing Real-time and Requisition Real-time, but getting error as below- Error Codes: OPR4ONWY:U9IM8TAC:U9IM8…raban 194 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Function to replace accent characters with respective characterSummary: Function to replace accent characters with respective character ex: O'Brian to O Brian, Noël to be Noel I need something like ascii using which it will directly…
-
Unable to resolve " ORA-01427: single-row subquery returns more than one row"Summary: Hi Experts, When I open a BI report, I am getting, "ORA-01427: single-row subquery returns more than one row" Error. I checked each subquery and all subquery re…ShawShankk 1.1K views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Address Validation report for USSummary: Hi, Do you have sample address validation report for US? Thanks, Content (required): Version (include the version you are using, if applicable): Code Snippet (a…
-
Worker dropping off report if null value in one columnWe're using the Workerforce Management - Worker Assignment Realtime and Workforce Management - Areas of Responsibility subject areas for the report I've attached below. … -
How to create .txt files using burstingSummary: Requirement is to generate a .txt file with Job Posting description for Job Requisitions meeting certain criteria Content (required): We are having issue in gen…Arathi Devi H 355 views 4 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Select query not giving desired resultSummary: I'm using below query but it is not giving desired result Content (required): The use case is to fetch the Email ID and subscription number of the contact assoc…Neelesh Varma 31 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
Best way to match Scenario with the corresponding Year members in Management Reporting?First, our situation: We have a Scenario dimension containing members such as: FY23 Budget (Budget created in FY23, for the years FY23 and FY24) FY23 Forecast 2 (Forecas… -
Link to the offer in the personalized notificationSummary: Content (required): Good morning everyone, we are developing a package of custom notifications on rtf templates and excel attachments to be provided to a custom…
-
How can I use parameters that work independently from each other on a single dashboard screen?Hi, I have multiple reports that I use on the dashboard screen and my 2 reports have promts. And from these separate promts there are common ones. I want to use the sepa…Cansel Karasoy 31 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Is it possible to generate csv file with column labels of child records even when they don't exist?Summary: Standard BI Publisher behavior is that column labels are not generated for columns of child records when they don't exist. Example: Data Model queries: Data Set…User_2025-02-11-06-12-35-024 31 views 4 comments 0 points Most recent by User_2025-02-11-06-12-35-024 Reporting and Analytics for ERP -
Customise standard report - new layoutSummary: Standard report which only runs inside Fusion ERP. How to use sample data xml export in Fusion BI Publisher? Content (required): So I have a standard report whi…Robert of STAU 63 views 4 comments 0 points Most recent by Robert of STAU Reporting and Analytics for ERP
-
Need to customize a workflow notification but cannot see 'Customize' in the More dropdownSummary: Need to customize a workflow notification but cannot see 'Customize' in the More dropdown. I have a custom BI Admin role. Am I missing a permission to be able t…PrJohns-Oracle 31 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM