Reports
Discussion List
-
Dynamic Time Series: month to dateSummary: Hi All, I'm trying to make use of the Dynamic Time Series feature in FCCS in order to create a month to date option in a report. However, although I have adjust…DylanPauwels 21 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Editing PersonHeader subtemplateHello. I'm trying to customize the PersonHeader subtemplate and is already in the Shared Folders/Custom/Human Capital Management/ Workflow Notifications. But when I chan…Maria Cristina L. San Jose 61 views 2 comments 0 points Most recent by Luis Villagomez - IMMI Reporting and Analytics for HCM -
Custom Role to Run FRS Reports in OTBIHello, Is there a custom ERP Self Service role that can be created to allow users to be able to view and run FRS reports in OTBI? Or does it have to be a full ERP licens…Erik Nicholson1234 11 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
Absence Calendar Direct Reports Current Month not returning any valueHi Experts, When we are running the report "Absence Calendar Direct Reports Current Month" from Line manager Dashboard, It is coming as empty. I have checked then backen…Nivya Mathire 91 views 8 comments 0 points Most recent by Gunasagar Thimmapuram-Oracle Reporting and Analytics for HCM -
Query to get all approval transactions pending with terminated line managersSummary: How to get all approval transactions pending with terminated line mangers. I need a query to get all details including approver's person number/username. Conten…Smitashree Pradhan 401 views 3 comments 0 points Most recent by Aditya Jena Reporting and Analytics for HCM -
Payables Trial Balance ReportSummary: I've set up a role so GL Users can run this report but when they do it errors with a permissions issue. Is it right only Payables Managers can run this report, …JohnG 31 views 3 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Employee Location not visible in custom report output for certain usersSummary: We have created a program that extracts all the posted journals for a set of accounts. In our implementation, Employees are stored as parties for making payment…Anand Balasubramanian 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Added new Parent for existing members.Will we be able to get the data by default?We have added a new parent for the existing members in the Entity Hierarchy. We are looking for a way to get the data under the new parent by other than running Consolid…Shilpa Char 23 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Can we burst XPT templateSummary: We have an Report created with XPT template (Normal report creation). Can we use this template and burst the report in excel format? Content (please ensure you … -
group & roleAssignmentAuditReportSummary: Hi, As the User Administration Tasks have been removed from audit, we are using roleAssignmentAuditReport and groupAssignmentAuditReport to gather the appropria…Alyssa Longo 1 view 2 comments 0 points Most recent by Vinay Gupta-Oracle Financial Consolidation and Close -
R13 How to generate a Trial Balance Report from OTBISummary R13 How to generate a Trial Balance from OTBContent R13 How to generate a Trial Balance from OTBIHello : I was wondering if you can share with me any document ho…gabriel kinovisques-163562 408 views 9 comments 0 points Most recent by Sachi Patel Reporting and Analytics for ERP -
Report Repository DistributionMy company uses the report repository to send out batch reports to individual email addresses. We have a number of distribution lists that we need to manually update. Ha… -
How to convert RTF template file from LF to CRLFSummary: Convert file from LF to CRLF Content (please ensure you mask any confidential information): I would like to ask on how to use the CRLF in RTF Template. Is it li…MayCab 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Balance trending reportWe have developed a Balance trending report for current & previous check dates. When we are running for a particular employee we are able to see data within 2 seconds, W…JanardhanP 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
User All Login Details within a specific periodHello Experts, Below query provides information on Last Login Date. For example, a user last logged in 1st Nov, this query will provide Last Login Details. However, is i…ImSt2509 112 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Payroll - Element Entries Real Time SA not returning car allowance Elements in the reportSummary: I have created an OTBI report with car allowance element entries for two Business units by using "Payroll - Element Entries Real time" subject area, each BU hav…Hitachi ServiceDesk 11 views 0 comments 0 points Most recent by Hitachi ServiceDesk Reporting and Analytics for HCM -
Knowledge Search Efficacy DashboardKnowledge Search Efficacy Dashboard; I would like to know exact information since the details are not present in oracle docs. a. # of Clicks b.# of Searches with Clicks … -
How to use outer join in OTBI AnalysisContent Hi All, I am using Worker Assignment Real Time Subject area and i have to pull only the person who has home phone number . The person who don't have home phone n…User_2025-02-04-18-22-33-673 1.6K views 5 comments 1 point Most recent by RajaPalli Reporting and Analytics for HCM -
SQL Query to fetch value set details with respect to modulSummary: Hi All, I want to fetch the value set details with respect to module, can anyone help me with table name or query? Version (include the version you are using, i…ShawShankk 411 views 1 comment 0 points Most recent by Deepak Deenadayalan Reporting and Analytics for HCM -
Need to Burst a Report with Multiple DepartmentsSummary: I need the Sales dept report and the Operations dept report to go to two different groups of emails. Content (please ensure you mask any confidential informatio… -
Write-back errorSummary: Write-back error - An error occurred while writing to the server. Please check to make sure you have entered appropriate values. Content (please ensure you mask…AM HRE 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Query to fetch the individual Manager Rating and Employee rating corresponding to each Goal.Summary: I am creating a custom report to get the employee and manager ratings for each performance goal. I got the summary ratings from table 'HRA_EVAL_RATINGS'. But fo…Rahul K-Oracle 1.2K views 2 comments 0 points Most recent by Jean Vishal Reporting and Analytics for HCM -
Scheduled Jobs running for more than 2 daysSummary: Hi , In Explore Repository → Batch Schedular , One of the job that is scheduled for daily is still in running status since past few days . Even today the job is… -
Can we customize 'Yearly Withholding Tax Report for Italy' report ?Summary: There are 2 requirements as below To add a period parameter 2. To add a new field on the report (The report uses a global temporary table, so how to know inform…Ankit Parikh 11 views 1 comment 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP