Reports
Discussion List
-
Resource mapping Report: feasibility to append the Job Requisition URL with external Site detailsIs there any feasibility to append the Job Requisition URL with the external site name details for tracking the candidate flow from the source website.(E.G; LinkedIn, In…Suneetha Narisipuram 21 views 2 comments 0 points Most recent by Pandey Roma Reporting and Analytics for HCM -
Geeting issue "business unit is out of report range" in Payable to Ledger Reconciliation reportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Reports folder missing from Planning Apps in SmartViewSummary: Reports folder is missing for users in smartview in our planning apps over the past couple weeks. Potentially aligned with Feb production updates. Am I missing … -
Smartview Essbase Error [1020098]: Duplicate name found in Grid, unable to resolve.Summary: I get the following Smartview error in report that used to work fine, adjusting the Account dimension values fails to resolve the issue, Essbase Error [1020098]…RichardChan 85 views 2 comments 0 points Most recent by Jeelan Banglewale-Oracle Reporting and Analytics for ERP -
Number format in oracle reportHello, when in a report we have #missingData, if i export the report in excel, we have 0 but not in number format. How can fix this, to have always number format? Thanks -
Can superscript text be added to custom row headers in reports?Summary: I see superscript text can be created in text report components which is great for footnotes, but I don't see away to add superscript text to grid rows custom h… -
Difference between two dates with decimal outputSummary: In an OTBI report, the requirement is to calculate years of service for terminated employees (difference between hire and term dates). The output needs to be 2 …JHaden3 31 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
HCM Table to connect payroll run result values to an employee assignmentSummary Need help with finding a table or column which can tell payroll run result values ran for an assignment_idContent Hello Everyone, I am in middle of editing an SQ…GauravGupta39 1.4K views 3 comments 0 points Most recent by Ashraya S.N Reporting and Analytics for HCM -
Restrict the compensation information in reports and analytics.Hi Team, We have a requirement that some set of employees can able to access/view the compensation data in BI and OTBI Analysis reports. E.g: If a user queries the compe… -
Subject area for report to fetch content section of person profile typeSummary: Content (please ensure you mask any confidential information): Hello, We want to fetch all the details inside 'Content Sections' under Profile > Profile type > …Aishwarya_Saju 11 views 0 comments 0 points Most recent by Aishwarya_Saju Reporting and Analytics for HCM -
Prompts are not showing while scheduling the OTBI AnalysisThere are 4 prompts in the Analysis. But when we try to schedule the report, these parameters/prompts dont show up in the General tab. Please suggest.Dona Das-Oracle 52 views 3 comments 0 points Most recent by Jagadeeswara Reddy Reporting and Analytics for HCM -
how to get the retention rate calculationSummary: HI team! Do you know how to calculate the retention rate in an Analysis Report? This is the formula: (Number of employees at the end of the period / Number of e…Claudia Linares L 21 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Analysis report to find all the talent notifications enabled in systemSummary: Content (please ensure you mask any confidential information): Hello, We want to create an analysis report where we get the list of all the enabled and in use n…Aishwarya_Saju 1 view 0 comments 0 points Most recent by Aishwarya_Saju Reporting and Analytics for HCM -
Bold Style is missing for Arabic text in PDF output of rtf templateSummary: We have a check template (.rtf) developed with Payment Date, Payee Name, Payment Amount and Payment Amount in Words . In these fields, Payee name and Payment Am…SireeshaJaladi 1.1K views 18 comments 1 point Most recent by Lohit Kad-Oracle Reporting and Analytics for ERP -
Verification of User Login Status in ERP CloudSummary: I would like to know if there is a report in ERP Cloud that shows which users logged in and when. Content (please ensure you mask any confidential information):… -
which tables store information about data access set for user?I need to a query to read for each user which BU have access to -
No data shown for Time and labor under audit reportsSummary: We are trying to setup audit trail for Time and Labor and have enabled it but when we go to audit reports and select all the necessary parameters, still there i…Mehul Chandra 1 view 0 comments 0 points Most recent by Mehul Chandra Reporting and Analytics for ERP -
Roles required for PER_AVAILABILITY_DETAILS.GET_AVAILABILITY_DETAILSSummary: Hi, We have created a report to get employee calendar, and we are using PER_AVAILABILITY_DETAILS.GET_AVAILABILITY_DETAILS in our query. This is working for us a… -
How to Import a signature and logo in UCM Server and Export a signature and logo in RTF TemplateSummary A requirement is to upload logo in UCM server and access that logo in RTF Template by using Payment Format(Check printing))Content A requirement is to upload log…Arpita Saha-137995 730 views 10 comments 1 point Most recent by User_P8MK7 Reporting and Analytics for ERP -
How to fetch report in hiring tab in redwoodSummary: Content (please ensure you mask any confidential information): Hello, When using the Responsive UI, we were able to add a report (Candidate tracking ) in such a…Aishwarya_Saju 12 views 2 comments 0 points Most recent by Shikha Agarwal Reporting and Analytics for HCM -
Report to fetch all the questionnaire present in systemSummary: Content (please ensure you mask any confidential information): Hello, We want to fetch all the active questionnaires and the items resent in question library, a…Aishwarya_Saju 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How can we have the $ show on the report when the value is zero (zero replaced with Dash)Summary: When cell formatting is being used if positive Prefix "$" and negative prefix "$(" , the report is not showing a $ when the value in the cell is zero (zero repl…Angela Hamann 21 views 2 comments 0 points Most recent by Angela Hamann Financial Consolidation and Close -
Calculate Interest Expense in LDRHello, \ I am trying to calculate interest expense but it does not match the LDR. The reason is number of days used in the calculation. The calculation is done like numb… -
Sample Report Outputs of Seeded Oracle HCM ReportsSummary: Sample Report Outputs of Seeded Oracle HCM Reports Content (required): Where do we get the list of all seeded Oracle HCM Reports and their sample output files? …Mani Venkataraman 71 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
structural details of the admin pages and the EL (Expression Language) components used within themSummary: Is there any way that provide the structural details of the admin pages and the EL (Expression Language) components used within them, specifically focusing on t…Ashish Chawla-277800 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Required Tables and column to store the Currency setting details under Manage Financial Plan typesSummary: Hi Team, What are the Tables and columns that store the Currency setting details under Manage Financial Plan types - functionality "Use same conversion attribut… -
how BIP job that retrieves data from an Oracle Database table containing a BLOB columnWe have a BIP job that retrieves data from an Oracle Database table containing a BLOB column (e.g., storing PDF or image files). For downstream processing and integratio… -
Seeking Innovative Solutions for Stale Dated Check Letter Report in Oracle Fusion ERP CloudSummary: Hi Team, We're developing a report to identify stale dated checks, specifically those exceeding 180 days from their issue date. Our goal is to automate the dail…Abhilash K - Deloitte USI 11 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
I am unable to join between Project types and class category for the task project typesSummary: Hi Team, Could you please help us to get class category under the classification associated with project types in oracle PPM Module Task Name: Manage Project Ty…