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: How to extract data from xmltype column using bip reportThis discussion has been moved. -
What type of delimiter can we use for AFF segment in Oracle Fusion Cloud ERP?Summary: Could you please provide the delimiter's value that we can set for AFF? I think that they are below, based on the screen of 23C. !, *, +, -, ., :, =, ^, |, ~ A… -
Issue with migration of DashboardHi, User has migrated their own dashboard from their own folder to custom folder. Only the person who has developed is able to access but it is throwing error for others… -
Is there any alternative if table is not available for BICC extractionHi, I was working to do an extraction using BICC and not able to get the PVO for some tables like: RCV_SUPPLY, WSH_FREIGHT_COST_TYPES etc. Is there any work around avail…
-
Moved: HFRS - How to generate Date Format for a report Dimension - Accounting Period on report Head…This discussion has been moved. -
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.
-
how do you change ERP Cloud quarterly patches coWe are currently in Cohort B for current release management patches and want to know how we can change to a different cohort
-
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.
-
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.