Reports
Discussion List
-
Need PVO details for PER_USER and PER_USER_HISTORY?Summary: I am looking BICC Tag for PER_USER, PER_USER_HISTORY I've found "HcmTopModelAnalyticsGlobalAM.UserAM.UserPVO" this PVO has history id so I assume this is for PE…RameshBabuJambula 61 views 3 comments 1 point Most recent by RameshBabuJambula Reporting and Analytics for ERP -
Issue with Report Changes Not Reflecting After Clicking SaveWe encountered an unexpected behavior with one of our reports. We made some updates to the bursting, clicked the save button, but when we checked the bursting again, the…Michael Angelo Lucena 131 views 4 comments 0 points Most recent by Thri Gaadi Reporting and Analytics for HCM
-
In EPM Reports the header appears as an image in Excel. Is it possible to display it as text?We have converted our FCCS reports to Reports and we are facing some issues. Our business team has a requirement to generate the reports in Excel and PDF and upload them… -
reports wrong member selection on POVSummary: Hello Im experiencing whats for me is a weird behavior when selecting members on the POV of a report. Problem: Wrong option of members on the selection list of …GuiFernandes-Oracle 21 views 5 comments 0 points Most recent by Dave Roberts_-Oracle Narrative Reporting
-
How to change the PDF line to solid lineHi all, We are migrating the reports from FRS to Narrative Reporting. In the old report, the line format between each line is solid line in PDF, but in the new report it…
-
How to show POV selection in PDF format in Narrative Report?Hi all, We are migrating the FRS reports to Narrative Report. In FRS, the setup for FRS report is prompted POV to let user select and there is a choice list for user to …ZIZHENG GAO-Oracle 11 views 1 comment 0 points Most recent by Dave Roberts_-Oracle Narrative Reporting
-
How to hide grid when there are no data in epm reportsSummary: We would like to see only the grid that has data and not the grid that doesn't have data. We have 2 sheets in the report having suppression enabled for zero and… -
Calculating average headcount and turnoverSummary Calculating average headcount and turnoverContent We'd like to be able to calculate the average turnover rate for rolling 12 months by using Period End Headcount…Emily Robinson 446 views 5 comments 0 points Most recent by Lauriane Massin Whitaker Reporting and Analytics for HCM
-
my FRS is showing duplicate accounts on reportsSummary: Reports were correct when created but now have this issue of duplicating and categorizing accounts under cost of sales but still appear in the correct category …SaintNick 1 view 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
How can we find the path of the report being referenced in a dashboard within OTBI/catalog?Content Hi All, Is there a way to find the path of the report that is referenced in a dashboard? We have several custom dashboards built by various people within the org…PriyaPenugonda-SC 782 views 5 comments 0 points Most recent by Gokul Reporting and Analytics for HCM -
Need to bring the entities selected in prompt to the header dynamicallyIn EPM Cloud Management Report, we have a specific need to bring the Entities selected in the prompt. The Entity dimension is placed in a single column having Multi Sele…
-
Project Costing (PPM) table where Invoice numbers stores.Summary Project Costing (PPM) table where Invoice numbers stores.Content Hi Gurus, I am in development of Project reports. I have to capture AP invoices details which ar…
-
Future Dated Hires and Assignments not showing on reportSummary: I have created a report that picks up future actions. I am using the effective date from the Assignment Events Subject area and it picks up some of the future a…Mark Stoker 132 views 2 comments 0 points Most recent by Mark Stoker Reporting and Analytics for HCM -
How to change the output format of the JAVA type ESS Job from .csv to .xmlI have a ESS Job of JAVA Type in Oracle Fusion having output in .csv format, User want the .xml format anyone have any idea how could I change the format?Damoder Chitti 11 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Can we use Get_Abscence_Count formula function in extract rule?Hi All, We are trying to get the absence occurrences in an extract for that we are trying to build a extract rule using a formula function "Get_abscence_counts" but we a…
-
Is it possible to audit invoice notes entered by accounts payable users?Summary: I am going through the Payables audit policies to determine if I can enable tracking of any invoice note edits or deletions. I'm not sure if the best approach i…Luis Orihuela 11 views 3 comments 0 points Most recent by Luis Orihuela Reporting and Analytics for ERP
-
Fetch the latest Completion record on the course level in Oracle Learning Cloud OTBI reportsSummary: Fetch the latest Completion record on the course level in Oracle Learning Cloud OTBI reports Content (please ensure you mask any confidential information): I am… -
How to round off data column/row in Oracle EPM Management ReportsWe have a requirement where we need to round off the data row/column instead of creating a formula row/column and using the "ROUND" function as we need to utilize the dr…
-
add date conditionSummary: Hi Everyone, I need your assistance in regards to add a date condition in analysis. I have to add a condition in the where clause and want out those positions. …
-
Limiting restricted, Confidential and PII fields BI Authors in HCMSummary: Our goal is simple: Make OTBI authorship available to as many HR and potentially non-HR employees as possible while being conscious of security. Example: Make a…bwdata 61 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there a way to limit what tables a user can query in OTBI?We have a support team that's requesting access to write Data Model queries in OTBI. Our concern is restricting them to only the financial tables. Does anyone know if th… -
Book is generating PeriodOffset error for me. Book and report work for other users.Summary: Existing book and its report open with a period value of 'Jan' and is getting a PeriodOffset error for me. Report in NR is linked to Planning ASO cube. Report i…
-
Is it true that oracle is planning to deprecate webservice datasets from BI Data Model?Is it true that oracle is planning to deprecate webservice datasets from BI Data Model? and if its true, what are all the dataset types that will be retained in the futu…Abhilash K - Deloitte USI 31 views 2 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
BI Reporting restricting by segment value depending on UserSummary: I am looking for a way of resticting a BI report by a segment value depending on the user accessing the reports. Ideally by assigning a segment to a user withn …JHould 14 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
I need to get OTBI Report Link with parameter like BIP ReportSummary: Hi Team I am looking for deep link or OTBI report link so that I can hit the URL directly by passing parameters. We have this feature in BIP to get the link , b…sailesh_cloudare 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
ORA-29400: data cartridge error ORA-10260: PGA limit (20000 MB) exceeded - process terminatedSummary: We are running a custom report that have recover more than 1.2 million of records and cheking the XML Data this have over the 1GB, when we executed this report …Darwin HP 114 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
How do I report on only the most recent assignment (active or terminated)?Summary I need to build a report of all employees and only want the most recent assignment to appear on my report.Content Hi all, Does anyone know how to report on all t…Matthew Grillo-95429 303 views 11 comments 1 point Most recent by Balhaji Reporting and Analytics for HCM
-
How to exclude null values in eText output using RTF templateSummary: Example: My output file is comma separated .txt file generated using RTF template for HCM extract. I have 25 columns, out of which first 5 columns are fixed i.e…Shilpa Varghese 216 views 3 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM