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
-
Steps to Create BIP Reports type ESS Job with Table type value setSummary: Steps to Create BIP Reports type ESS Job with Table type value set Content (required): Hi All, We have a requirement to create ESS Job for BIP Report with multi… -
OTBI Analysis Revoke Access to Export options Powerpoint, Web Archive, Tab Delimited, XMLSummary: Would like to know if it is possible to disable Export options Powerpoint, Web Archive, Tab Delimited, XML by role in OTBI Content (required): We are looking to… -
Alerts in Oracle Fusion CloudSummary: Do we have anything similar to Oracle Alert in Oracle Fusion cloud ?
-
Is it possible to set up automated reports splitting data by cost centre or spare 1 field?Summary: Business has the requirement of splitting a report by cost centre or spare 1 field and sending to different receipts based on the cost centre. This is to send a…
-
Joining Subledger data with GL dataI need to build a query which joins subledger data table, xla_ae_lines to gl_je_lines. I am attempting this through gl_sl_link_id but the performance is awful, is there … -
When we reassign an account to different collector - tasks do not moveWe are implementing advanced collection and noticing that when we reassign an account - to a different collector , strategy tasks do NOT MOVE to the new collector - they… -
OTBI Data Security - AssetsDo all Oracle saas ERP modules follow data access/role security for access to data. I have a user who has assets data availabiilty but does not have an assets role. Than…
-
How can we query the error message in BI Server's Report Job History?Summary: Error Log Report that will display the error message like in the Report Job History Content (required): Hi, We wanted to create a custom report that will output…
-
Source Table for Manage Common Options for Payables and Procurement:Summary: Need Help on Source Table for Manage Common Options for Payables and Procurement: Pls see below screenshot of the screen.. Content (required): Given the Busines…
-
Administrator license consumptionSummary: Content (required): We have a user "****.ADMIN" who has these 4 admin roles: -Employee -IT security Manager -Application Implementation consultant -Application … -
Can we get the dynamic url in BI Publisher email notifications?Summary: When we schedule a custom BIP report, and once it is completed then system is sending an email notification with the status. In the email notification there is …
-
Data Persistency in Oracle Cloud - how long will Request Ids, Output/log files be available?Summary: is there any time period for which the request ids, output/log files of Oracle ERP Cloud Process/Job/ESS requests are made available? Or Will these be available…
-
Give access of OTBI report to usersSummary: Hi We have build an OTBI report from a user who has BI Author role. And we need to give access of this report to other users. we have used Permissions in the OT…
-
how to viewing oracle saas BIP report history based on job id parameterHi Team, When we select the Schedule and submit the BIP report (after entering the job name) from catalog section , Currently the History the Report has Job name , owner…User_2025-07-18-07-26-59-885 343 views 4 comments 0 points Most recent by User_2025-07-18-07-26-59-885
-
Calculate revenue % distribution for each project with in Business unitSummary: We have the below requirement Project1 Revenue amount-20 project2 Revenue amount-30 project3 revenue amount-16 Total BU revenue amount 66 (this is achieved by e…
-
How can we limit access to reports residing in delivered (out of the box) folders?Summary: How can we limit access to reports residing in delivered folders? Most of the users have access to BI roles (Consumer/Author/Admin) inherited through other role…
-
Restricting a record if its already sent - Oracle Fusion ERP Cloud BI Report Requirement.Summary: We have a report requirement that once payments exceed $600 during a calendar year, we report to the downstream app within 20 days. Also, once a supplier has be… -
printer setupSummary: Questions regarding printer setup Content (required): Hi team, Kindly clarify below points. *BI Publisher >Administration>Manage Publisher>Delivery>Printer>Add …
-
List of All Tables for Oracle Fusion ERP in PDF FormSummary: We need to have a List of All Tables for Oracle Fusion ERP in PDF Form along with its corresponding descriptions Content (required): We need to have a List of A…
-
Does OTBI report follow Data Security enabled for usersSummary: Does OTBI subject areas enforce the Data Security Context values that have been assigned to users. For example, a user has been assigned one BU and One ledger, …
-
How to remove ability to Create Shortcut in Reports & Analytics pageSummary: Within the Reports & Analytics page, we do not want users to be able to create shortcuts. How can we remove this ability from users? Content (required): Is ther…
-
Audit Policies White Paper or PPT requiredSummary: Audit Policies White Paper or PPT required Content (required): Business wants to know the Fusion Audit Policies and would like to give presentation them. Highly… -
How to link "Corporate card transaction reversal" invoice lines from expenses to Company AccountSummary: I am attempting to create a BI report using SQL Query to report on the miscellaneous invoice lines, which are system generated from credit card expense reports …
-
How to sum a variable in XSL template?Summary: I'm unable to a sum a variable data in XSL template. Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code…
-
Existing HFRS report built on tree needs to be compared with control budget that doesn't have a treeSummary: Content (required): Hello Aim - To have a report that can be used to compare actual and control budget data. The below points describes the issue that we are cu…
-
Access BU in BIP based on UI RolesSummary: I have a client who has requested a specific functionality for displaying Business Unit (BU) names in the Business Intelligence Publisher (BIP) List of Values (…
-
How to Create Alias TableSummary: Hello, I have requirement to create FRS reports for multi-language reports in oracle cloud and need help to create Alias Tables as this is required to fulfill t…
-
Essbase error (1020032): Data item found before member errorSummary: Getting below error in SmartView while connected to GL Essbase Cube: Essbase error (1020032): Data item found before member error Content (required): Version (i…
-
Copying personal custom Dashboard to Shared Folder > Custom > Dashboards throws Error Codes: QM3V3HSummary: Moving a personal dashboard to shared folder throws error Content (required): User has a custom Dashboard created in My Folder >Dashboards They want other users…
-
In an ERP only implementation, no HCM, how can we handle multiple assignment in autoprovisioning?Summary: In an ERP only implementation, no HCM, how to handle multiple assignment in autoprovisioning? Content (required): We are not using HCM Cloud, has anyone have a …