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
-
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. -
Impact of Changing Time Zone on transactional data in Oracle CloudSummary: Hello, My time zone is default right now and I have uploaded my cutover data on production server. Now I want to change my time zone to my country. How will thi…
-
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.
-
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…
-
FRS search members by description starting with, Ending with, ContainsSummary FRS search members by description starting with, Ending with, ContainsContent Our client doesnot have specific values for each row. Instead they have conditions …
-
Prompts are not currently supported for analysis that combine criteriaSummary: Combined two SA i.e "Projects Billing - Revenue Real Time" + "Project Performance Reporting Real time" and want to have 'Project name' as Prompt Value and it is… -
Is it possible to connect a sharepoint to ERP in order to add attachments to transactions?Summary: Users have asked for a solution that doesn't require downloading and uploading of files to their local machines. Content (required): Is it possible for users to… -
Required more Info on Oracle Journey’s into ERP Financials and Procurement Implementation GuidesHi Team, Is there any document/white paper regarding Oracle Journey’s in the ERP mainly into the Financial/Procurement implementation guides, Customer is more requesting…
-
Query to bring the BU to which a Customer Account Site is associated toSummary: Content (required): I need a query to retrieve the BU name associated to the Account Site . Thanks. Version (include the version you are using, if applicable): … -
Customer StatementSummary: Unable to print page number in rtf layout based on the customer Content (required): Hi Team, we have requirement to print the page number in the rtf template ba…
-
Moved: LACLS: Dominican Republic (DO) BIP Reports Libro Diario and Libro Major do not render parame…This discussion has been moved.
-
Are there downloadable dashboards for Financials modules?Summary: I am looking for downloadable dashboards like the ones created by Caroline Gladwin (please refer to link: OTBI Sample Dashboards - 1. How to Install and Configu…