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
-
OTBI - YTD -For - Period NameSummary YTDContent All->How to calculate Year-To-Date YTD (total amount for a given period) for a amount column from OTBI. when a user selects Period Name from Parameter… -
Moved: How do I keep a table with repeating elements from breaking across multiple pages?This discussion has been moved. -
Custom Purchase Order template works fine when PO is in Draft status but does not work when PO movesSummary Custom Purchase Order template works fine when PO is in Draft status but does not work when PO moves to Open statusContent Hi, The Custom PO template works as ex… -
Hot to fetch bursting delivery notification detailsSummary: Looking for a query or table which would fetch bursting delivery notification details. Content (please ensure you mask any confidential information): We have a …
-
How do you update Remaining Life with an effective date?Summary: How do you update Remaining Life with an effective date? When we update the Remaining Life then run calculate depreciation, we want that calculated based on an …
-
query to get ap accounted invoices.Content i need a query to get ap accounted invoices.
-
Project Class Category Causes Duplicate Rows for Project Financial Information in OTBI and BI PUBSummary: When we want to report on the Project Classifications class categories for a project number there is no clean way to do it. The current solution we are doing re…
-
Moved: Reporting Capability Maturity Matrix : Reporting Road MapThis discussion has been moved.
-
Table details for ESS Job Display NameSummary: Hi, Can you please suggest which table holds the ESS Job Display Name? I have tried few tables like: request_history_view, ess_request_property but not able to … -
In our FRS Reports, the Description does not work unless you put first few charactersSummary: In our FRS Reports, the Description does not work unless you put first few characters that is you can’t search with string starting with asterisk, but for Name … -
Report to Monitor User ActivitySummary: Hi All, We have a ask from the customer where in if a collection rep logs in and works an 8 hour shift, manager would like to pull a report to see how many tran…
-
Custom File Naming for ESS Job Downloads in Oracle FusionSummary: Request for Custom File Naming for ESS Job Downloads in Oracle Fusion Content (please ensure you mask any confidential information): We have created ESS (Enterp…
-
Requisition Approval E-Mail Report Template changes is not getting reflected in output file.Summary: I have customized the seeded report named "Requisition Approval E-Mail Report" but the changes is not getting reflected in the notification. It is taking the la…
-
Analysis Report Prompt is not appearing when running from the InvoicesSummary: Prompt added to the analysis report is not appearing when running it using invoice window. Content (required): Hi, I have created a OTBI analysis report (Not fo…
-
Identifying active agents across the instanceSummary: Is there a way to view all agents currently active in OTBI across both shared and private folders? We have a report being sent via an agent where the recipients…
-
How to use RTF templates if Client is having Google Docs and sheets instead of MS Office productSummary: Our client is using Google products only like Google Sheets and Google docs and not having MS office products such as MS word or excel. How do we edit the RTFs …
-
BICC - Customization migrationSummary: BICC - Customization migration Content (required): I want to migrate one custom offering from one environment to another environment. BICC is giving an option t…
-
Need OTBI Analysis/Logical SQL behind Standard InfoletsSummary Need OTBI Analysis/Logical SQL behind Standard InfoletsContent Dear All, How to get the OTBI Analysis/Logical SQL behind the Standard Infolets Ex:Invoices Home … -
Moved: Require to fetch Roles and Data Access assigned to employees for BIP report in Oracle HCMThis discussion has been moved. -
-
Analysis ("Payables Invoices - Transactions Real Time") - Need to Add a new columnI'm building an analysis ("Payables Invoices - Transactions Real Time") in OTBI and wanted to know if it's possible to add a new column which is not in the "Payables Inv…
-
Moved: Missing Access for a COA segment in a FRS report for a particular userThis discussion has been moved.
-
Tracking Data Model Usage and associated queriesSummary: How is called the table or view (Oracle fusion) which tracks the information about the queries (data models) run by a user? The goal is to determine which table… -
Moved: How to Attach Process ID(fusionapps_request_id) to File Name when Bursting ?This discussion has been moved.
-
Financial Tax Register Report Region Wise ESS JobSummary Ability to have a Custom ESS Job for Financial Tax Register Report to associate custom FTR reportContent Hello All, We modified the standard Financial Tax regist…
-
Excel template with summary and Detail and Detail sheet should split in to multi sheet, need helpSummary: Excel template with summary and Detail and Detail sheet should split in to multi sheet, need help Content (required): Excel template with summary and Detail ( D…
-
Is there a plan to deprecate the SOAP webservices related to BIP report & ERP Integration in future?We wanted to check if the SOAP webservices 'ScheduleReportWSSService' and 'ExternalReportWSSService' for BIP reports and 'ErpIntegrationSevice' be deprecated in coming f…
-
Moved: How can I create an event trigger in a data model with subject area?This discussion has been moved.
-
How to change member display in SmartView FunctionEven if I changed "Member Name Display" in Options>Member Options> General> Member Name Display, there are no changes in "Member Selection". Member Selections shows each… -
How does FR retrieve data from EssbaseCube?I would like to know how FR retrieves data from EssbaseCube, because of its performance. When we'd use FR, it takes much more time than we'd use Smartview at the same co…