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
-
BIP report Excel output is formatting large numbers as General/scientificSummary: We created a BIP report for Fixed Assets. Any numerical values in the tens of millions or higher export to Excel as scientific. For example, an asset Cost of 42… -
Can you change the font or color of a Dashboard tab?Summary: Can you change the font or color of a Dashboard tab? Content (required): Can you change the font or color of a Dashboard tab? Version (include the version you a… -
How can I create a BI Analysis that considers the credit limit of a customer at Party levelSummary: I need to create an analysis that considers the credit limit of a customer at Party level, all the subject areas that I found that have the credit limit are at …
-
how to assign a role to multiple users in Oracle erp cloudSummary: Content (required): There is a role we want to assign to multiple users. How to do this at a batch instead of going to each user and assign role. thanks, Versio…
-
GL Trial Balance Report Custom TemplateSummary:We've created custom template for TrialBalalnce.xdo, But still ESS job is taking standard template.Is there are changes required in configuration to pick custom …
-
FAW - How to show Data Labels in the Sankey VisualizationSummary: We have a sankey visualization - showing the Revenue and Operating expenses - broken down in different categories. Users want to see the each bucket's values as… -
Can we PGP encrypt BIP output without FTP deliveryI have a requirement to extract the BIP output using SOAP WSDL or ERP adapter and we need to make sure that the BIP report is encrypted with PGP keys before it is sent t…
-
FRS POV Dimension LayoutSummary: Content (required): Hello: Some reports have all the defined POV's showing when opening the report, and some only show the POV's that need to be changed (i.e.: …
-
Fixed Asset Balances - Real Time subject area is not updatingSummary: Content (required): We have developed a report using the Fixed Asset Extract Balances table and the recent transactions re not updated in the table. The "Extrac… -
OTBI : Facing Java:Null issue in Dashboard PropertiesSummary: OTBI : Facing Java: Null issue in Dashboard Properties. As shown in the SS below. Is it because of 22A Upgrade? Content (required): Version (include the version… -
Adding Distribution Information to Payables Invoice InquiryYou can extend pages with custom OTBI reports, for example with budgetary control charge account and projects information is useful when viewing invoices. The Embedded I… -
Password should never expireHi , Integration user password should never expire, is there any options?? Thanks, -
Graph or Chart in BIP ReportSummary: We need to build a report that shows a table with all the data and then a graph/chart for the same data. We have an RTF template built for the same. Please advi… -
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…
-
OrderChargeComponentExtractPVO extract contains duplicates for primary key while extraction.Summary: OrderChargeComponentExtractPVO extract(via DataSync) contains duplicates for primary key. Content (required): We are extracting data using the OOTB PVO 'FscmTop… -
positioning FAW on top of Supply Chain Planning Cloud (Demand Management Cloud, Supply Planning ClouSummary: Has anyone built FAW analytics using Supply Chain Planning Cloud and EBS (Procurement, Financials, Inventory, Order Management) data with drill down/deep link c…Vishnuvarth Subramanian-Oracle 21 views 0 comments 0 points Started by Vishnuvarth Subramanian-Oracle
-
positioning FAW on top of Supply Chain Planning Cloud (Demand Management Cloud, Supply Planning ClouSummary: Has anyone built FAW analytics using Supply Chain Planning Cloud and EBS (Procurement, Financials, Inventory, Order Management) data with drill down/deep link c…Vishnuvarth Subramanian-Oracle 21 views 0 comments 0 points Started by Vishnuvarth Subramanian-Oracle
-
Custom Expenses Subtemplate Not Reflecting in NotificationsI have customized the Expense Approval Data Model to add one field not in seeded DM. The field needs to go in to Expenses section which is part of the Expense Notificati…
-
Business Process training and certification for Oracle Cloud Applications is now availablePrepare for successful Oracle Cloud Application implementations with a common foundation of business process knowledge across all teams. Learn more about how new Busines… -
Account Analysis report returns no data - 2nd year in a row this report has become broken in March.Summary: In march, this report starts returning no data. Runs fine in Jan & Feb. Last year, the SR reported back that the data model had been updated for performance rea… -
How to create Report Filter that only provides results based upon Current DateSummary: I have a BI report with I need to retrieve all transaction created on current date Content (required): Report is BI Publisher Report based upon Receivables Tran…
-
Period Name parameterSummary: Hi , I am currently working on report which is filters using period_name. when i select single month(period_name), the data looks promising. when multiple perio…
-
How to tackle different date formats being entered by user in Supporting Reference in BIP Report?I have a scenario when users input dates in multiple formats eg.18/Mar/2022, 18/March/2022, 18/03/2022, 2022/03/18 while posting a Journal in the Supporting References. …User_2025-02-12-15-34-52-841 21 views 2 comments 1 point Most recent by User_2025-02-12-15-34-52-841 -
After 22A upgrade we are not able to delete BI email server from Oracle Cloud Non-Prod InstancesSummary: Please suggest, After 22A upgrade we are not able to delete BI email server from Oracle Cloud Non-Prod Instances Content (required): After 22A upgrade completed…
-
Report gives an errorI created a excel template report which data model is working fine but when i run the report which is excel template its give me an error Error The report cannot be rend… -
How do I create a variance Forecast - Actuals in OBIEE for EssbaseSummary: How do I create a variance Forecast - Actuals in OBIEE for Essbase where the Forcast and budget are row based as the Scenario dimension dictates whether the val… -
ERP Cloud BIP report data model schema integrate with EPBCSHi all, I need to create a metadata / dimension integration from our ERP Cloud GL to EPBCS via data management. Can you please help me find in ERP the SQL query on top f… -
oracle report to google sheet directlyis there any way to connect oracle BI and OTBI reports with online google sheet or offline excel file ? Thanks
-
Adding a parameter to custom data model of a seeded reportSummary: We need to customize a seeded report and add a new parameter. But when we create a copy of seeded Data model and add a parameter in the custom data model, it gi…
-
Users for Queries - FinancialsI'd like to know if there's any specific type of user that we can use as consultation in ERP Cloud - Financials. I.e: I have a team in the company that work with specifi…