Reporting and Analytics
Discussion List
-
Add the users based on roles in Agent in analyticsHi Team, we are currently adding or removing the users in the agent in analytics individually. Is there a way to add or remove the users based on their resource role in …Haider Saifee 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Filter by age of Lead record in RedwoodSummary: We're trying to add a visualization on our landing page dashboard in Redwood (My Open Leads) that is based on how old the lead is. We tried to use a Group by fi…
-
Is there a way to compare data models?Summary: We have two custom data models that I suspect may not actually have been customized (but they are in the Custom folder). Is there any way to compare a Custom to…Jessamyn Donovan 21 views 3 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Role required to Search for Report JobsSummary: User X (with BI Admin role) is unable to search and view BI report submitted by user Y. Content (please ensure you mask any confidential information): User leil…Shubhojit 51 views 3 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Cloned ESS Job not populating job parametersSummary: Cloned ESS Job not populating job parameters Content (please ensure you mask any confidential information): we cloned a seeded ESS job 'Journal Entry Reserve Le…KDR 117 views 9 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
fetch product image in RTF Template BIP ReportSummary: How to fetch and show the product image in RTF template Content (please ensure you mask any confidential information): We are trying to fetch the product image …
-
Sql to get the item structure for a particular revision in Oracle fusion cloudHi All, Item structure and component details can be extracted from the following tables - egp_components_b , egp_structures_b. Each item has multiple revisions like A,B,…Gurujothi D 563 views 4 comments 3 points Most recent by Hugo Martínez Reporting and Analytics for SCM
-
How to find a contact if logged in through sso or email?Hi, I need to know a contact is logged in using sso or email id. How to find that? Regards, MeeraMeera Saseendran T 31 views 3 comments 0 points Most recent by Nika Gerson Lohman Reporting & Analytics for B2C Service
-
Is it possible to report on the value in the Staff Account Profile Session Timeout field?Summary: Is it possible to report on the value in the Staff Account Profile Session Timeout field? Content (please ensure you mask any confidential information): I need … -
How to create BI report/analysis based on external data?Summary: Is it possible to create report/analysis based on external data, such as an external ERP system? What options does Fusion have for this kind of connection? Is i…Max Prestes 42 views 1 comment 0 points Most recent by Jain Piyush-Oracle Reporting & Analytics for Sales -
How to cancel or terminate all scheduled ESS jobs or BIP reports in bulkSummary:How to cancel or terminate all scheduled ESS jobs or BIP reports in bulk Content : We are reimplementing the Oracle SAS Fusion Financials & Procurements Common M…Singh Rupak 167 views 1 comment 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
When does data move from WFTASKHISTORY to FND_BPM_TASK_HISTORY_B table?Summary: We are no longer able to fetch approvers name in report using FA_FUSION_SOAINFRA.WFTASKHISTORY table. It looks like Approvers information get archived to FND_BP…Chandrashekhar_Cholli 131 views 2 comments 0 points Most recent by Chandrashekhar_Cholli Fusion Applications Administration
-
ESS API to submit job or retrieve job output in non-default formatI am looking for a way to retreive a non-default formatted output for an ESS job through an API. I need to submit the actual parent ESS job that runs the BI report for t…Grant Abbondanza 45 views 5 comments 0 points Most recent by Grant Abbondanza Reporting & Analytics for Fusion Service
-
How to get primary contact details of Partner in SQLSummary: Hi, I am working on partner object to get primary contact details of partner. not possible to get in SQL. Need to get 1.primary Contact Name 2. primary contact …
-
OTBI Succession plan - can't find fieldHello, I am working on an OTBI analysis and I'm having struggle finding some date fields. The subject area I have chosen is Workforce Succession Management - Plan Candid…Sara Suleiman 11 views 2 comments 0 points Most recent by veerendranath pulivarthi-Oracle Fusion Applications Administration
-
Dynamic LOGO in BIP report Oracle fusion is not workingWe are trying to achieve dynamic logo in BIP report according to BU. We have around 25 BU and each of them has its own logo. Approaches tried:- 1) Using subtemplate Whil…Sateesh Kumar 52 views 3 comments 0 points Most recent by Praveen Kumar Ponnusamy Reporting & Analytics for Fusion Service
-
How frequent views are refreshed from actual table, whether generic views rule applicable for fusionSummary: How frequent views are refreshed from actual table. Whether generic views rule applicable for fusion. We should use views or tables for frequent data retrieval …
-
Sales - CRM Resource is showing value of 'not found' in the Hierarchy Level.Summary I had some changes to use the new role as the resource role and with that there is a change in the Organization field. After that, the Sales - CRM Resource which…Cristelle Rose Sampang 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
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…
-
Understand how Oracle is handling Special Characters and Non-english CharactersHello, We want to know how oracle is handling special characters and non-english characters. Also how these special characters and non-english characters are being store…
-
summing up all the columns in a cross tab reportSummary: I want to add the result of all the columns in the pivoted table to a new one, say Total. How do I do that? Content (please ensure you mask any confidential inf…Boby B Jacob 41 views 5 comments 0 points Most recent by James Branston Reporting & Analytics for B2C Service -
Is it possible to create a customer index on Oracle Cloud ERP seeded tables?Summary: We are currently using a BIP report to extract recently created transactions from ra_customer_trx_lines_all, relying on the last_updated_date field. The report …Pradeep Moganti 12 views 2 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
Environment Usage Assessmentへのインプットとなるデータ量を確認する方法Summary: Environment Usage Assessmentのワークシートに記載する情報を環境から取得する方法はありますか？ Content (please ensure you mask any confidential information): Orac…xochiai.Tatsuya3 51 views 1 comment 1 point Most recent by Andrada-Oracle Fusion Applications Administration
-
How to hide headings in Dashboard filtersSummary: I have created a dashboard with 3 reports. While I run the dashboard, I can see few common filters and one filter from 1 report which is not common separetly. S…Meera Saseendran T 71 views 4 comments 0 points Most recent by Ashutosh_86 Reporting & Analytics for B2C Service
-
How to rollback customized PDF templateSummary: How to rollback customized PDF template? Content (please ensure you mask any confidential information): Hi Experts, I got this requirement to rollback the custo…Liwen Chiu 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
what is this 3 lines symbol in report buiSummary: Hi, I could see a 3 lines symbol in the report header for a column, which I didnt see before. Please help me to understand what is this used for? Content (pleas…Meera Saseendran T 31 views 3 comments 0 points Most recent by Meera Saseendran T Reporting & Analytics for B2C Service
-
PDH Item Structure Structure Component audit database tablesSummary: I have a request to develop a custom audit report for PDH Item Structure and Structure Component. I'm looking for the database tables where I can sql data and c…Carlos Benassi 11 views 2 comments 0 points Most recent by Carlos Benassi Reporting and Analytics for SCM -
How to filter category dynamically in search filter when a product filter value changesSummary: Product and Category filter in analytics to behave exactly as they behave in workspace Content (please ensure you mask any confidential information): Hello All,…Rakesh Das 51 views 2 comments 0 points Most recent by Rakesh Das Reporting & Analytics for B2C Service