To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
BI Publisher Packages in Datamodels for ReportsSummary: In Fusion ERP, several BI Publisher reports use packaged procedures within the data model. For example, the Fixed Assets Reserve Summary and Detail reports refe… -
Can't show Saving column amount in FRSSummary: So we have a question for creating the report via FRS. So there's Total of Allocation and Allocated amount type in the FRS. Can you explain the meaning and the …
-
Receive Expected ShipmentsSummary: which table / tables store the data for this screen? Receive Expected Shipments Content (please ensure you mask any confidential information): 24b Version (incl…
-
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…
-
SKIP ROW based on an attribute in one sheet of a multi sheet excel templateSummary I have a summary and detail excel template. I need to suppress rows which have a value of zero on one particular attribute of the row.Content I have inserted the… -
Conditional Region for Pictures on BI PublisherSummary: Difficulty Applying Conditional Region for Displaying Different Logos in BI Publisher Word Add-In Content (please ensure you mask any confidential information):…
-
Does Oracle Fusion Allow a Link to Microsoft Power BI?Summary I'm looking to see if Fusion would allow Microsoft Power BI to link to the Servers In Order to Build ReportsContent My company uses Microsoft Power BI for alot o… -
Oracle Fusion (HCM) Allow a Link to Microsoft Power BI to get dashboards?We are currently implementing Oracle Fusion HCM and the client has several dashboards already developed in Microsoft Power BI. These dashboards are published in Power BI… -
Smart View handled an unknown exception thrown by Microsoft OfficeSummary: Smart View Error - Smart View handled an unknown exception thrown by Microsoft Office Content (please ensure you mask any confidential information): Steps to re…
-
BI table for AR transaction approvalHi Team, Please help to get table that stores AR transaction approval History. I am not able to find any dedicated table like AP Invoices (AP_INV_APRVL_HIST_ALL). Also t…
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Deve…
-
Can I change the date format in the BI Publisher data model to 'DD/MON/YYYY'?Summary: In the Fusion, publisher reporting → data model→ SQL Query "select to_char(to_date('12/09/2024','DD/MM/YYYY'),'DD/MON/YYYY') from dual;". It always returns 12/0…
-
Looking for report that list active and inactive responsibilies of a userSummary: My client needs to be able to extract current and historical responsibilites of a user in order to verify that compliance rules has been followed. So far I've o…
-
OTBI does not generate all lines.Hi everyone. I'm generating a report in OTBI and not all the lines that should be generated are being returned in the report. Is there a limit to the number of lines tha… -
The Multiple Natural Accounts selected in Single row But Data showing in multiple Rows in FRS OutputCreated FRS Report , One Row We selected Multiple natural account in output data Showing Multiple rows, Expectation Is : Should be appear In Single Row
-
OTBI 'Can't load models - Restore your models' issueIn our TEST environment we are seeing the following issue is all users: As far as we are aware nothing has changed in the back end. We have done the following: Purged th…
-
how to add the hyperlink to Dash board AnalysisWe have created an OTBI dashboard with an analysis that includes a graph based on suppliers and their purchased item categories. We need functionality that allows users …
-
Is there a way to align X-axis labels to the bars in bar graph in OTBI Oracle Fusion.Is there a way to align X-axis labels to the bars in bar graph in OTBI Oracle Fusion.Currently if the orientation is changes to 90 degree, it shows like below:
-
How to debug BIP report that has dataset based on Procedure as a SQL type?Summary: I have an issue with a BIP report that use a complex plsql code as a dataset. I am looking for suggestion to debug procedure used in dataset. The data set confi…
-
RSUM Not working for running cost totalHi, I tried using the RSUM function to get a running total of the project actual costs (Actuals column). However, that function is not working as I expected in the last … -
"Procurement - Procure To Pay Real Time"."Invoice"."Receipt Date" is returning blankSummary: Has anyone get to the bottom of this, I am trying to bring back "Procurement - Procure To Pay Real Time"."Invoice"."Receipt Date" But it is coming black as blan…
-
Schedule process runs on working daysHello, Is there a way we can schedule a process for a BIP report which runs first 8 business days on hourly basis and from 9th day to end of month to run daily basis. Pl…
-
Report to extract Payables invoice approval workflowSummary: Report to extract Payables invoice approval workflow Content (required): Need to know source of payables invoice approval workflow setup so that a report can be…
-
The BICC Database Lineage Mappings and View Objects excel documents include inactive datastores?We are reviewing our BICC datastore extracts and want to make sure we are not using any inactive datastores. The BICC Database Lineage Mappings and View Objects excel do…
-
Redwood Plan for Oracle Cloud ERPSummary: I haven't found clear discussion on how the Redwood would affect Oracle Cloud ERP. I see documentations and notices for EPM, HCM, and SCM, but I'm unclear on wh…
-
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… -
Which table store User category and Password expiration DateSummary Which table store User category and Password expiration DateContent Hi Guru's Please let me know Which table store User category and Password expiration Date und…
-
Getting 401 Unauthorized error code while calling an OIC integration from BIP reportSummary: I have created an app-driven integration that has - trigger REST connection with security policy: OAuth 2.0 - the REST trigger configures multiple resources - m… -
Error message while defaulting the value for DFF: FND-FND_VS_VALUE_INVALID, cannot be accessedSummary: Hi, While setting the default value of a DFF, facing an error: FND-FND_VS_VALUE_INVALID, can not be accessed. Attaching screenshot for the same. https://us.v-cd…
-