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
-
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…
-
Table for Bursting Output ResultsSummary: Does anyone know what table has the results of an individual bursting output from a scheduled BIP report? From the screenshot above you can see that we have one… -
Is there a standard report to run showing all terminated users and terminated dates from Oracle ERP?Summary: The customer was inactivated and locked the user from the Security and Console. Please note they are not using the HCM module. However, they would like to displ…
-
Format Automatic Receipts - Override Email CommunicationSummary: At BIP server level, for the complete POD, is there any option to override the TO email address is being used to communicate any email via bursting query? Conte…
-
Is it possible to add a new filed in data model query of Payable Trial Balance seeded report?Summary: We have a requirement to get Supplier name in Arabic in Payable Trial Balance report. User don't want to customize the seeded report as they are using same repo…
-
How to pull GL JE data for a rolling last 2 periods or last 60 daysSummary: How to pull GL JE data for a rolling last 2 periods or last 60 days Content (required): How can I pull GL JE data from the GL JE Header and Lines tables, so the…
-
REST API for Profitability and Cost Management.Summary: DOWNLOAD FINANCIAL REPORTING REPORTS IN PROFITABILITY AND COST MANAGEMENT WITH REST API. Content (required): Hello, I have reports created from the reporting to…
-
Are the tables related to OTBI reports available to report on in OTBI?Summary Would like to monitor changes to OTBI reports at the table level until OTBI reports are being monitored via Audit PoliciesContent Would like to monitor changes t… -
Can BICC write CSV files to Object storage or UCM without zippingSummary: Can BICC write CSV files to Object storage or UCM without zipping Content (required): Currently BICC writes CSV files with zipping onto Object storage or UCM. S…
-
Can BICC write files to Object storage or UCM without zippingSummary: Can BICC write CSV files to Object storage or UCM without zipping Content (required): Currently BICC writes CSV files with zipping onto Object storage or UCM. S…
-
GL Budgets not being returned from General Ledger - Balances Real TimeSummary: Subject area General Ledger - Balances Real Time not returning data for GL Budgets (budgets are loaded) Content (required): Hi, I have followed Doc ID 2177122.1…