Category 129
Discussion List
-
Query to fetch accounting period on project cost page in fusionSummary: Query to fetch accounting period on project cost page in fusion Content (please ensure you mask any confidential information): Hi Team, I am looking for query /…Nidhi Chhajed 679 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Excel output with Multiple sheets with hyperlink for cross-sheet reference BI Publisher ReportSummary: Hi , I have a specific query regarding the feasibility of a dynamic feature: Is it possible to enable a function in BIP's RTF/Excel template where, upon clickin…Sanmati Patil-Oracle 35 views 1 comment 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
OTBI scheduled reports are not getting sent to recipientsReports are not getting delivered. Sometimes its just sending email notification but email doesn't stay in mailbox, it gets disappeared.Adeeba Akbar 23 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Date format issue in RTF formatSummary: We're trying to pass the date period filter criteria to the RTF template as MMM-YYYY, but it keeps coming our as a five digit number. Documentation reflects tha…Jason Parker 16 views 1 comment 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
How to create a BIP Report in excel with a drill down option?Summary: I would like to create a BIP Report of the list of the BPAs. Click on BPA I would extract the list of the POs linked, click on PO I would extract the lines and …Giuseppe Galluzzo 18 views 2 comments 0 points Most recent by Giuseppe Galluzzo Reporting and Analytics for ERP
-
Client requesting data to be not split into multiple sheets in excel or rtf templateSummary: Our client is requesting that the output does not be split into different sheets if the count of records are more than 65K in Excel and 1M in RTF while generati…Abhilash K - Deloitte USI 4 views 0 comments 0 points Started by Abhilash K - Deloitte USI BI Publisher Learning Center -
Is there an excel template based report delivered by Oracle in FusionHas Oracle created any report with excel template inside Fusion Applications?Abhilash K - Deloitte USI 2 views 0 comments 0 points Started by Abhilash K - Deloitte USI BI Publisher Learning Center
-
Unable to see the Goal Plan Approval status in the Employee Goal Plan OTBI ReportUnable to see the Goal Plan Approval status in the Employee Goal Plan OTBI Report. Only the 'Approved' status is displayed under the 'Approval' Status Column. The Subjec…Chaitanya Sai 46 views 1 comment 1 point Most recent by Jacqueline GRANDIN Reporting and Analytics for ERP
-
Custom report using BIPSummary: Can BIP be still used for custom report creation in ERP cloud. Should BICC be leveraged for custom reports? Content (please ensure you mask any confidential inf…Sajeena 86 views 8 comments 0 points Most recent by Hitesh Jasuja-Oracle Reporting and Analytics for ERP
-
Scheduled process listWe would like to know the list of ESS jobs are scheduled with start date, end date and email address of users. Oracle suggested to get the time using Oracle customer con…
-
Table name for auto provisioning data access setsWe have configured data provisioning rules for data access sets. While trying to download all the auto configured data sets rules, its downloads only 10% of the rules an…Vijay Ramani VJ 71 views 3 comments 0 points Most recent by lsriramakumar Reporting and Analytics for ERP -
CASE WHEN Formula Not Displaying CorrectlySummary: CASE WHEN STATEMENT shows two different results pending the format export Content (required): I'm using the following CASE WHEN statement to label a value eithe…
-
Need to find Parameter details which is used while running report in Audit TablesHi Team, I am trying to build an audit report for BI Reports but I am unable to get the column for parameters in the audit tables. Can you please confirm if this is stor…Shubham Khandelwal - Accenture 47 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Downloading ESS Jobs using OIC IntegrationI was working on an integration in OIC that is supposed to allow me to download attachments in an ESS Job in EJKO by sending those attachments as a zip file to my email.…
-
Issues running csv reports after 24A updateSummary: After 24A update, reports built using analysis can't be run, created, or edited. Workaround is to create new data set based uopn the SQL from original analysis,…
-
Need a Solution to restrict Parameters with respect to a Date RangeSummary: In the specified business scenario, users are restricted from selecting dates in the "GL Journal Date From" parameter between the 1st day of the month at 12:00 …
-
Ramya Dev 25 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for ERP
-
-
FA Asset NVB report output languageSummary: I want to download FA Asset NVB report in Chinese, but it came out in English. How can I change the language even though my preference setting prefers English a…User_2025-03-07-20-11-21-245 25 views 1 comment 0 points Most recent by Shawna Green-Support-Oracle Assets
-
Pros/Cons of creating an ESS job for a custom bi report versus not create a ESS job?Hi Community, Are there any advantages or disadvantages for creating an ESS job for a newly created custom bi report versus not creating a ESS job for it?Abhilash K - Deloitte USI 60 views 4 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for ERP
-
Bhavani Rikkula 33 views 2 comments 2 points Most recent by Nagaraju Upputuri Reporting and Analytics for ERP
-
Is there a way to identify deleted journals so that we can exclude them from reporting?Summary: Is there a way to identify deleted journal entries so that we can exclude them from reporting? Content (please ensure you mask any confidential information): We… -
List for all OTBI subject areas/dimensions (as of 23C)Summary: Does anyone have a complete list of all OTBI subject areas/dimensions for creating ad hoc queries? Content (required): Version (include the version you are usin… -
How to hide compatibility checker in Excel while opening excel template based outputs in Fusion?Users are complaining for showing the below message while opening the excel report outputs.How to hide this?Abhilash K - Deloitte USI 14 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
unable to get data for the following fields(Quote Price,RFQ Number,Line Awarded,Lines responded) ?Hi ALL, We have a requirement for the fields(Quote Price,RFQ Number,Line Awarded,Lines responded) in OTBI report. we tried with the following subject area but no date is…Prathyusha pari 13 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Pass BI Results to OTBI Analysis(please ensure you mask any confidential information): Is it possible to pass BI report results to an OTBI dashboard prompt and bind that to an OTBI Analysis column if t…
-
Oracle ERP Cloud - Data Extraction via BICCHi - We are building a cloud data warehouse using data from Oracle SCM Fusion Cloud 22d using Oracle Business Intelligence Cloud Connector (BICC) for data extraction usi…
-
How to exclude weekends and holidays from calculation in OTBI Report?Hi We have a requirement to not include weekends and holidays in calculation for one of the metrics in OTBI report. Kindly suggest some steps to archive Thank you Prathy…Prathyusha pari 16 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Why is barcodes not getting scanned in RF-Smart handheld scanner ?We have modified the standard Print Pick Slip report to add a custom template, type RTF and output PDF, and added barcodes to it with IDAutomationC128S as the font style…Prathyusha pari 94 views 4 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Download the zip file (Authorized Hosted Named Users.zip) does not workSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Manisha Rajupeta 44 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP