Reporting and Analytics
Discussion List
-
how to pass dynamic input values in BIP REPORTDear Team, Pls provide me the list of steps to pass dynamic input parameter in BIP report, We are trying to achieve hyper link as a drill down report, hence we need your…Sabyasachi Mishra 19 views 1 comment 0 points Most recent by Sabyasachi Mishra Reporting & Analytics for Fusion Service
-
How I can fetch licence details, which stored against employee’s job profile?if employee has multiple assignments, and I want to get licence detail of assignment then how I can fetch by using sql. I wrote the sql query to fetch all licences which…
-
SQL Query for Data Model objects from OTBISummary: I am looking to perform a SQL query of Data Models from within OTBI and need to know which table to query. Content (please ensure you mask any confidential info…Alexinmn 32 views 2 comments 0 points Most recent by Ilmars K. Reporting & Analytics for Fusion Service
-
How can we join CST_INV_TRANSACTIONS table to GL tables in Oracle Fusion?I am having difficulty in getting GL information from the cst_inv_transactions table, is there any way to join these?
-
Equivalent Oracle Cloud table columns for the EBS HZ entitiesSummary: Could you please help us to provide the equivalent Oracle Cloud table columns for the below EBS HZ entities? EBS Table Name - Column Name HZ_PARTIES - CUSTOMER_…Nagendrababu Kanuru 37 views 2 comments 0 points Most recent by Swapnil Kashid Reporting & Analytics for Fusion Service
-
List of data Masked/Obfuscated during P2T refreshWe need the entire list of data masked/obfuscated in Oracle Financials cloud during P2T refresh to share with customer to identify the masked/obfuscated data in the shar…AbdulBasith 19 views 1 comment 0 points Most recent by Will Paddock -Support-Oracle Reporting & Analytics for Fusion Service
-
How to fetch the time period for fetching the salary details of the employeesSummary: I am working on a query to fetch the period name as per the payroll name selected from the LOV as parameter to fetch the salary details of the employees . I am …Tuhinaa Nanda 21 views 3 comments 0 points Most recent by Will Paddock -Support-Oracle Reporting & Analytics for Fusion Service
-
Can we display the count in the graph while creating dashboard?Hi Team, I was trying to create a dashboard so what happening is if u out the cursor in the graph the counts are coming. So is it possible to display the counts in the t…Abhisek Kanungo 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
COMPILED_VALUE_ATTRIBUTES field in table fnd_flex_valuesHi Guys Does anyone please have a list of what each attribute is in the COMPILED_VALUE_ATTRIBUTES field in table fnd_flex_values? Data Source : ApplicationDB_FSCM E.G. C…
-
Prompt variable in SOAP executeXMLQuery requestWe have a report on which i have added a prompt variable to filter based on the email address. This works in the report itself: But when i try to get the report data usi…
-
I need a sql report to pull employees who has changes with there department on specific yearHello Experts, do you have some reports that will pull the data of an employee who has changes with their department, Much appreciate to someone will share Thanks,Joliver Caangay 12 views 0 comments 0 points Started by Joliver Caangay Reporting & Analytics for Fusion Service
-
invoice_id is blank in ap_trial_balances_gt tableHello All, We have a requirement to create a custom Payables Trial Balance Report by copying and customizing the data model to add more columns from ap_invoices_all tabl…DebasmitaDas123 24 views 0 comments 0 points Started by DebasmitaDas123 Reporting & Analytics for Fusion Service
-
How to get the Error Details of the Import Auto Invoice Execution Report through queryI am trying to create the join to abstract the Data from the tables used in the Auto Invoice Execution Report but not able to extract. Currently Using same Tables used i…Mohit.Chandna 41 views 1 comment 0 points Most recent by Jesús Vega-Oracle Receivables & Collections
-
roles or privileges to enable a user to create Data Model via the Fusion OTBI web servicesSummary: I'm new to Oracle Fusion Cloud. We have a Service Account that we intend to use to create a Data Model in the Fusion reporting module (called OTBI that's bundle…Dinesh T 35 views 1 comment 0 points Most recent by Swapnil Kashid Reporting & Analytics for Fusion Service
-
Bold letters are not showing in PDF OutputHi , We are facing an issue while generating PDF outputs for BI Publisher (BIP) reports. When the PDF output is generated using the RTF template, the bold letters in the…
-
How to Resync Arabic Hijrah Calendar in Oracle FusionWe are experiencing discrepancies in the dates within Oracle Fusion, specifically with the 'Arabic Hijrah calendar'. leading to issues with reports using Hijri Date. The…KirolosMagdy 50 views 1 comment 0 points Most recent by Will Paddock -Support-Oracle Reporting & Analytics for Fusion Service
-
I am creating a data extraction query, but cannot fetch rule name and to link to discount list.Would appreciate help if you could provide the table name and the respective join for this.Sumit_Rautela 12 views 0 comments 0 points Started by Sumit_Rautela Reporting & Analytics for Fusion Service
-
performance tile DescriptionSummary: When we drag the mouse above some graphs we can see the analysis name description with more information. We would like to know how can we enable this feature to…
-
SQL Query to get the details of the Roles and its inherited rolesSummary: Hi Fellow Developers, We have a requirement to create a BIP report to fetch the details of the Roles and its inherited roles. I tried using the "ASE_ROLE_VL" bu…Dhilip Kumar P. 324 views 11 comments 1 point Most recent by Jun Ye-Support-Oracle Applications Security
-
Report to fetch employees that have not setup goalsHi, Does anyone have below- Report to fetch employees that have not setup goals (100% weight enforcement) for the goal plan applicable for current review period.Shyam Rajbhar 11 views 2 comments 0 points Most recent by Shyam Rajbhar Reporting and Analytics for HCM
-
Foreign key Column & Foreign Table for GL_JE_ACTION_LOG table using HISTORY_IDWe are not able to find the join for GL_JE_ACTION_LOG using HISTORY_ID field. I can able to see in Oracle Docs that HISTORY_ID is the Unique Identifier assigned to user …SumeetVerma 13 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
FDI impact on SaaS Performance?Summary: FDI has been set up to do additional reporting. We´re worried about how it can impact on SaaS performance. Content (please ensure you mask any confidential info…DIEGO CT 58 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
sql query to get person payment amount typeSummary: sql query to get person payment amount type Content (please ensure you mask any confidential information): Version (include the version you are using, if applic…
-
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 33 views 2 comments 0 points Most recent by Sumit_Rautela Reporting & Analytics for Fusion Service
-
Is it possible in one report Bursting and ad hoc running possibleIs it possible to create one report where Bursting setup will ensure that the report is distributed to the correct recipients as specified, whenever it is run on an ad h…Sangeetarani Padhi 31 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
Printing the pdf Attachment in Oracle fusion BIP report output.Hello All , I have a pdf file added in the attachment at Sales order line item level. I would like to extract the attached pdf contents from the server and print it alon…Nupur Thakur 198 views 2 comments 2 points Most recent by Sandeep S. Chauhan-Oracle Order Management
-
How to prevent users from editing and deleting Custom ReportsSummary: We have seen many instances of users deleting custom reports from the Custom Folders, inadvertently. We then had to restore those reports from backups from lowe…
-
RTF Template output alignment issue with Outlook appHi Team, We have recently created a welcome letter using an RTF template, which includes a logo at the top followed by the details in the email body. When we check the o…Rakesh Bahadur Thapa 31 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Need to hide a sheet when no Data Exists in Excel Mutilsheet Excel Template ReportHello I created a Data Model with multiple data sheets in Oracle Cloud BI. I have also created a multisheet Excel Template. The template is working fine but i want to hi…Bobba Anil 47 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service