Reports
Discussion List
-
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 38 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 98 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 29 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 50 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 -
Please share SQL to return only employee person type whose termination approvals has been acceptedSummary Please share SQL to return only employee person type whose termination approvals has been acceptedContent Hi All, Please share SQL to return only employee person… -
Absence Management | Hours Worked Year to DateContent Hi all, I have a request to create a report that shows hours worked year to date. Is there a specific subject area that I should be referencing? We do have the A…Tristan Aquino 20 views 2 comments 0 points Most recent by Tristan Aquino Reporting and Analytics for HCM -
Duplicate lines in OSHA 300 when an employee transfers to a new job/positionSummary Duplicate lines in OSHA 300 when an employee transfers to a new job/positionContent We are working through some issues where an employee has two rows within the …Andrew_Schmitz 18 views 1 comment 0 points Most recent by Glen Walton-Oracle Reporting and Analytics for HCM -
Report showing rows with all columns suppressedContent Hello All, Please note that we have a report which shows rows though all the columns are suppresses which is not expected. Please review and confirm. Thanks, San…Sandeep Hardikar N S 48 views 3 comments 0 points Most recent by Sandeep Hardikar N S Narrative Reporting -
Why there is a delay in data loading for BI reports in fusion?Content Hi all,I found that some of the customs made BI reports in the fusion by me, has a delay in displaying data when a transaction or any change is done in the syste…Sushan Peiris 360 views 3 comments 2 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Post report Completion event for External SystemsSummary Post report Completion event for External SystemsContent Hi, There is a scenario wherein client needs an event once the report is completed successfully, an even…Kaushal Gathani 19 views 2 comments 1 point Most recent by User_3EZDP Reporting and Analytics for ERP -
Export to Excel in new Reporting area of PlanningSummary Export to Excel in new Reporting area of PlanningContent Does anyone know when we will be able to export to Excel reports from the new Reporting area in Planning…User_2025-02-01-06-21-55-603 31 views 5 comments 1 point Most recent by User_2025-02-01-06-21-55-603 Planning -
COA Segment Values based on Security RulesSummary COA Segment Values based on Security RulesContent We have a requirement to filter BI Report PARAMETER for COA Segment Values based on the security rules defined …Vinay Gharge 35 views 0 comments 1 point Most recent by Vinay Gharge Reporting and Analytics for ERP -
commonly used HCM tables in fusionContent Hi, Any body has commonly used HCM tables in fusion, Please let me know. Regards, ReddykrishnaReddykrishna Chidella-Oracle 46 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Management Reports in ExcelContent Hi, We have a requirement to download the Management Reports in Excel. I have migrated the financial reports to management reports but unable to download them in… -
NEW HIRE(FAST,PRESENT,FUTURE DATED EMPLOYEES) ANNOUNCEMENTSummary Developed BIP Report on ORACLE FUSION HCM we are getting data for current hire employees only, Unable to get future dated employeesContent Hi ALL, I have develop…