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 display clob data in oracle in readable formatSummary: My results are not as expected even i I followed the below link https://docs.oracle.com/middleware/12212/bip/BIPDM/GUID-6C8C333C-FF56-4376-9914-C298DF0DCE83.htm… -
How to find list of roles which gives access to specific task like 'Create Journal'Summary: How to find list of roles which gives access to specific task like 'Create Journal' Content (please ensure you mask any confidential information): Usually throu… -
Is there any table to store the data model SQL query used while creating a reportSummary: Want to identify a particluar condition being incorporated in all the BIP data models ,once identified it can be replaced as per the requirement . Otherwise we …
-
Can provide READ ONLY option for report/ layout and data modelSummary: Can provide READ ONLY option for report/ layout and data model Can provide READ ONLY option for report/ layout and data model?
-
Oracle Fusion Table for - po_employee_hierarchies and ap_cardsTeam, We are building the dashboard for procurement in the Oracle Fusion by referring to the Oracle note query - 'My Group's Requisitions In iProcurement ( Doc ID 312425…
-
SQL query tunningHi, I have developed a sql query to get the balance for a couple of months ( it may be up to 12 months) and it's taking more than 40 mins and ended up with timeout error…
-
Unpaid ReasonSummary Unpaid ReasonContent Which subject area and/or database table and column would store the "Unpaid Reason"? I am looking to create a report with this field. Thanks… -
How does user level data security work in Fusion Financials BI PublisherSummary: Trying to confirm if I understand the correct way data security works for BIP reports in Fusion as its not working as expected Content (please ensure you mask a…
-
Schedule BIP report only when it has DataSummary Schedule BIP report only when it has DataContent We have one requirement for BIP report where we have schedule BIP report daily. so we need that if report data i… -
Slowness of report after upgrade to 23DSummary: A report which ran in less than a minute in 23c is taking 12 mins to complete for the same data post upgrade to 23D. We had 23D upgrade in all non-prod PODs and… -
FRS with records exclusion for given company/PBSSummary: is it possible with FRS to exclude certain CoA records for one PBS value but include for other PBS value? Content (please ensure you mask any confidential infor… -
OTBI - Withdrawn Sickness output not displaying in Absence Real TimeI have built an OTBI report in Workforce Management - Absence Real Time, that I intend to use to report on sickness absence with a 'withdrawn' status. However, nothing i…
-
Financials Cloud OTBI Release 12: Subject Area Description DocumentSummary This document provides a comprehensive description of each subject area including the key business questions that can be answered using the same.Content Use this…
-
How to audit who assigned role to a userSummary: How to audit changes made for user. For eg : Adding or Deleted role for a user under SaaS Fusion Accounting Hub Content (please ensure you mask any confidential…
-
Discard the email addresses of all customers in our lower test instance in ARSummary: We are currently seeking a solution to discard the email addresses of all customers in our lower test instance. The objective is to prevent any email triggers d… -
Accessing Usage Metrics Drill Through ReportsWe are using version 22B. I received an email about accessing a usage metrics report showing user license consumption. However, I fail to find how to locate / generate t…
-
Moved: Requisition Approval Rule Report that includes all other tasksThis discussion has been moved. -
segregation of access within BI Reporting (Reports and Analytics)Summary: Requirement to segregate the access in Reports and Analytics such that user who can deploy the reports to PROD, user who can manage the reports (edit/delete) an…
-
Default user name in ESS job parameter LOVSummary: We have created custom ESS job to invoke OIC integration using datamodel type - http. We need to pass logged in user's user_name as query parameter to integrati…
-
Moved: what is the link between main negotion number with negotion number whic has multiple rounds …This discussion has been moved.
-
How to merge customer names with transactions in a grouped SQL query?Hello, I have this customer ABC having multiple transaction i want to merge the cells that have the same customer name and make it appear one time, i am using select fro…
-
Run BI Publisher reports from excel ( Oracle ERP Cloud SAAS )Summary Run BI Publisher reports from excel ( Oracle ERP Cloud SAAS )Content Is it possible to run BI Publisher reports from excel ( Oracle ERP Cloud SAAS ) ? if so then… -
Is it possible to grant access to a subject area from Administration/Security/Manage Privileges?Summary: If I want to grant access to all employees to one certain subject area (that really has no harmful or sensitive data 😄), is it then possible to give them access… -
Risk Management Access Point Report was running more than a day. Is this correct behavior. ?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…
-
Burst to multiple destinationsSummary: Burst to multiple destinations Content (please ensure you mask any confidential information): Hello - We use Fusion BIP application for ERP. I wanted to know if…
-
Moved: How to add background color BIP excel template row wise in HCMThis discussion has been moved. -
I want to be able to access the to address/recipient used in a delivered workflow notificationHi I want to be able to access the to address/recipient used in a delivered workflow notification from back end tables I tried using FA_FUSION_SOAINFRA.WFMESSAGEATTRIBUT…
-
Budgetary Control Analysis ReportSummary: Control Budget parameter search does not return all project numbers in the Oracle seeded BI Publisher report Content (required): We have a user that runs the se…
-
Is is possible to merge Business Units in FusionContent Hi, We have a situation where there are almost 20 Business Units for one Legal Entity. This is posing problems like allowing duplicate invoices across BUs but al…
-
Custom report for Invoice approval workflow detailsSummary: Custom report for Invoice approval workflow details Content (required): Hi All, We got a requirement to develop BI report to show AP Invoice approval details li…