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
-
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… -
Moved: HFRS - How to generate Date Format for a report Dimension - Accounting Period on report Head…This discussion has been moved. -
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 -
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 …
-
How to query committed cost of projects?Using Oracle ERP/ FSCM, there is a requirement to add data related to "Project Committed Cost" to our data warehouse. We mostly use the PVOs to import data in DW, What a…
-
Report to get employee's default expense accountSummary: Hi, Can you please suggest if OTBI report is possible to develop to get employee's default expense account? If Not can you please share any SQL query which can …
-
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…
-
Privileges required by the FAWService account that is created in Oracle Fusion ERP and used by FAWWe are creating the FAW instance and configuring out of box Pipeline between ERP and FAW to get the ERP data. For this purpose we need to create a user in ERP that can b…
-
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 …
-
Need to know the logic behind the seeded report parameters of Payables Trial Balance ReportSummary: Just wanted to know the logic behind seeded 'Payables Trial Balance Report' parameters which are mentioned below 1.Include Bills Payable 2.Negative Balances Onl…
-
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 fileI 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 last update…
-
Moved: Require to fetch Roles and Data Access assigned to employees for BIP report in Oracle HCMThis discussion has been moved.
-
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…
-
-
create a net column on an analysis by subtracting two columnsSummary: I am trying to create a net column on an analysis using by subtracting two columns that are included on it. The Analysis is using the GL and AP subject areas. T…
-
Moved: Missing Access for a COA segment in a FRS report for a particular userThis discussion has been moved.
-
Oracle ERP (Oracle fusion financials) attachment deletion processPer my organization, we have 3-5 years to discard working documents depending on how they are classified. Does Oracle ERP (Oracle fusion financials) have the capability …
-
Moved: How to Attach Process ID(fusionapps_request_id) to File Name when Bursting ?This discussion has been moved.
-
Moved: How can I create an event trigger in a data model with subject area?This 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…
-
PVO for GL Secondary Balancing Segment KFF?Summary: On a quest for chart of account segment descriptive labels (KFFs) for secondary balancing segment. Content (please ensure you mask any confidential information)… -
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 … -
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.
-
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): … -
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…
-
Payables Posted Invoice Register to show final approver doubles invoice line amountsSummary: I'm trying to modify the Payables Posted Invoice Register to show the final approver, but the output shows the invoice line multiple times. Content (required): …