Reports
Discussion List
-
Alias in Financial ReportSummary I can't see the aliases on the pov of the report even though I set up it in the user pov. Any reason?Version 11.1.2.4 -
Pass parameter to embedded report in pageSummary Pass person id as parameter to embedded report.Content We need to display some employee information on the Public Info page for any employee. Since personalizati…Varkey George-Oracle 171 views 3 comments 1 point Most recent by User_XHDBT Reporting and Analytics for HCM -
SQL help needed to get the effective start date of employee's assignment status changeSummary SQL help for determining effective start dateContent Hi All, Really hoping someone can help me out. I got really close on my query but I am missing something whe…User_2025-02-04-08-51-08-912 619 views 2 comments 0 points Most recent by User_XHDBT Reporting and Analytics for HCM -
Random Sampling of EmployeesContent I am trying to pull 50% of the employee population at random. Is there a report or formula I can use to pull this information?Riti Malhotra 36 views 13 comments 0 points Most recent by Caleb Pingelton Reporting and Analytics for HCM -
Oracle Cloud Planning Dashboard 2.0 - Waterfall chart and loading timeContent Hi everyone I am trying to build a dashboard by using Dashboard 2.0 function and having an issue here, wondering whether you have had same issue and how to solve… -
Unable to create new infoletSummary In sandbox mode but can’t see create infoletContent Hi, can anyone please direct me to a document in MOS or something here which explains steps to create infolet…Prateek Parasar - GTUK, ACE Pro 109 views 9 comments 0 points Most recent by Shruthi Ramesh Reporting and Analytics for HCM -
Best Practices to load high volume dataSummary Best Practices to load high volume dataContent Hello All,We are working on a project in which we may get high volume data to be loaded through FBDI. Based on you…Lucky Sharma 52 views 3 comments 3 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
Task Manager - Reporting for entered comments and answers within the task functionalitySummary Users add answers to questions and comments in the assigned task. How do I get a quick overview?Content Users are guided through the closing process with the hel…Bjoern Schumacher 37 views 2 comments 0 points Most recent by Bjoern Schumacher Tax Reporting (Direct Tax) -
Reporting TemplatesContent Hello Everyone, Can anyone please share me sources(video links, documents,samples etc) for learning ETEXT, RTF templates that covers right from the very basics.?…Padamatinti Varsha 20 views 4 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM -
HCM Integration Real TimeSummary HCM Integration Real TimeContent Hi Experts, I am trying to build an OTBI report based on "HCM Integration Real Time" subject area to fetch HCM Extract definitio… -
Report Using Procure to Pay Subject AreaSummary A new subject area called “Procure to Pay Real Time” has been added to Procurement’s Oracle Transactional Business Intelligence or OTBI. You can use this subject…Manavalan Ethirajan 1K views 13 comments 14 points Most recent by Surajit Roy-Oracle Reporting and Analytics for ERP -
Procurement - Pending Change Orders Subject area does not correctly reportSummary The Change Order Creation Date is actually the PO Creation DateContent Has anyone else noticed that the "Change Order Creation Date" - a vital field in this subj… -
BIP Report Export Issue for Excel FormatSummary BIP Report Export Issue for Excel FormatContent Hi Experts, BI Publisher Report able to generate in PDF, where as if we try to export in to Excel, getting error …
-
Oracle Fusion Financials - custom version of standard BI Publisher reportSummary Oracle Fusion Financials - custom version of standard BI Publisher reportContent I am following this guide; - https://docs.oracle.com/en/cloud/saas/financials/21…User_2025-02-10-15-12-48-631 39 views 6 comments 2 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
CR/LF values in rtf template issueSummary CR/LF values in rtf template issueContent Hello All, We developed an interface file and this file will be read by mainframe system. I am seeing a strange issue t… -
Need Help with E-textSummary Arabic data getting Jumbled in Etext tempalteContent Hi There, We are having a requirement wherein the data in the database is in Arabic. We are preparing the e-…Sahil_Makhiza 46 views 11 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Report needs to show accruals for current and previous time dimensionsSummary Report needs to show accruals for current and previous time dimensionsContent Experts, Need your help!Could you please let me know if you would use an HCM Extrac…Aloka Bhattacharya 18 views 2 comments 1 point Most recent by Aloka Bhattacharya Reporting and Analytics for HCM -
How to get the only Error message from FAULT_PAYLOAD columnSummary How to get the only Error message from FAULT_PAYLOAD columnContent Hi Experts, Good Day!! We are trying to pull the failed transaction details from transaction c…Charan Kollipara 107 views 5 comments 0 points Most recent by Sandeep19rm Reporting and Analytics for HCM -
How dependent parameter works in OTBI Report, BI Report and DashboardSummary How dependent parameter works in OTBI Report, BI Report and DashboardContent Hi Experts, Can someone explain how the following thing works in OTBI Report, Dashbo… -
'Create' Icon is missing from 'Manage Enterprise Scheduler Job Definitions and Job Sets for Human CaSummary 'Create' Icon is missing from 'Manage Enterprise Scheduler Job Definitions and Job Sets for Human Capital Management and Related Applications'taskContent Hi Team…Rohit Kumar Singh 37 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Sample snapshots of OOTB Reports and AnalyticsContent Hi Everyone, Client need sample snapshots of all OOTB report and analytics, Let me know where can i get all snapshots of OOTB report and analytics. Please let me…Reddykrishna Chidella-Oracle 38 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Unable to search Custom reports using Schedule New ProcessSummary Unable to search Custom reports using Schedule New Process. Reports are not coming in Search resultsContent Hi Team, Reports are not coming in Search results whe…Rohit Kumar Singh 46 views 3 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP -
How to Handle Null or Not Present tags in xml file in BI Publisher?Content Hi all, I have an issue where I'm stuck at making an XML condition for a check print. I used this SQL query for the same condition, and now I want it to be imple…Sushan Peiris 1.1K views 4 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP -
Need a query to get ending balances for current cost,impairment,depreciation for fixed assets for aContent Hi all, Can someone provide me with a query to get ending balances for current cost, impairment, depreciation for fixed assets category wise for a specific perio…Sushan Peiris 188 views 7 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP -
Multiple Dashboards to oneContent I have created 2 separate dashboards one for Headcount and one for Performance Document. I want to now add the performance dashboard as a separate tab on the hea… -
SQL - Job Table historySummary We want to pull all rows from the job code table and have the following SQL. The query pulls several rows for the same effective start date. Any suggestions? Tha…Mike Borghoff 44 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Adding parameters to a deep linkContent Hi, Does anyone have steps or documentation of adding parameters to a deep link to go into a specific person's page/details from an OTBI report? Deep Link - http…Dishti Malhotra-Oracle 155 views 3 comments 2 points Most recent by Liran Reporting and Analytics for HCM