Reporting and Analytics
Discussion List
-
Exporting Report to Data CSV that will used Business View Display Name for Column HeaderSummary: I created a Data Model, in which i update the Business View Display Name as show below However when extracting a report based on this data model in CSV it alway…Dennis AM 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Query for joining inventory transaction tables to costing transaction tablesSummary: I want to join INV_MATERIAL_TXNS table and CST_TRANSACTIONS to get the details of all the inventory transactions including costed transactions with their costin… -
Direct page link/navigation to the Custom object subtabHi All, I have custom object Name: "ParentObject" and this object having child object "ChildObject". I want direct url to open the childObject record… -
How to run territory assignment job with multiple view criteria parametersSummary Multiple view criteria in opportunity territory assignmentContent Hello Experts, While scheduling the territory assignment ESS job, we have requirement to schedu… -
Reporting comments made by candidatesI need to report comments left by the candidates (via Oracle Analytics) who withdrew their application. So far I have tried to filter for the 'Candidate withdrew' Curren…Anna Somogyfoki 11 views 1 comment 0 points Most recent by Dawn C-Support-Oracle Reporting and Analytics Taleo Enterprise -
[EPBCS][Metadata]-Identify Parent become Lev0 member post hierarchy changesSummary: “Is there a way to identify metadata, such as a project’s parent member, where a stored property became a Level 0 member after all its children were moved to an…Muni Kumar Vellure-Oracle 13 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
What is the right query using sql to get the right status of an account (Customer)i need to create a report using data model, in my requirement i need to select only active accounts in analysis it only shows active account but in sql it show all, even… -
Time Gap Between ESS Jobs in Job SetHi Team, I have a Job Set with two ESS Jobs, and I need the second job to start 1 hour after the first one finishes. And also wanted to know what the maximum amount of t… -
BICCSummary: Initial synchronization for large tables using BICC Content (please ensure you mask any confidential information): Our implementation involves several large tab…SunilRamankutty 41 views 2 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration -
How to build a report to show as when a specific report has been run and at which time?**This post was created as part of a How-To Service Request (SR) Summary: I need to report to show as when a specific report has been run and at which time. Version (inc…Priscila Terazawa - Support-Oracle 61 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How to add total in custom reportHi, Like above report, I need to show total in a report. How to do that? Regards, MeeraMeera Saseendran T 21 views 1 comment 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service -
Can we change the PO PDF Report Output name?Summary: Hi All, The requirement is to change the PO PDF report output name. Content (please ensure you mask any confidential information): Version (include the version …Dhilip Kumar P. 56 views 2 comments 0 points Most recent by Tapas_Sathua Reporting and Analytics for SCM -
Reset POV in EPM Narrative ReportingIs it possible to custom code a button into EPM Narrative Reporting that will enable a report user with View access to reset their POV to default on any given report? -
How to optimise a report to improve performance?Summary: We have a report related to Sales order & shipping details, which takes a lot more time than usual to load the parameters & also to fetch the required info even…Rudra_2024 17 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM -
NRCS Roleaudit Report Download using Batch scriptHi All, I have created a batch script to download the RoleAudit report for NRCS. The report downloads successfully when I run the individual commands one by one. However… -
Audit table details for the Sales Business Object details in Oracle fusionSummary: Hi Team, There is a business requirement actually they have created some wrong records in Sales account. They wanted to check the same for which we are trying t… -
Req Approaval TaskWe need to extract data about ReqApproval task configuration for audit purposes. Since there is no schedule process for that, we need to manually prepare the query. We c…Rajinder Singh 21 views 4 comments 0 points Most recent by Rajinder Singh Fusion Applications Administration -
Will the Redwood upgrade will impact our existing Analysis reports and/or DashboardsSummary: Will the Redwood upgrade will impact our existing Analysis reports and/or Dashboards that use Analysis reports? We are trying to schedule and prioritize project…Bill Stearns at Essex Grove Consulting 41 views 4 comments 0 points Most recent by Bill Stearns at Essex Grove Consulting Reporting and Analytics for SCM -
what is the join between GL Journal tables to FND_BPM_TASK_B table.I need to created BIP reportI need to create a BIP report with Journal details ,journal approvers and approval comments .But I tired to join between Journals tables with FND_BPM_TASK_B,fa_fusion_so… -
Item Master ReportSummary Item Master ReportContent Hello, Can you please advise if there is an option or a seeded report in Fusion where we can get a list of all item code with their res…User_2025-02-05-12-20-44-163 220 views 9 comments 0 points Most recent by Chandramouli Potnuru Reporting and Analytics for SCM -
Map-based visualizations in OTBIWe are currently working on Sales Reports in OTBI within the Redwood UX environment, and the customer has requested the ability to include interactive maps within the re…Mira_Emad 29 views 2 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
PVO's not available for MSC_HVGOP_DAILY_AVAIL_REPORT and MSC_HVGOP_WEEKLY_ALLOC_REPORTSummary Seems that there are no PVO's available for the GOP Tables MSC_HVGOP_DAILY_AVAIL_REPORT and MSC_HVGOP_WEEKLY_ALLOC_REPORT which we need to have access to in PaaS…Sridhar G 61 views 1 comment 1 point Most recent by Andrada-Oracle Fusion Applications Administration -
Contact Report PromptsSummary: Criteria When a user launches the Contact Report the default Contact Owner should be based on the user's role (AM see their contacts) When the Regional Manager …Myles S. 31 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How to stop the BIP scheduled reportHi All , Could you please let me know How to stop the BIP Hourly scheduled report. Thanks, NagendraNagendra Chitra-Oracle 32 views 3 comments 0 points Most recent by Pandit Yaashi Reporting & Analytics for Fusion Service -
Need a Oracle Document Link that lists down OOTB Fusion Service ReportsSummary: We need to provide the client a document link which gives a brief of what are the OOTB Fusion Service Reports provided with the product. Looking for a link on d…Anubha Vijayvergiya-Oracle 11 views 4 comments 0 points Most recent by Anubha Vijayvergiya-Oracle Fusion Service -
Report header columns are missing when there is more than 65536 rowsReport header columns are missing when there is more than 65536 rows and the data is splitting into different sheets. The sheet numbers are also going from Sheet1 to She… -
Adjust the sorting of the graph label to show the start of the weekSummary: We need to adjust the sorting of the graph label to show the start of the week i.e. Monday instead of showing Week of the year. Eg. Is the Actual_Start_Date is …svasista 1 view 1 comment 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration -
Unable to query custom data object using SQLSummary: We have two custom objects in Fusion CX Sales, both of them are custom top level objects. However, when I try to pull these two custom object data through creat…