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
-
How to monitor the following reporting and analytics field : "Enable Monitor and Audit" fieldSummary: Under reporting and analytics, under Administration, Manage Publisher, Server configuration, under Monitor and Audit section How can monitor "Enable Monitor and… -
Need details on PVO: FscmTopModelAM.NoteAM.CashAdvanceApprovalNotesPVOWe would like to request additional information regarding the PVO FscmTopModelAM.NoteAM.CashAdvanceApprovalNotesPVO. Specifically, we are seeking clarity on the followin… -
How to reduce Report post processing time or template processing time in oracle fusion BI Publisher?We are working on one custom report performance which is taking more time for post processing. Report XML generation takes around 40 sec time and to generate excel repor…
-
Which report is responsible for managing the approval notification in the application and the emailSummary: We would like to add the supplier name to the report that manages the sending of approval notifications. The goal is to display the supplier name in both the in… -
Bursting Feasibility for BIP Report having Multiple Data ModelsDear Team, We have one requirement wherein we need to enable bursting for one report having multiple data models, kindly confirm if that can be achieved. If yes, then pl…
-
help with if/then formula in EPM ReportI need help with a formula in a report. As soon as I add the subtraction part to the final part of the statement i get an error. This works: IF(IsMissing([G]), 0, [F]) T… -
https://cloudurl:443/fscmRestApi/resources/11.13.18.05/erpintegrations' failed:bad request (400)Summary: We have integration between ebs to scp cloud. we have schedule integration run on mulesoft. mulesoft site using Below one. https://cloudurl:443/fscmRestApi/reso…
-
Query to fetch the CARRIER_NAME, DELETE_SOURCES and DELETE_EXCLUSION for Sourcing RulesHi Everyone, Can you please help me with the SQL Query or the Fusion tables/columns required to fetch the following fields for Sourcing Rules( Supply Chain Planning → Ma…
-
Syntax for referencing a user privilege in an EL ExpressionSummary: Content (please ensure you mask any confidential information): Hi, I am trying to build a custom menu to access OTBI reports from the Navigator / springboard . …
-
OTBI Analysis Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversionHello, I'm getting the error in my OTBI Analysis: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion when I add a column Called "Requirement Text" fr…
-
otbi is fetching the amount details for only USD currencies not for all currenciesotbi is fetching the amount details for only USD currencies not for all currencies do we need to enable any profile options, apart from USD we are unable to get the amou…
-
How can I write a SQL query in Oracle Fusion Cloud to identify unapproved requisitions?Hi everyone, Please see the full question below. How can I write an SQL query in Oracle Fusion Cloud to identify unapproved requisitions where a specific approver (e.g.,…
-
There is a image placed in Custom/Image folder. How to access this image in the BI report template?Unable to access images from Custom folder in BI report template. We have placed the test image in Custom/Image folder and tried to access this image in the template but…
-
Print receivables transaction process different default parameters for different usersI noticed that different users have different default parameters when running print receivables transaction process in scheduled process. Our configuration user access h…
-
BI Cloud Connector (BICC): ElementEntryPVO vs ElementEntrySummary: Both ElementEntryPVO and ElementEntry are sourced from the same view PAY_ELEMENT_ENTRIES_VL. However, when performing a full extract with the Effective Date Fil… -
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 we import data via API to be included in OTBI dashboardSummary: Is there a way to import data via an API and have this data be available on a OTBI dashboard? MJ
-
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 …
-
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… -
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…
-
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…
-
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… -
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…
-
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… -
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…
-
"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…
-
FND_FLEX_VALUE_RULE_LINES equivalent table on Oracle Cloud FusionHi all, I'm working on an EBS to Cloud project, and we have the following requirement - Send to the legacy system all the valid account combinations. Today, they are usi…
-
How to set comma as decimal separator in RTF Template in BIP Reports ORacle FusionI have a requirement to show the EUR format amount i.e. €1.234,00 in output of RTF template other than setting it at User Preference. I have already tried the EUR format…
-
Getting duplicate records from AP subledgerSummary: Getting duplicate records from AP subledger Content (please ensure you mask any confidential information): Hi All, I have a requirement where i need to fetch th…
-
Assistance Required for OTBI Reports in SCM (Inventory Module)Hi, We are developing a few OTBI reports for the SCM module, specifically on the inventory side. However, we are facing difficulty in identifying the correct subject are…