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
-
Scheduling BIP Report in Fusion Financials (Cloud) - Conditional SendSummary: Is a trigger necessary on a data model to conditionally send or not send a report in BI Publisher or will a data model that returns rows or doesn't suffice? Con…User_2025-02-10-15-12-48-631 21 views 2 comments 1 point Most recent by User_2025-02-10-15-12-48-631 -
Is it possible to have default prompt value specific for each user in an OTBI dashboardSummary: We have an OTBI dashboard for which each user is searching a specific account combinasion. Instead of always typing the account in the prompt of the dashboard, … -
Fusion Process Maps (Visio)Summary: im finding the Fusion Process maps and the references or lack of them being clearly defined a little difficult to follow, previously being used to a clear struc…
-
Role required to view Analytics section on Fusion Home PageContent Dear All, Could you please help me with the role required in Fusion to make the Analytics section visible on the home page. Regards, Mahesh
-
COA Segment Values based on Security RulesSummary COA Segment Values based on Security RulesContent We have a requirement to filter BI Report PARAMETER for COA Segment Values based on the security rules defined … -
Post report Completion event for External SystemsSummary Post report Completion event for External SystemsContent Hi, There is a scenario wherein client needs an event once the report is completed successfully, an even…
-
Get Invoices API not working Fusion Financial CloudSummary 500 Internal Server ErrorContent I have managed to successfully test many Rest API's in Postman however the Invoices API returns a '500 Internal Server Error'. I…
-
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…
-
Need to use a parent value in offset in Wizard based allocationSummary As per clients requirement, we need value for 2 segments in offset be picked up from source. Source has parent value entered in these two segments, whereas offse… -
Audit Report - Customer Name not appearing in audit report when changing profile classSummary Audit Report - Customer Name not appearingContent HI Experts I am changing customer profile class for a few set of customers and running audit report for the sam…
-
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.
-
How to access the New DashboardSummary How to access the New DashboardContent I have seen this post online but not sure is this Oracle Fusion OTBI Dashboard or need separate license or product. Please… -
sql for material transaction reportContent i need to create a material transaction report between 2 dates the first i need open balance quantity (sum quantity before the first date) transaction between 2 …
-
Fusion ERP REST APIs for China RegionContent I am looking for REST APIs for China w.r.to Fusion ERP. Is there a document ? Can anyone please point me to these documentation? Thanks, Aruna S
-
SOX and Smart ViewSummary SOX is asking how they can know Smart View data is accurate and completeContent Hello, Our SOX team is asking how they can know that Smart View data is accurate,… -
Financial Reporting Web Studio BookContent Hello: We have page inserts in our financial "book" for manually inserted pages. One of the Inserts is using a 2 page insert and needs a 3 page insert (so the pa…
-
OTBI AP Report including approversSummary Can I access a field containing approvers in an OTBI Payables transaction report?Content We have a report that returns all payables transactions for the prompted…User_2025-02-11-03-09-13-126 26 views 2 comments 1 point Most recent by User_2025-02-11-03-09-13-126
-
Receivables - Customers Real Time subject area access issueSummary Results errors when adding multiple fields to analysisContent I created a Customer Detail Dashboard using one analysis and one prompt. It was built from the Rece… -
Joining two subject areas OTBIContent Hello: I feel like I'm so close. I have the two subject areas and the criteria columns completed. But I'm getting an error when I run each one of them (worked wi…
-
What is the risk of copy any seeded report, add two columns on a table already in the data model, keSummary What is the risk of copy any seeded report, add two columns on a table already in the data model, keeping in the custom folder with a new name and new ESS Job on…
-
Need table name which store Fiscal Classification CodeSummary Need table name which store Fiscal Classification CodeContent Hi Guru's, Please let me know which table store the Fiscal Classification Code which comes under "M…
-
Financial Reporting Web StudioContent Hello: I opened the Grid of a report we are currently using to make a change (report currently runs fine from the Financial Reporting Center Catalog) and immedia…
-
BICC Extract job timestamp used to extract data when there is a failureSummary What extract timestamp is used for each incremental job after a failureContent When there is a failure in BICC incremental job which timestamp is used to start t…
-
Count of attribute column in Learning Real TimeContent Hi there I want to have a count of an attribute column in Learning Real Time. For instance, I have a table with the names of the users and a course name. I want … -
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…
-
OTBI Issue - Costing - Receipt Accounting Real TimeSummary OTBI Receipt Accounting -- Concatenated SegmentsContent Hi All, Appreciate your inputs or suggestions on the below issue. OTBI Report having timeout issue Subjec… -
in OTBI I need to send email or notificationContent I created an analysis for suppliers , I want to sent the output by email or sent tontification . if an analysis has a parameter so whatis the solution ?
-
Release 21BSummary xsl template for ACHContent Hi All, Did anyone worked on the Payables payment process with ACH template with xsl type in 21b.? need inputs on how to develop ACH …
-
Need a query to get total of Current Cost, Accumulated Depreciation, Impairment for asset categoriesContent Hi all, Can someone give me a query that gives a total of : * Current Cost * Accumulated Depreciation * Impairment per asset categories in Fixed Assets Module. R… -
What is the best way to identify whether the current Fusion instance is PROD or Non-PRODSummary What is the best way to identify whether the current Fusion instance is PROD or Non-PRODContent As we need to transfer BIP Reports to different FTP file servers …