Reports
Discussion List
-
How to create custom report for future lease schedules using FLA_ON_DEMAND_SCHEDULES_PKGHi Experts, The future lease schedules data are being deleted from Fusion Tables when attaching the lease detail report and finalizing the lease. Document 2819925.1 Howe… -
Email Address FormulaHi Everyone, I am building a report for one of our HR partners. She is using the report as a file loader to put employee data in an external employee recognition platfor…
-
Facing " There is no data to process" in BIP reportSummary: Facing the error " [INSTANCE_ID=bip.bi_server2] oracle.xdo.servlet.scheduler.ProcessingException: There is no data to process" in BIP report and there is bursti…
-
Combining two Smartlist Accounts into One AccountHello, I am trying to combine two text Accounts(one Smartlist, one open text) into One Account. I have tried doing it in the Member Formula of that Account in Dimensions…
-
How to to enable the selection of POV members when running report package?Summary: I am currently developing a report package in Narrative Reporting and need assistance regarding the configuration of the Point of View (POV). I have dimensions …
-
The shared connection cannot open the reportsHello everyone, I have some reports in PBCS system. Now, I am trying to connect to the report on Excel SmartView via a Shared connection. I remember in the past, I could… -
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 73 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 33 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 Started 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…
-
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…
-
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 724 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 11 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 12 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