Category 129
Discussion List
-
How to populate Period dynamically as 'Feb-2024' from sysdate while scheduling BIP reportSummary: How to populate Period dynamically as 'Feb-2024' from sysdate while scheduling BIP report Content (please ensure you mask any confidential information): Version…ManishKr 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle BI Publisher Learning Center -
Print Receivable Transactions Report Custom templateSummary: Print Receivable Transactions Report Custom template Content (please ensure you mask any confidential information): Hi All, We customized the Print Receivable T…
-
Currency Conversion in OTBI report from Procurement - Procure to Pay Real time subject areaSummary: We have a custom OTBI report created from Procurement - Procure to Pay Real time subject area. The report currently shows all open POs in different currencies. … -
How to add sequence number & date in BI excel templateHi, I have developed a Data model and attached an Excel template in BI. I am able to generate the data as expected. However; we have a requirement to add a sequence numb…Madhu A 451 views 2 comments 1 point Most recent by Manoj venishetti Reporting and Analytics for ERP
-
Recommendations to generate a delimited output over 5GB in FusionAre there any recommendations to generate a delimited output over 5GB without timeout and going into error using a report in Oracle fusion. Currently we are generating e…Abhilash K - Deloitte USI 11 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for ERP -
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 638 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 33 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 21 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 13 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 11 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 1 view 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 41 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 81 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 61 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 43 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 21 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 21 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 41 views 4 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for ERP
-
Bhavani Rikkula 31 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 11 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 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP