Reports
Discussion List
-
Error executing query. The number of cells exceeds the maximum of 2000000When trying to open a Report from the "Reports" in Oracle planning, we are getting this error message "Error executing query. The number of cells exceeds the maximum of …User_2025-03-10-22-57-31-218 184 views 5 comments 0 points Most recent by User_2025-03-10-22-57-31-218 Planning -
how can we disable standard jobs like 'Print Receivables Transactions' from the Schedule job processSummary: how can we disable standard jobs like 'Print Receivables Transactions' from the Schedule job process, so the user can not run this from the Schedule process? Co…Ankush Faye 32 views 1 comment 0 points Most recent by Deepak Pai-Oracle Supply Chain Financial Orchestration -
How to create actual vs budget and variance report?Summary: Hi, We have loaded our budget on budgetary control. We are now trying to build a report with budget vs actual amounts and variance between the two. However, ora…ShailenS 1.1K views 4 comments 0 points Most recent by Linda Wong-Oracle Reporting and Analytics for ERP
-
While running whole population in OTBI we are facing issue.Summary: Content (required): we are using Pivot table output in the OTBI report for 1 or 2 employee it's working fine when we are running whole population, we are gettin…challa praveen 21 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Unable to see the Goal Status for Goal plan reportSummary: Unable to see the Goal Status for the Goal Plan OTBI report Content (required): Employee has submitted the goals for approval, but the same is not reflecting in…
-
Report to extract LRU Calculation cards configuration detailsSummary: Report to extract LRU Calculation cards configuration details Content (required): Hi Team, Greetings! Does anyone have the report or the query to extract LRU Ca…Parag Hiremath 61 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
How do I get Box 13 to populate on the W2?Summary: Box 13 on our W2s is not showing as checked. We are a government agency with a pension plan. I looked through Oracle documentation and found guidance regarding …Sara Ro 131 views 1 comment 1 point Most recent by Faithe Chu-Oracle Payroll and Global Payroll Interface (GPI)
-
Is there a way to report which report is used how frequently for BI/OTBI/BICC/FRS?Summary: Hi Team, We are looking for providing a metrics on usage of reports and wanted a way to report which report is used how frequently for BI/OTBI/BICC/FRS? Content…Abhilash K - Deloitte USI 71 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
OTBI-Expense-Expense Transactions - SQL to Link Expense and PPM ?Summary: OTBI-Expense - Expense Transactions - SQL to Link Expense and PPM Content (required): Hello I have an OTBI report with the subject area Expense-Expense Transact…Cesar Saveedra 41 views 1 comment 0 points Most recent by Vinodhini Vobhilineni-Oracle Project Management
-
BI Publisher Word Plug-In ErrorI have the Word Plug-in that has previously worked without issue, however it is now kicking back an error when I attempt to preview my data. Steps taken: Opened rtf temp…
-
Report to get the duplicate element entries in a given pay periodSummary: Report to get the duplicate element entries in a given pay period Content (required): Hi Team, Greetings! Is there an existing report to get the duplicate eleme…Parag Hiremath 11 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Dynamic Logo in FRS reportsSummary Dynamic Logo in FRS reportsContent Hi All, Can we have company logo derived dynamically in FRS reports ? Thanks Version 19CUser_2025-01-30-02-57-36-931 50 views 1 comment 0 points Most recent by Hemalata-Oracle Reporting and Analytics for ERP -
Mass Update messagesSummary: Content (required): What table stores the messages from Mass Update transactions? Version (include the version you are using, if applicable): Code Snippet (add …Scott Paulin 41 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
What data security policies are required for each financial Transaction Analysis Duty?Summary: I am trying to create a custom role that allows the user to run a custom OTBI report but I don't know what data security policies are required for the report. I…
-
Hide "Create Bookmark Link" LinkSummary: Dears we are trying to hide the link highlighted in screenshot attached but we dont understand how. OTBI is available to users within a dashboard, we already ch…
-
Using OTBI to fetch latest ACTIVE assignmentWe would like to use a filter which we can re-use to fetch the latest active assignment for a person. For 99% of our population, it works to do MAX("Worker"."Assignment … -
Invalid Number Error in fetching Basic Salary ComponentSummary: We are writing an oracle sql query to fetch different components in the salary for inactive employees. But it keeps showing below error on runtime. ORA-01722: i…Rohankumar Patel 63 views 2 comments 0 points Most recent by Sudheer Patel Reporting and Analytics for HCM
-
Can we hide a specific sheet in the excel output for some users?Content (required): We have an excel report which contains 2 tabs where 1st sheet contains the data dump and 2nd sheet is the actual report which is based on the 1st she…Sujeeth Chinta 41 views 2 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
How to create native ID to define Data Source in Narrative ReportingSummary: Currently we have SSO User id for EPM in IDCS OCI GEN2. Kindly advise how to create native ID Content (required): Read through the document. It mentioned "You m…Sukittima Siwapetcharakorn 82 views 2 comments 1 point Most recent by Krishna Kumar-Support-Oracle Narrative Reporting
-
Hiding Out of The Box Reports - (Human Capital Management)Is it at all possible to hide the folder that contains the out of the box reports (Human Capital Management)? I can see we can remove the 'BI Consumer Role' from our rep…MikeW 51 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Automatic parameter binding for contextual reportsSummary How to configure R13 functionality "Application Context Passing to Embedded Reports"Content We are trying to configure the solution "Application Context Passing …Gabrielle Ungaro 69 views 2 comments 1 point Most recent by Satheesh Nesamani Reporting and Analytics for HCM -
Reporting on OTBI and its Subject areas in UseSummary: There is requirement to check if there are any existing OTBIs that uses fields identified as sensitive. Is there a way to achieve this? Content (required): refe…Girish_Kulkarni_123 32 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there a way to "expand all" when using html reports with the expand optionSummary: Our users like using the html view of the financial reports where we have added the expand function, letting them drill down (to a certain degree) into the row … -
Performance Reviews for Inactive employeesHi, I am trying to pull a performance review for a terminated employee.When I go into the performance performance goals screen and search for the employee, he iş appear …Cansel Karasoy 41 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Reporting Comments on Termination/Resignation Quick ActionSummary: Content (required): In classic UI, we were able to pull Employer Comment on OTBI analyses but that field is not available in RUX and is replaced with Comments a…Kathleen Nguyen 32 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can labels in Waterfall Charts be dynamic to be above the bar if an increase/below if decrease?Summary: We have a requirement to be able to display labels above the bar in a waterfall if an amount is an increase and below if a decrease with the Label Location set …
-
Need table name for Additional Person InfoSummary: Need table name for Additional Person Info.Please refer the attachment for the screenshot.minati_behera-Oracle 482 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM