Reporting and Analytics
Discussion List
-
Sql to find weekdays between two DB dates in fusionI want the query for Fusion to find weekdays between two dates skip the saturday and sunday and give the subtracted days dates may be have differnce of 1 day or 10 days …Abdur Rehman 31 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Fusion Service -
Nagendra Chitra-Oracle 16 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Fusion Service
-
BIP to burst the file to SFTP Server with 0 KB in case there is no data extractedSummary: We have requirement to burst BIP report output to SFTP server with 0 KB size in case there is no data extracted after data model query being executed. Content (…Hitesh Jasuja-Oracle 41 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Fusion Service
-
EBS to Oracle cloud mapping for below mentioned columns.Summary: Could you please help us to find the correct EBS to Oracle cloud mapping for below mentioned columns. Content (please ensure you mask any confidential informati…Krutika Narayankar 1 view 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
-
EBS to Oracle cloud mapping for below mentioned columns.Summary: Could you please help us to find the correct EBS to Oracle cloud mapping for below mentioned columns. Content (please ensure you mask any confidential informati…Krutika Narayankar 11 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
-
Please help with the database column for 'Exchange Gain Or Loss' in Fusion ReceivablesSummary: Need database column for 'Exchange Gain Or Loss' in Fusion Receivables Content (required): There is a column when managing receipts in Oracle Fusion Receivables…Sharmava 11 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
-
Can I use output from one BI report as input to another BI report?Summary: Content (required): I know that I can create multiple templates for my output, but that would require me to run the data model again. I'm looking for a way to p…Scott Paulin 12 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
-
Need to Stop Showing Business Unit Code in Report HeaderHi All, I have created Report using Oracle FRS and in the report output i need to stop appearing this BU code. Please AdviceNavindu Amarasinghe 11 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service -
Compensation History tables and dataHi All, I am unable to get the Compensation History data using below query. Can you please advise if anyone has the query or table accordingly. SELECT hth.transaction_id…Sai Shyam 11 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Fusion Service
-
BIP report parameter is not working as expectedSummary: Hi All, For BIP report parameters, I have used the below part and it is not working as expected. When a period, CO, and Account parameter is given that time it …AKV27 11 views 1 comment 0 points Most recent by Sandeep19rm Reporting & Analytics for Fusion Service
-
Authentication issueDear All, I am currently utilizing basic authentication (username, password) to invoke a report and retrieve data from Visual Builder through the SOAP API. However, we h…George Mattar 11 views 3 comments 0 points Most recent by Narendra More-Support-Oracle Reporting & Analytics for Fusion Service
-
Problem of report object after convert from FR report and export to ExcelAfter we migrate FR to Reports and export to Excel, 1. All the header and footer objects changed to pictures. 2. For these pictures, the wordings are not very clear and …
-
How do I update the User Distinguished Name?I am working on building a report that references the PER_USERS table in our ERP environment? However, I have noticed that the USER_DISTINGUISHED_NAME column has inconsi…Thomas Loftus 11 views 1 comment 0 points Most recent by Narendra More-Support-Oracle Reporting and Analytics for ERP
-
Learning Completion date of a course under specializationHi All, I am not able to get courses under a specialization to get its completion date. Any help is appreciated? Thanks-Praveen
-
Functions/Query in OTBI report to seperate concatenated segmentsHi, I'm trying to separate the concatenated segments into individual segments. I would like to separate 6 segments. I found a few Oracle documents which have solutions f…Varalakshmi 17 views 1 comment 0 points Most recent by Anand DN-Oracle Reporting & Analytics for Fusion Service -
How to disable Approve Reject from workflow bell icon notification?Proposed Email template & resignation approval process to People Leader: 1. We are requesting to remove the ‘Approve or Reject’ button from the current resignation email…Nagendra Chitra-Oracle 596 views 19 comments 0 points Most recent by Jay.Joshi-Oracle Human Capital Management
-
How to embed BIP Reports in Job Requestion UI pageNeed to add the BIP Report in Job Requestion UI page. Based on the selected Requisition the embedded BIP Report should populate the candidate's details in UI. Kindly let…Anand-ST-Oracle 11 views 0 comments 0 points Started by Anand-ST-Oracle BI Publisher Learning Center
-
Amee Patel 61 views 10 comments 0 points Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM
-
Joining Two Standard Subject AreasHi team, We are joining two subject areas "Costing - Receipt Accounting Real Time" and "Costing - Landed Costs Real Time". Bu not getting data. Can anybody help me under…
-
HIDear Community, Need some advice regarding the ADFDI software.. My company uses the Oracle ADF Desktop Integration Add-in for Excel , We are currently on version 5.1.5.2… -
Data Model not working properly.We are converting the standard report into Customize Report including data model, when we modify the data model it does not effect and don't make changes. We use the gro…Malik_Umer 31 views 2 comments 0 points Most recent by Kalpana NJ-Oracle Reporting & Analytics for Fusion Service
-
Is any currently using NACHA File Format with more than one addenda record?I am trying to implement a NACHA CTX Format for my eText bank file using the US NACHA CCDP template. I have tried other templates as well. The closest I have come is to …Keith Doucet 32 views 0 comments 0 points Started by Keith Doucet Payables, Payments & Cash Management
-
What is the table that stores error records for Depreciation Override of Asset using ADFDI?Hi All, We are using ADFDI to Override the depreciation of Asset. After importing the records we need to generate the error report for failed records. Which table stores…Amritesh Chandra 51 views 4 comments 0 points Most recent by User747350-Oracle Reporting & Analytics for Fusion Service
-
Is there any documentation available in how FAW Custom Schema access/security works?Can someone point me to any documentation on how access/security will work on FAW custom schema. I understand FAW will inherit the Fusion schema for the standard dashboa…VAM 1 view 1 comment 3 points Most recent by Clare Murtagh - new Reporting & Analytics for Fusion Service
-
Oracle BI Catalog ReorganizationWe are planning a reorganisation of the Oracle BI Catalog folder structures and will much appreciate knowing about any standard processes or best practices that are in p…ks1075 14 views 2 comments 1 point Most recent by Clare Murtagh - new Reporting & Analytics for Fusion Service
-
how to display latest message in reportSummary: We are building a Service Request Dashboard , in that want to display the messages also. When we combine the SR subject Area and SR Messages Subject are , it is…Anusha716 21 views 1 comment 0 points Most recent by Clare Murtagh - new Reporting & Analytics for Fusion Service
-
How we can print checks as first page on check stock and overflow pages on second printer in FusionSummary: 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 to make goals dashboard embedded on the goals screen in fusion to take parameters from the goalsCustomer has created OTBI Analysis report based on the Workforce Goals - Goal Status Overview Real Time subject area. A graph has been created based on this analysis. Th…ElTawil 36 views 1 comment 0 points Most recent by Suman Chenumalla-Support-Oracle Reporting & Analytics for Fusion Service
-
Custom Package creation in fusionHi Team, Can anyone explain how to create custom PLSQL packages in Fusion Database Schema? When creating BI Reports for Oracle Fusion SaaS, there is an option to create …
-
How to access your Usage Metrics Drill-Through ReportSummary: Hi, I received an email that says that your usage report can be downloaded from My Services. This info is not clear for me. Kindly assist to access this report.…Ashraf Bilal.R 64 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting & Analytics for Fusion Service