Reports
Discussion List
-
System Account OwnerSummary System Account OwnerContent Hello Everyone, We've updated a few reports back in October/2020, however we can see now the owner as System Account, (as per screens… -
How to remove new Line from a clob column?Hello experts, I am trying to write a report which includes a CLOB column. But in the table there's blank line in every row, and getting an issue in excel output where t… -
User Last Login Date ReportSummary Need to report on User Last Login DateContent Hi All, I am looking for a way on how can I report for User Last Login Date using BI Publisher. I tried using the F…User_2025-02-04-07-19-57-588 10.9K views 32 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Is a report available that lists the sources use in Projects subledger account rules and conditions?Summary: Is a report available listing the sources which can be used in Projects account rules and conditions? I need to add a condition on the cost center segment based…Chris van de Graaf Perth WA 21 views 2 comments 0 points Most recent by Chris van de Graaf Perth WA Project Management -
PO Change Order Amount Changed column detailsSummary PO Change Order Amount Changed column detailsContent Hi Friends, Can you please help me to get Amount Changed column details when PO Change Order action performe…
-
FCCS Report with Prompt is not opening in Smart ViewSummary: Based on business requirement, we have created a period comparative reporting using "Reports" in FCCS. To meet requirement, we are using current POV and Prompt … -
How to have a report send email that report is ready to be viewed in checklist?Summary: We would like to have a report send notification that the report is ready to be viewed in checklist. But, we do not wish to attach the report output to that ema… -
Chetana Pawar 811 views 2 comments 0 points Most recent by Maheswar Reddy Reporting and Analytics for HCM -
OTBI Added formula column and filter stopped workingSummary: I added a column from the Subject Area Recruiting - Recruiting Events Real Time of: CASE WHEN "Recruiting - Recruiting Events Real Time"."Job Requisition Histor…Kristin Montoya TWU 21 views 4 comments 0 points Most recent by Kristin Montoya TWU Reporting and Analytics for HCM -
Case Statement error on Task Completion DateSummary: Hello, I need help to check if this case statement is correct. My case is if the "Step Completion Status" is 'Completed', it returns the "Step Completion Date";… -
Reporting the Alias of an Attribute Member (possibly using MemberProperty?)Summary: Hi. We are developing a report that uses the MemberProperty function to display the attribute of a particular base dimension member. The report has the base dim…Peter Doyle - Equator EPM 91 views 5 comments 0 points Most recent by Dave Roberts_-Oracle Narrative Reporting -
Query or Table for Budgetary Control Settings under Manage Financial Plan TypesSummary: Hi Team, We need a Query or Table for Budgetary Control Settings to get below fields under Manage Financial Plan Types. Content (please ensure you mask any conf… -
OTBI Element Type Setup report with Costing not showing data if the element is not costedSummary: Hello. I'm trying to report on Element Type Setup with Costing details on OTBI using the "payroll - element enteries history real time" subject area. The report…Laura_Stewart_Sita 31 views 4 comments 0 points Most recent by Laura_Stewart_Sita Reporting and Analytics for HCM -
Report TabSummary: In Reports, can you create reports that have separate reports within one report as tabs? Content (please ensure you mask any confidential information): Version …Greg Hull 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Performance tile is showing an error when I'm in edit view but working when added to compound layoutSummary: I'm experiencing an issue where I have a few different Performance Tiles to highlight active, completed and total courses within the 'Learning Records Real Time…Stephanie McInnes 53 views 5 comments 0 points Most recent by Stephanie McInnes Reporting and Analytics for HCM -
Learning items with learning outcomes assigned are not displayedLearning items with learning outcomes assigned are not displayed. In the front we can see data according to this but not in OTBI. Using the "Workforce Learning - Learnin…User_DA2EL 11 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
Report to identify Users when Clicked on Learning Tile under My Client GroupsSummary: Report to identify Users when Clicked on Learning Tile under My Client Groups Content (please ensure you mask any confidential information): I am looking to see…Thulasi Ram 12 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
Is there a function to get the display name from the username?Summary: Content (required): I'm looking for a function where you can pass the username and get the display name returned? I know I can do a query to the per_users table…CraigP 651 views 5 comments 0 points Most recent by Shivendra Kumar-Oracle Reporting and Analytics for ERP -
Close Accounting Period Exceptions for range of periodsSummary: Can we submit the Close Accounting Period Exceptions for a range of periods? Content (please ensure you mask any confidential information): working 24D it only … -
We would like PowerPoint output format enabled for Reports and BooksSummary: We are not using report packages because we find the process including approvals too cumbersome. We use a manual process to export reports to Excel first and th… -
Through Report is it possible to allow multiple selection of POV elements?Hi all, I'd need to understand if through Reports it's possible to allow multiple selection for the same dimension in POV? Thanks, Cinzia -
Is it possible to access the audit logs of selects placed on certain tables via Oracle cloud?Hi, I need the logs of some tables that are important for confidentiality. Is there a table on BI Publisher that contains the details of who ran it and when it was run i…Cansel Karasoy 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Tables for Archive Transaction detailsSummary Need tables for extracting details from transaction consoleContent Hi Team, There's a report requirement to extract previous years transaction details from trans…User_2025-02-04-13-27-19-123 789 views 3 comments 0 points Most recent by Ankit 10 Reporting and Analytics for HCM -
How to get completion record for learning activities under course and offering?Summary: Hello, I'm trying to create a report for completion of activities. Can anyone point me where to find from the Workforce Learning - Learning Records Real Time su… -
How to download pdf report in oracle apex?Summary: There is a provision to upload report layout and report queries in shared components in Oracle Apex application . We need a alternate method to call that report…Ajay Penkey 41 views 4 comments 0 points Most recent by Sylvain Martel Reporting and Analytics for ERP