Reports
Discussion List
-
Table to get user password expiration dateSummary: Table to get user password expiration date Content (required): Hi All, Which table stores the user password expiration date? The user wants to create a report. …Venkatesan 914 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
An OTBI report in Workforce Management-Work Relationship subject area doesn't work for some rolesSummary: We have an OTBI Report with 4 columns, all under Workforce Management - Work Relationship Real Time category (Display Name, Person Number, Worker Payroll Name, …Justin Hurley 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to create ESS for custom report in multiple languages?Summary: Suppose a custom report whose layout is already available in multiple languages (multiple xlf files). First I logged in EN language, went to the Manage Enterpri…User_2025-02-11-06-12-35-024 71 views 3 comments 0 points Most recent by Shravan S Kumar-Oracle Reporting and Analytics for ERP -
Is there a way to display the connection name on a report output?Summary: We have both test and production pods in our EPM stack and while we are designing reports we do many runs and saves in a dev pod. Currently, we have a footer in…Michael C Stefanavage 31 views 1 comment 0 points Most recent by Dave Roberts_-Oracle Narrative Reporting -
How can I add the manager information of the employees to the Analysis report?I want to add the managers of the employees such as 'head,c-suite,sr.head' to the report I prepared from the analysis report. When I get this information from the "Matri…Cansel Karasoy 42 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
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 …
-
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
-
Dashboard with BI report linkContent Dear All, I have a requirement to create a dashboard with the direct links of BIP reports. Whenever user clicks on the link, it should directly generate the repo…User_2025-02-06-14-37-05-233 123 views 9 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
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 192 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
-
Using COUNT function in Excel Template in BI PublisherSummary Using COUNT function in Excel Template in BI PublisherContent Hi All, Can someone please provide an example of how to use the count function in BI Publisher Exce…Aloka Bhattacharya 331 views 2 comments 1 point Most recent by Valeriy Gorbunov 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. … -
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 33 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
-
Create BIP Report to Fetch the ESS Job Name, ID, And the SubmitterHi, We would like to create a report to fetch the ESS job name, id, and the submitter. ThanksAhmed Maher Kadeh 51 views 5 comments 0 points Most recent by Abhijit Sahu-Oracle BI Publisher Learning Center -
Skills OTBI reportSummary: Dear Experts, Please could anyone help how to extract the OTBI report to find how many employees updated the Skills in the Oracle? Kindly help with the subject …Rajeshkumar_Sekar06 31 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Costing of Positions subject area in OTBI?Summary: We get requests from all of our customers in Academics and Healthcare for reports/ analysis that show position costing but we have to use BI Publisher since we …Darren Nelson 301 views 9 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
How to create a Cross-Tab reporting using BIP Excel TemplateSummary: How to create a Cross-Tab reporting using BIP Excel Template Content (required): Hi, We have a complex report layout and we have to develop it using BIP Excel T…
-
Migrate reportsSummary: Report not being updated when migrated to different environment. Content (required): Hi all, We have encountered an issue in the following situation: Goal is to…
-
I am working on one of the change only extract but I am not getting OLD values for few recordsSummary: I am working on one of the change only extract but I am not getting OLD values for few records Content (required): I am working on one of the change only with p…
-
In need of a report that returns associates who had a change in their direct managerSummary: Have a need for a report that returns associates who have changed their direct manager Content (required): We have a need for a report (BIP or OTBI) that will i… -
Link external data inside BIP reportSummary: Hi! I have an external data that is in excel file, is there a way to import this data into BIP and access it inside the data model? If yes, kindly share a docum…RenzelkeithCoquia 93 views 6 comments 0 points Most recent by makarandamondikar Reporting and Analytics for HCM
-
Can't see absence reason in reports after putting end date inside the relevant absence typeSummary Can't see absence reason in reports after putting end date inside the relevant absence typeContent Hi, We have an issue that after putting the end date to an abs…Markovich Chen 33 views 3 comments 0 points Most recent by Jonny Varley Reporting and Analytics for HCM