Category 129
Discussion List
-
Number format in oracle reportHello, when in a report we have #missingData, if i export the report in excel, we have 0 but not in number format. How can fix this, to have always number format? Thanks -
Issue with exporting xls data from several reports for some usersSeveral of our users are facing the issue(see a screenshot below) when they try to extract XLS from several Financial reports (all of them for reports from the EPM works…Ann Djiyanova 11 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform -
Table to view Project Expenses Mass Adjustment Reason and TypeSummary: Which table can I use to get the "Adjustment type" and "Adjustment Reason" for mass adjustments made against Project Expenses. I found the table PJC_TXN_MASS_AD… -
Bold Style is missing for Arabic text in PDF output of rtf templateSummary: We have a check template (.rtf) developed with Payment Date, Payee Name, Payment Amount and Payment Amount in Words . In these fields, Payee name and Payment Am…SireeshaJaladi 1K views 18 comments 1 point Most recent by Lohit Kad-Oracle Reporting and Analytics for ERP
-
Verification of User Login Status in ERP CloudSummary: I would like to know if there is a report in ERP Cloud that shows which users logged in and when. Content (please ensure you mask any confidential information):…
-
OTBI costing receipt accounting subject area -- project number is not populating for transfer ordersI have created an analysis in OTBI using the costing receipt accounting real time subject area. The report is working fine, balances to the general ledger and reflects a…Walter L Gess 1 view 1 comment 0 points Most recent by Walter L Gess Reporting and Analytics for ERP
-
which tables store information about data access set for user?I need to a query to read for each user which BU have access to
-
No data shown for Time and labor under audit reportsSummary: We are trying to setup audit trail for Time and Labor and have enabled it but when we go to audit reports and select all the necessary parameters, still there i…
-
How to creat data set with standard SQL link to PLSQLI need to build a BIP report using RTF as layout The report has header and detail level To generate XML with header / detail , I need to write header and detail SQL in t…
-
Use of custom objects created using application composer for building BIP reportsSummary: We have built couple of reports referencing custom objects created using application composer. We wanted to check if Oracle has any plans in near future to depr…Jepson Erattuparmbil 2 views 0 comments 0 points Started by Jepson Erattuparmbil Reporting and Analytics for ERP
-
Trigger email notification when approver has requested more information on a requisition.Hi All, I'm trying to implement a change where an email notification should be triggered when an approver has requested more information on a requisition. I'm editing ex…Evanshi Vasani 69 views 1 comment 0 points Most recent by Alex Tuteur-Oracle Self Service Procurement
-
Hi, It is possible to send Attachment from AR Invoice Level Using BI Bursting Report from AttachmentHi, It is possible to send Attachment from AR Invoice Level Using BI Bursting Report from Attachment
-
Is it possible to make import output with capitalize letter even original data stored as uppercaseIs it possible that original data is all uppercase but transfer to captalize letter in output report? for example， JIM CHUNG, but in expected output, need to be Jim Chu…
-
Required Tables and column to store the Currency setting details under Manage Financial Plan typesSummary: Hi Team, What are the Tables and columns that store the Currency setting details under Manage Financial Plan types - functionality "Use same conversion attribut…
-
Seeking Innovative Solutions for Stale Dated Check Letter Report in Oracle Fusion ERP CloudSummary: Hi Team, We're developing a report to identify stale dated checks, specifically those exceeding 180 days from their issue date. Our goal is to automate the dail…Abhilash K - Deloitte USI 1 view 2 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
I am unable to join between Project types and class category for the task project typesSummary: Hi Team, Could you please help us to get class category under the classification associated with project types in oracle PPM Module Task Name: Manage Project Ty…
-
LSQL print first valueSummary: Moved to SCM Reporting and analyticsVDM_IM 11 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Can we data mask certain fields within BICCSummary: As Oracle provides BICC as a tool to extract data from Oracle Fusion Cloud through UCM for customers to further analyze or report this data. We have a legal req…Ravi Upadh 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Searching in Reports and Analytics using the magnifying glass icon giving internal server errorSummary: In reports and Analytics, users wanted to search for some related reports and so by using the search option(magnifying glass icon), they entered some options an…P.S.Nikhitha Muduliar 11 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
What reports are available for agent level productivity metrics?Summary: We are looking at agent level productivity metrics. What seeded reports are available in Oracle? Or are these custom created reports? This ask is across all the…VWollin 4 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Excessive delays generating XLS output files from Report books starting mid-March 2025Summary: Excessive delays generating XLS output files from Report books Content (please ensure you mask any confidential information): Starting on March 24, 2025, our re…Sean L. Lydon 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
BIP Scheduler is not working for Monthly jobI have scheduled my BIP report for 1st weekday of every month but it is not triggered. I have attached Screenshot of my schedule. Please Advise. Thank You, Khushi
-
Tax Audit Trail Report export to excel not working properlySummary: Tax Audit Trail Report export to excel not working properly. This started happening in Feb25 after patch. HTML looks ok but when you export to excel it is messe…
-
fdi first valueIn FDI what is the formula to get the first value (or last) for a field that may have multiple values. Instead of displaying multiple rows that show each of the values I…
-
Receivables-Transactions Real time how to add Transaction Line DescriptionSummary: I am trying to create a Dashboard for AR Transaction Listing with Minimal number of fields. The dashboard looks ok until I add Line Description from the Subject…
-
How to capture Tax Classification Code at Supplier Address level in OTBI report.Hello Experts, we want to capture the Tax Classification Code at Supplier Address level using an OTBI report. We are checking on Supplier Real Time subject area. Is ther…
-
Journal Entries And Subledger Details Query HelpSummary: We just implemented Fusion Cloud/Financials so I'm very new trying to figure out the database tables and relationships. I've been tasked with creating a custom …
-
The data extracted from BICC extract is in UTC timezone. Can we change that?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Surekha E PNC 11 views 2 comments 0 points Most recent by Yves_Guyon-Oracle Reporting and Analytics for ERP
-
Our customer needs to identify the report path in OTBI related to an Infolet.Our customer needs to identify the report path in OTBI related to an Infolet. Please see the attached document (Infolet-OTBI.docx and HELP-OTBI-PATH.docx) attached here.…Oscar Chahestian-Oracle 2 views 0 comments 0 points Started by Oscar Chahestian-Oracle Reporting and Analytics for ERP
-
Oracle Fusion BIP Report ESS Job Parameter Error & How to Enable XML and Diagnostic LogsHi Team, I’m facing an issue when scheduling the ESS job — as soon as I select the parameters, it immediately throws an error. The current log doesn't provide enough inf…Ashish1Soni 35 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP