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
-
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…
-
Moved: I can't find rest APIS to get some columns in work structures, person and assignmentsThis discussion has been moved.
-
OTBI how to assign roleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Budgetary Control Purchase Order Life Cycle Custom ReportSummary Use this report to analyze a purchase order life cycle and its impact on budgetary control balances.Content The Budgetary Control Transaction Life Cycle report i… -
Risk Management Access Violations by User ReportSummary A dashboard displaying top 10 users with control violations. Below this is a detailed view by role for a specified control and user showing the conflicting acces… -
Sales Order Lifecycle ReportI am looking for end to end O2C lifecycle details in report. Do we have any sample report report with this requirement ? Below are the columns I am looking into it. Sale…
-
Conflict in defenition of Finance and HR business unitsRegarding Finance and HR business units: there is a Conflict between HR and erp team about the definition of business unit. Given the following what would be the best pr…
-
Unable to revoke data access setanSummary Hi Team, We have given data access et for one Ledger and revoke the same but still user able to view the Journals in that Ledger.
-
Scheduled Jobs ErrorSummary: Hi Team, We have few scheduled jobs which will run on daily basis. Recently few system automated jobs and manual scheduled jobs ended in error without any log f…
-
Not able to execute report from "Financial Reporting Center"Hi, I have developed a custom report and able to generate the data without any issue if i run from "Report And Analytics" but report execution is failed from "Financial …
-
financial categoriesSummary: ERP Financial Categories and Fusion Analytic Warehouse Content (please ensure you mask any confidential information): Customer is implementing Fusion Analytic W…
-
Quarterly Update Feature Listing and Maintenance Pack DocumenationHow can we know what maintenance pack items are included in the Cloud-apps-feature-listing listing? For example, what maintenance pack items are included by default in t…
-
Trending FRS Report to exclude 13th Period?Summary: How to exclude 13th Period in Fusion FRS Report? Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snip…
-
What are the Table names for fields "Other Communication Accounts" and "Order of Preference"Content (please ensure you mask any confidential information): What are the Table names for fields "Other Communication Accounts" and "Order of Preference". Need to fetc… -
OTBI Report analysisSummary: I have created mostly Reports development in Oracle BiPublisher. Where i used to show prompt input parameters in Reports and formatting easily with multiple gro…
-
OTBI Complete List of Subject areas and ESS Jobs to populate with dataSummary Does someone have a complete list of OTBI subject areas that require ESS jobs needed to populated the dataContent These are the only Subject areas that I am awar… -
Rest API to GET reports from BIP in Fusion Financials SAASSummary Is there a Rest API to get BI Publisher reportsContent Hi All Is there a Rest API to call BI Publisher reports from Fusion Cloud Financials within SAAS financial…
-
Language Translation DictionariesSummary Searching for a .csv file that would have the Oracle UI elements translated from English to the languages available.Content Hi all, We currently are looking for …