Reports
Discussion List
-
How to find the customer information from Manage Financial Project SettingsI want to retrieve customer information from Manage Financial Project Settings page. Can anyone help on the query? -
Adding BIP report to OTBI dashboardSummary: I am adding BIP report to OTBI dashboard. The BIP report runs fine individually, but when I add it to a dashboard and preview the dashboard. Nothing shows up. P… -
Third-Party Payment Register Report is blankSummary: After running and generating payment, when I run the Third-Party Payment Register Report it keeps coming blank with this message: This process is in Completed s… -
Smartview Report HsgetValue to retain data when it is openedSummary: Smartview Report HsgetValue to retain data when it is opened by the user who does not have Oracle connection Content (please ensure you mask any confidential in… -
Unable to run reports or view it's dataDears, we have a custom role called profile specialist to handle all the transactions of profile management and it's copied from human resources specialist seeded role t…Nariman.Moussa-Oracle 11 views 2 comments 0 points Most recent by Nariman.Moussa-Oracle Reporting and Analytics for ERP -
How do I convert the field Time.Month from CCYY / MM to just show the month?Summary: The Time.Year fields just displays the year The Time.DayofMonth fields just displays the day The Time.Month field displays the year and month. I need the Time.M…Mark Stoker 61 views 11 comments 0 points Most recent by Mark Stoker Reporting and Analytics for HCM -
Reports: How to share a prompt?Hi, With Reports in PBCS, if I have two grids, how do I share a prompt, so that the user selects a member and it applies to both grids? The member is on the grid. Grid 1… -
Service Account not able to report on FeedbackSummary: We have a service account that we use for reporting purposes in OTBI. Typically, this account is able to pull accurate data across all Business Units. We discov…Megan Obiedzinski 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Requisition Report data not match with fusion job requisition data(attached screenshot)Summary: Requisition Report not match with fusion job requisition Content (please ensure you mask any confidential information): In the below SQL code for requisition co… -
Report on user activities in Oracle Fusion ApplicationsSummary: Report on user activities in Oracle Fusion Applications Content (please ensure you mask any confidential information): Our management is asking for a report tha…JoanB 41 views 5 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting and Analytics for ERP -
Which subject area.column or BIP column is for rate name in benefitsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
How do we add an off-market component to an acquired lease contract?Summary: Client has acquired multiple leases when they acquired another company. They have an off-market component that reduces the Right-of-use for most lease assets. W… -
Custom BIP report for Accounts payable trial balanceSummary: I am developing a Custom BIP report for Accounts payable trial balance. Here the paramters are legal entity, as on date and business unit. When I am trying to p… -
How can we query the error message in BI Server's Report Job History?Summary: Error Log Report that will display the error message like in the Report Job History Content (required): Hi, We wanted to create a custom report that will output…Kristelle 411 views 16 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Identification of missing associations on Calculation CardsSummary: Identification of missing associations on Calculation Cards Content (required): Hello Experts, Can you please suggest if Identification of missing associations … -
otbi calculation only displaying whole numberSummary: Calculation is not showing the correct actual number (incl. decimals) Content (please ensure you mask any confidential information): Hi All Unless I'm doing som… -
Oracle FDI: Predictive Analytics for attritionsSummary: In FAW/FDI , any examples for predictive analytics for exit risk using HR Core subject areas? We see diversity analysis in demos but there is no catalog exists … -
FCCS Report Header in excel export shows as ImageSummary: Hi All, While exporting the report to excel, the header of the report shows as image. We have the requirement to export the report to excel and edit the header … -
Member formula help! get the sum of account that starts with a specific numberSummary: Member formula help! get the sum of account that starts with a specific number Example. get the sum of all the accounts that starts with '1905' Content (please … -
Storing Oracle Fusion report outputs in document management systemSummary: We have a requirement for storing the output of various kinds of daily/weekly/monthly reports (BIP/OTBI/FRS) generated from Fusion ERP Cloud for audit purposes …Anirban Chanda 21 views 0 comments 0 points Most recent by Anirban Chanda Reporting and Analytics for ERP -
Sensitivity Analysis Report - for discount rate and lease period changesSummary: We are implementing lease accounting module and have a requirement to generate sensitivity analysis report for the below: - Sensitivity to discount rate increas… -
Error: This folder is read only. You cannot create a Data Model here.Summary Error: This folder is read only. You cannot create a Data Model here.Content When saving a BI Publisher data model in a particular folder I get this error: This …Ruzwan Akram 481 views 10 comments 0 points Most recent by John Guner Reporting and Analytics for HCM -
Repeat section in RTF and add total on each pageI have the following two tables in an RTF document: The first table displays data from the DM Header. The second table displays data from the DM Lines. The client has re…Elyse Meouchi 11 views 0 comments 0 points Most recent by Elyse Meouchi Reporting and Analytics for HCM -
What is the specific report template to which 'Edit Work Relationship' transaction points ?Could someone please confirm which seeded report template and data model (DM) are being automatically utilized for the 'Edit Work Relationship' transaction? There are tw…Aseem Bhawalkar 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management -
Report required to generate the privileges or roles assigned to seeded reports in Oracle fusionWe are looking for a report or any work around to find what roles or privileges assigned to oracle fusion seeded reports (BIP & OTBI)RajKumar Bachu 1 view 0 comments 0 points Most recent by RajKumar Bachu BI Publisher Learning Center -
Need Descriptive Flex Field to display under Time Periods tab in Payroll DefinitionsContent Customer has a requirement for an additional column called "Payroll Run Complete" to show values as "Yes" or "No". This column would represent the Payroll Proces…Alysia Santana 29 views 3 comments 1 point Most recent by Cloud_Payroll Reporting and Analytics for HCM -
EPM Management Reports to suppress blank page in pdf viewIn EPM Planning, the requirement is to develop report having suppression enabled for missing, zero and error rows/columns that is already enabled at the grid level. The …
-
Report in EPBCSSummary: I want to create a report in EPBCS. I wanted to know if it is possible if I open the file all the members are already drilled down. There should be no expand bu…