Reports
Discussion List
-
I want to group the date year wis in results file which excelFor one of my extractions in report code I am extracting date with code : Trunc(creation_date) CREATION_DATE and in excel layout I hv made the creadtion_date cell custom… -
Build BI Pub for Representatives Details InformationHi Everyone, We are currently building a BI Publisher report to retrieve detailed information about Representatives. The report and SQL query work as expected in our Tes…Andriampeno Odilon 21 views 0 comments 0 points Started by Andriampeno Odilon Reporting and Analytics for HCM -
roundingSummary: Sum of rounded numbers issue Content (please ensure you mask any confidential information): So I edit a report and find that a total column references sum of an… -
Oracle BI Report bursting throwing errorHi Team, I created 5 reports and all 5 are scheduled in Prod. Only 1 report is getting failed while bursting. Getting below error. Detail Message: ::JOB_WAIT_TIME_SECOND…VijayRajalbandi 218 views 4 comments 0 points Most recent by User_NAIBF Reporting and Analytics for HCM
-
OTBI Performance and Timeout Errors For End UsersHi all, I'm wondering if anyone has any suggestions on how to work out some issues with some analyses we're using for a dashboard our business uses. We've built several …
-
PBCS Report Formulas Not Updating When Rows Are Inserted or DeletedHello, I am experiencing an issue with a report in PBCS. Some rows contain formulas that reference other rows by row number. For example: [4] + [6] The problem is that w…
-
Emedded dashboard (through Page Integration) without granting access to CatalogSummary: I need to make a report available to a group of HR users. These users are not HR Specialists per se, meaning they should not be allowed to make changes to perso…
-
Dynamic column generation - Reporting with BIP (RTF/Excel Template)Summary Need to dynamically generate columns based on the number of elements currently present in the ApplicationContent Hi, We are currently on Release 13 Oracle Cloud …Brendon Charles-24581 337 views 5 comments 2 points Most recent by DebashishDeka Reporting and Analytics for HCM -
Narrative Reporting Font in Embedded Doclet Revert in Document after Refreshing ContentHey everyone, I've run into what I believe to be a bug. I made a tabular report in Management Reporting that was first in Arial but has since been changed to Times New R…
-
Oracle Cloud PBCS - using Period Mappings/Global Mappings in Reports as column headersSummary: I am looking to see if it is possible to build a Column header using the "Period Name" column found in Global Mappings when using the Reports in Oracle Cloud - …
-
Transaction Console Job Requisition approval chain reportSummary: The user can't access the transaction console and through administrative tasks in BPM, they can see only their job requisition. We need a report to see the appr…
-
User Login Activity QuerySummary: We have a contractor and would like to measure his level of effort within our company. Is there an existing query or report that shows how many times a specific…
-
Unable to skip resending the Bursting Notifications to HR/Team for Positions whose incumbent is ZeroSummary: Unable to skip resending the Bursting Notifications to HR/Team for Positions whose incumbent is Zero , and notification was already sent in previous bursting ru…
-
Nested Functions in Narrative Reporting Not Returning DataSummary: Nested function in Relative Member does not return values. Content (please ensure you mask any confidential information): Hi there, I'm creating a report in Nar… -
Question marks appearing in custom eText outputSummary: Custom eText payment format in BI Publisher has question marks inserted into output. Content (please ensure you mask any confidential information): I have creat…
-
Extract to excel only few of CostCenter POV set as "Print All" selection in Narrative ReportingSummary: is there a way to extract only couple of CostCenter in a CostCenter POV(set as "Print All") into an excel as Separate Sheets for only a few CostCenter i.e., fil…
-
How Can We Identify Whether The User Is Logged In Via SSO OR Native LoginHi Team, We have enabled both SSO and Native login for our pod and wanted to know how the users are logging into the system. Is it by SSO or Native login. Please suggest…Sudarshan Uppara 99 views 4 comments 0 points Most recent by Rajdeep_Chavda Reporting and Analytics for HCM
-
How can we migrate FRS reports in MYFOLDERSummary: How can we migrate FRS reports in MYFOLDER from one user to Shared folders by other user? As user 1 does not have access to paste the FRS reports to Shared Fold…SwapnilSurange1 59 views 6 comments 0 points Most recent by SwapnilSurange1 Reporting and Analytics for ERP
-
Drill through errorWe are experiencing a drill-through failure in our FCCS application. When attempting to drill from a data cell in Smart View or a Financial Reporting report, we receive …DebajyotiRay 27 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Getting 401 Unauthorized error code while calling an OIC integration from BIP reportSummary: I have created an app-driven integration that has - trigger REST connection with security policy: OAuth 2.0 - the REST trigger configures multiple resources - m…Nermin Khaled-Oracle 819 views 8 comments 0 points Most recent by Vijay Rajalbandi R Reporting and Analytics for ERP -
Data sources compared in a report in 2 columns - possible for a large number of accounts?Summary: Scaleable way to create data source X versus data source Y in 2 columns in a report Content (please ensure you mask any confidential information): So I know you…
-
FCCS FR Report Books throw Error - Refused to ConnectSummary: When trying to run an existing FR Report Book in FCCS and EPBCS Production, we see an error: epm-xxxxxx.epm.us6.oraclecloud.com refused to connect. We do not se…Thiru Vedantham 96 views 11 comments 0 points Most recent by Thiru Vedantham Financial Consolidation and Close -
Adding author's name to Inline grid notesSummary: I need to add an author and date to my inline grid notes on a report, and I do not see that option in the note template. Is there a way to add author informatio…
-
ESS-01035 Unable to determine a logical application name for new request running new jobset in UII am defining a jobset for the first time, to work in financials for Advanced Collections. I have identified how to create the jobset under Manage Enterprise Scheduler J…Susan Hathaway 117 views 4 comments 0 points Most recent by Susan Hathaway Reporting and Analytics for ERP
-
R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet in 26CSummary: Hi, Can anyone please share R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet in 26C release Thanks, Content (please ensure you …
-
Need Table name to pull Time Entry Layout Component in Time and LaborSummary: Need Table name to pull Time Entry Layout Component in Time and Labor Content (please ensure you mask any confidential information): Hi, Need Table name to pull…Sujeeth Chinta 177 views 12 comments 1 point Most recent by Amr Kasber Reporting and Analytics for HCM -
FDI : action & on click on calculated "Without Check-Ins" always redirects to "With Check-Ins" datahave a bar chart visual with: X-axis: Business Unit (from "HCM - Workforce Core" subject area) Y-axis values: Worker with Check-Ins (from "HCM - Check-Ins" subject area)…Imene_Zaouzaou 15 views 0 comments 0 points Started by Imene_Zaouzaou Reporting and Analytics for HCM
-
Narrative Reporting Chart Labels OverlapWanted to check regarding a chart formatting issue in Narrative Reporting where axis or data labels overlap, resulting in poor chart readability and an unpresentable vis…