Reports
Discussion List
-
OTBI analysis report output does not show the values selected in the prompts when scheduledHi, I currently have the prompt fields as a Static Text element in the results. Running the report directly shows the selected prompt values normally, but does not appea… -
What is the recommended way to extract item data in bulk from Fusion Cloud(PDH) by External SystemSummary: What is the recommended way for an external system to extract item data in bulk from Oracle Fusion Product Data Hub (PDH) to be used with OIC. Content (please e… -
Working report stopped and throwing an error ORA-01722: invalid numberSummary: I was able to use a custom BI Report a week ago. But it stopped working and throwing an error "ORA-01722: invalid number" when running. I am not sure what is ca… -
How to Trigger Bursting Email to Employee with 2 Attachments Along with Email BodySummary: Hi, We have developed a custom bursting report which has Email body configured in Parameter5 and single pdf attachement is generated based on rtf template. We g…puja suryanarayana 1 view 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
OTBI Report to fetch List of Line ManagersSummary: OTBI Report to fetch a List of Line Managers who have at least one direct report and the direct reports(Employees) should be Salaried. Content (required): For t…Thulasi Ram 481 views 7 comments 0 points Most recent by Aditi Sehgal Reporting and Analytics for HCM -
Use of dynamic URL to run the report on Home page linkWe have created a BIP report and used that URL to create a page link on the Fusion Home page. At present, configured using Static URL on the link and it works fine. The …Vijay Ramani VJ 2K views 10 comments 0 points Most recent by User_QRDCE Reporting and Analytics for HCM -
26.04 Update Feature Audit Changes to Documents and Report ArtifactsSummary: New 26.04 Feature Audit Changes to Documents and Report Artifacts - the audit log does not provide the name of report for which content was modified. Is there s…Lauren Lee 31 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Learning Table Details to fetch Learning Access Group related fields along with access group membersSummary: I have requirement create BIP report to fetch all learning item along with access group related details like Access Group selection method, Access group Run as,…Kamini Kaushik-Oracle 251 views 5 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
oracle cloud hcm bi publisher absences error handling reportHas someone written or found documentation for the steps to write an oracle cloud hcm bi publisher absences error handling report (or similar) that writes error messages… -
What are the different ways we can get consolidated reports for a ledger setSummary: We need to present consolidated reports for our ledger set containing 5 Ledgers. What are the different ways we can get the reports. Content (please ensure you …Rajen 11 views 1 comment 0 points Most recent by Jehosheba Amruthaluri Reporting and Analytics for ERP -
Oracle Fusion Cloud – SQL to Extract Report-Level Permissions for All Reports (BI Publisher, OTBI)Hello Experts, We are working in Oracle Fusion Cloud (SaaS) and need to extract report-level security/permissions for all available reports in the system. Scope includes…Noorul Ariff1986 72 views 2 comments 1 point Most recent by Jehosheba Amruthaluri Reporting and Analytics for ERP -
bursting defSummary: Please confirm if Narrative Reporting can send reports via busting definition to a local directory instead of sending the reports via email? If yes, please sugg… -
Need to make dynamic file name in BIP reportWe have a requirement to place the BIP report to SFTP server , file name should be dynamic as 'Filename_(sysdate-15)_(sysdate-3)'. I tried to make the filename as Filena…Anjali_Kumari4121 204 views 5 comments 0 points Most recent by CharanBochker Reporting and Analytics for HCM -
FCCS custom report to dynamically pull data where an Entity has ICP transactions with itselfIs there a way to create a custom report in FCCS to dynamically pull all such lines where an Entity has ICP transactions with itself ( Intracompany transactions)? We cur…Batul Rangwala 39 views 4 comments 0 points Most recent by GMohan-Oracle Financial Consolidation and Close -
Book Prompts shared across different cubesSummary: Is it possible to link Prompts from Reports within a Book that are within different cubes? Content (please ensure you mask any confidential information): I have… -
Approver Name of a transaction with OTBISummary: Create an OTBI report with Transaction details, the initiator and approver Content (please ensure you mask any confidential information): Hello experts, is it p… -
Bi report changes are not reflecting on ORC offer preview pageSummary: Bi report details with recent changes are not reflecting on candidate's application preview offer Page. Content (please ensure you mask any confidential informa…Muzammil_789 31 views 4 comments 0 points Most recent by Muzammil_789 Reporting and Analytics for HCM -
User Login Activity QuerySummary: We have a contractor and would like to measure his level of effort within our company. Is there an existing query or report that shows how many times a specific…usr_a.nv 64 views 20 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Are Custom Reports Automatically Copied During Prod to Non-Prod Cloning?Summary: During instance cloning from Production to Non-Production in Oracle Fusion, Are custom reports automatically copied, or do they need to be migrated separately? …PRANEETH BHOGADI 11 views 2 comments 0 points Most recent by Dave Roberts_-Oracle Narrative Reporting -
Is View Display Error / Timeout issue related to missing BI Admin role?Summary: Multiple user encounter View Display Error when running Dashboard Report. Most of the reports results with errror. We confirm that they have access in the repor… -
Assignment Changes on Employment HistoryContent Our organization is working to transition to utilizing the Quick Actions verse Person Management. One feature we use is the “view history” and then "export" on t…Kayla Malecki 310 views 14 comments 3 points Most recent by Nathan CCC Reporting and Analytics for HCM -
OTBI Conditionl FormatingI’m facing an issue while building a formula in OTBI (Subject Area: General Ledger - Journals Real Time). Requirement: I want to calculate a value that combines: Journal…Abdulrahman Mostafa 11 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Unable to see triangle after zooming in on a parent memberSummary: I work at Expedia and am trying to run TRCS tax reports from our Library folder. I attempted to expand parent members to view their child members by following t… -
Bursting sending one consolidated email instead of multiple emailsSummary: Needs to send one email to Manager with consolidated notifications of all the employees instead of sending one notification for each employees. Content (please … -
Infolet Section says Refresh to Load after LoginSummary Infolet Section does not load Infolets by DefaultContent We are on 19C and on news feed. I have enabled HCM infolets and infact made couple of infolets. But What…Prateek Parasar - GTUK, ACE Pro 117 views 16 comments 6 points Most recent by User_ORRJ4 Reporting and Analytics for HCM