Reporting and Analytics
Discussion List
-
Is the join operator ( ) deprecated in Oracle fusion SQLIs the join operator (+) deprecated in Oracle fusion SQL. Can we still use (+) in SQLs or shall we go with ANSI standard for eg: left outer join or Right outer joinSrinivas VRA 22 views 3 comments 0 points Most recent by Srinivas VRA Fusion Applications Administration -
Is there a way to request additional indexes to Oracle Fusion seeded tables like?Hello, we have a huge custom datamodel for the invoice print receivables process. After analysing the execution plan (provided by Oracle support for the main dataset) we…Frank.Steinjan 4 views 0 comments 0 points Started by Frank.Steinjan Fusion Applications Administration
-
25D New Column in EGP_SYSTEM_ITEMS_B - Custom Integrations FailingSummary: We are currently reviewing the recent Oracle patch updates in PROD and have encountered an issue that warrants clarification to ensure smooth implementation for…Vignesh Subramanian 7 views 0 comments 0 points Started by Vignesh Subramanian Reporting and Analytics for SCM -
How to add profile creation and queue creation date in reportSummary: Hi community, How we can add profile creation date and queue creation date on reports in Oracle service cloud reports As a first step i have verified that we do…Santosh kumar purusottam 12 views 1 comment 0 points Most recent by Michelle Akin-Support-Oracle Reporting & Analytics for B2C Service
-
Can we give content server document URL access to BIP user without giving content server accessSummary: We are trying to build the report which will give the attachment names So we have created a URL based on content server but now content server cannot be accessi…Prajkta Hire 15 views 0 comments 0 points Started by Prajkta Hire Reporting & Analytics for Fusion Service
-
In FOM. What is the fields names on the DOO_ tables to link a service line with its parent line.I'm trying to match the Service Line with its parent Line. I've created a SQL query in FOM. In my output, the service line is not matching up with its parent line. What …
-
Capture OTBI Report LogsSummary: Hello, We have a setup in which an OTBI report is triggered from Oracle Integration Cloud using SOAP APIs. We are experiencing intermittent issues where the OTB…Support Account 2 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
OTBI Case Statement excludes some of the row from StatementsSummary: After adding Transaction code formula as follows CASE WHEN ("- Line Information"."Statement Line Transaction Code" = '165' AND "- Line Information"."Statement L…Praveen Gopalakrishnan 22 views 2 comments 1 point Most recent by Praveen Gopalakrishnan Reporting and Analytics for ERP -
Customising Sales Order Acknowledgement ReportTrying to customize Sales Order Acknowledgement Report, I have added new fields in the Data model but when I have added the new fields in Template using BI Publisher as …
-
Not Being able to send the Output to a group mail id (DL/NG) white scheduling a report from BIPWhen i schedule a report from the report and analytics screen giving a DL (Distribution list) /NG in the destination mail id the output is not getting delivered . Did an…Sarath C P 14 views 1 comment 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
FscmTopModelAM.FinVrmRRSharedPublicModelAM.PerfObligationLinDistsPVO- Duplicates for primary keyACTUAL BEHAVIOR Running BICC extract to extract information from PVO FscmTopModelAM.FinVrmRRSharedPublicModelAM.PerfObligationLinDistsPVO in BICC. PERFOBLIGATIONLINEDIST…Prabhjeet Kaur 51 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Issue with Tax Amount Display in OTBI Line ItemsSummary: Merge Tax line of receipt Content (please ensure you mask any confidential information): Hi, We need to include the tax amount on a single line. Currently, in O…Muhammad_Saad 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
PO PDF Printing in Supplier Address Language Instead of EnglishThe customer needs the PO PDF to be printed in English; however, it is currently being generated in the language defined at the supplier address. eg. supplier address la…Kinjal Patel-Oracle 11 views 1 comment 2 points Most recent by Ketan Janva-Oracle Reporting & Analytics for Fusion Service
-
Need a table that stores BIP Report Email recipient listHi, Which table stores the BIP Report Email recipient list. Thanks in advance.Kinjal Patel-Oracle 12 views 1 comment 4 points Most recent by Ketan Janva-Oracle Reporting & Analytics for Fusion Service
-
Labor Costing Overrides and Manage Rate Schedule BICC Extract PVOs NeededI am trying to extract Manage Labor Costing Overrides and Manage Rate Schedules Data through Oracle Fusion BICC PVOs. I am unable to find the exact PVOs for this data. P…SAI KRISHNA SANGEM 21 views 2 comments 0 points Most recent by SAI KRISHNA SANGEM Fusion Applications Administration
-
What is this report symbol meaning?Please help me to understand what is this symbol on left of a report name. Regards, MeeraMeera Saseendran T 11 views 3 comments 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service
-
where is almacenes all my data generated in fusion applications?My question is, how can I access all the data generated in my Fusion applications? I want to replicate my OAC instance in Power BI. I have an ADB instance, and I've conn…Víctor Nuno 11 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
How to hide Custom ESS Jobs from the end userSummary: We need to build a solution where we can hide the custom ESS Jobs created for running the integration reports. These jobs should only be accessible to the user …Kunwar Prashan Srivastava 81 views 7 comments 0 points Most recent by User_N4K98 Fusion Applications Administration -
tax invoice print amount in wordstax invoice print amount in words in below the one lakh is showing Forty-One Thousand Nine Hundred Ninety Rupees And Forty Paise***** and above the Two Hundred Seventy-F…
-
Any way to use regex in OTBI?Summary: Is there a way to leverage regex in OTBI in some manner? I have seen methods to leverage it in OBIEE with the following syntax: EVALUATE('regexp_replace("Activi…
-
Change "from" address and seeing recipents on scheduled reportsContent Hi Gurus, I have two questions in schedule report Can we change the from address for the schedule report? Can we see the list of recipient email address in the t…Mohana Gopal S-Oracle 52 views 7 comments 0 points Most recent by Santosh kumar purusottam Reporting & Analytics for B2C Service -
How to extract holiday list ?Hi, Is there any way, we can export holiday list of each SLA? Regards, MeeraMeera Saseendran T 44 views 1 comment 0 points Most recent by George Caragicu-Oracle Reporting & Analytics for B2C Service
-
OTBI Report to pull Opportunity details with team membersSummary: Need an OTBI report on Opportunity and associated team members Content (please ensure you mask any confidential information): How to expose Opty team members de…S.Kumar 71 views 6 comments 0 points Most recent by AMIT KUMAR YADAV Reporting & Analytics for Sales
-
How to pass parameter value from one job to another in ESS job setHi All, We have a ESS job set, input for the second ESS job would be the one of the parameter from the first ESS job. Can you please let us know how we can achieve this …Arunkumar Ponnusamy 155 views 3 comments 0 points Most recent by Ranga Swamy Ediga Reporting and Analytics for SCM
-
ORA-01427: single-row subquery returns more than one rowSummary: Hi All, We encountered the below error in a specific report DM both while running the report and within the DM itself. After identifying and resolving the issue…Abhijit N 31 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Video: Adding an Express Report to the Sales DashboardAdding an Express Report to the Sales Dashboard From the Express Reporting series https://videohub.oracle.com/embed/secure/iframe/entryId/1_hdg0pttk/uiConfId/35965902 -
The report prompt doesn’t appear on the same page when I apply the report filter.Summary: We created a report-level prompt, not a dashboard prompt. We need the prompt and the report to remain on the same page, but when we apply the prompt filter, the…Kanne Ramu 21 views 1 comment 0 points Most recent by RVohra Reporting & Analytics for Fusion Service