Reports
Discussion List
-
Issue with getting a cloud HCM custom Cheque report to run using its custom templateI have created a custom Cheque report, data model and template to process employee pay checks. The problem I am having is finding a way to have the custom report point t… -
How to embed BIP report in OTBI dashboard with Date Prompt/parameter?Summary Provides guidelines for embedding BIP report in an OTBI dashboard and use a date parameterContent Steps: 1. Create dashboard column prompt with a date column and…Anil Kola-Oracle 2.3K views 5 comments 9 points Most recent by User_FCP05 Reporting and Analytics for HCM -
Purge task is missingSummary: We are creating a report to fetch archived and purged tasks details , after purging the checklist , task name are missing . Content (please ensure you mask any … -
Output of 'Import Project Billing Events: Generate Report' in OICSummary: How to get report 'Import Project Billing Events: Generate Report' output in OIC and send it through email/ftp/UCM? I am submitting the Import Project Billing E… -
ANC_PER_ABS_ENTRY_DTLS table is emptySummary Absence entry Detail table not getting populatedContent Hi All When absence entry is created from the UI with basic mode, data is not getting stored in table ANC…Amol Patil HCM-Oracle 853 views 18 comments 0 points Most recent by Mr H Reporting and Analytics for HCM -
Course Completion ReportSummary: Looking for something similar to what we see in the Learners section of a course/transcript. I'm able to build off of completed activities, but when an offering… -
A bip query is running very long timeBelow query is running for a long time in production and eventually timing out when with the filters but without the filter is running and fetching some data. It was wor… -
Can we download the attachments from BPM tables wfattachment?Summary Create hyperlink to download the attachments from BPM table wfattachmentContent Hello Experts, I am trying to generate a report with the approval transactions an…Sricharan Monigari 249 views 7 comments 0 points Most recent by Bisweswar Goud-Oracle Reporting and Analytics for HCM -
Custom Bi report run ess job, i want to export external system. Any size limit.Hi, Currently we are using custom BI report register ESS Job. we want to export data into external system. we are using below Rest api to trigger ESS job and extract dat… -
Capture in BI Report the "Proposed Increase and Decrease in Budget" valueWe have a report requirement to extract in BIP report the "Proposed Increase or Decrease in Budget" value from Project budget version. Upon initial investigation, we hav… -
Is there any table which stores interface error details for PPM Billing Events?PJB_Billing_Events_INT doesn't store any details. Or is there any way to delay the purge of data in this table post Import job runs? I am using it in OIC and need to get… -
Missing users from ASE_USER_LOGIN_INFO tableSummary: Missing users from ASE_USER_LOGIN_INFO table Content (please ensure you mask any confidential information): As far as I know this table stores login information…Stefano_Mazzocca 302 views 4 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
How can I modify existing seeded workflow notification template?Content I have a requirement to modify existing seeded template for Workflow notification(Transfer Report). I have found the template and copied it in custom folder and …User_2025-02-06-14-37-05-233 281 views 6 comments 0 points Most recent by Kotakonda.Balasubramanyam-Oracle Reporting and Analytics for HCM -
how to fix #VALUE! error in excel templateSummary: i am using DATEVALUE function to convert text to date in excel template.However incase of blank date i an getting #VALUE!. Can anyone please help to reslve the …minati_behera-Oracle 14 views 3 comments 0 points Most recent by MJ_ Reporting and Analytics for HCM -
Need to display all workflow completed transactions as well as approver detailsSummary: Need to display all completed transactions as well as approver details Content (please ensure you mask any confidential information): We have a requirement to d… -
Time card approval history tables in Oracle HCM CloudWhat are the table names that store approval information for Time and Labor? Looking for timecard approvers names, dates and times as well as the status of the timecard. -
Customization of Standard Contract Preview ReportSummary: Hi Team, I am writing to request guidance on a customization for the Standard Contract Preview Report(Enterprise Contracts --> Contract Printing --> Contract Pr…Saumya Mani Tripathi-Oracle 71 views 2 comments 0 points Most recent by Saumya Mani Tripathi-Oracle Reporting and Analytics for ERP -
How to fetch a BIP based extract to source Approver1, Approver2 details based on Transaction SummaryThe management has requested for Approver1 and Approver2 details for all the transactions for Process name "Approve Job Requisition" within Oracle fusion. We could not f…Aashish Choyal 21 views 5 comments 0 points Most recent by Aashish Choyal Reporting and Analytics for HCM -
Can AI be used to create reports?Summary: We have ~170 Reports to develop for Oracle EPM Applications in Narrative Reporting. We are looking for opportunities to minimize the development time of Oracle … -
Fetch Request a Position Change Details - Table/XML/TableHi Would someone be able to point to me which table and fields circled in my attachment exist? I am looking to build a report that captures all the details submitted whe…Jose Guerra 11 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Why is Print Receivables Transactions ESS Job picking up seeded template?We have customized the seeded report. The Seeded report can be found under 'Shared Folders/Financials/Receivables/Bill Presentment'. The report name is "Invoice Print Te… -
We want to create a BIP report for the Approval Delegations.Oracle has a delivered report, Employee Vacation and Delegation Rules Report. We need to know the tables behind this report so we can add more fields to the report. Does… -
Additional blank rows showing up in the Planning Report (Next Gen Report) once exported to ExcelSummary: We have created a report named in EPM Cloud Planning and we are getting additional two lines/rows in the beginning of the report when exporting into excel. They… -
Defining a Common Font Placeholder for Approval NotificationsHi Community, We’re currently working on streamlining the design of approval notifications and were wondering—is there a way to define a common placeholder for the font …HarishVummidi 1 view 0 comments 0 points Most recent by HarishVummidi Reporting and Analytics for HCM -
Using Dynamic Hyperlink in Layout Editor (.xpt template)Summary: I have a report using .xpt template / Web layout editor, there is a text Goal Center that I need to convert to a hyperlink so users can go directly to My Team >…Carlo Reyes-59977 91 views 0 comments 0 points Most recent by Carlo Reyes-59977 Reporting and Analytics for HCM -
Access Lease Details Report for BIP Report in Lease AccountingSummary: Hi, From the Lease Accounting Module UI - you can download an .xlsx LDR (Lease Details Report) for each lease (Under Schedules tab for each individual lease). I… -
Is there a way to know who changed Password and when?Summary: We would like to know if there are any tables that store information about users' passwords Content (please ensure you mask any confidential information): Hello…Giuseppe Casalino 111 views 7 comments 0 points Most recent by Giuseppe Casalino Reporting and Analytics for HCM -
Need to understand the functionality and the logic of the smart view reportSummary: We have a requirement to build a custom report which works exactly similar to the smart view report for 15 days cash forecast values. We just need to extend the… -
Fusion BI Report Time zone issues in report output related queriesOur users are in PST Timezone and has raised concerns about report outputs being in UTC Timezone. We are trying to update report code and wanted to clarify few queries b…Abhilash K - Deloitte USI 552 views 8 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP