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
-
How Purge Interface Tables Program selects submitted by user?Summary: How Purge Interface tables select the user to schedule maintenance Purge with following arguments? Argument1 =1111 Argument6 = ORA_MAINTAIN Argument7 = SYSTEM A… -
Custom Job Set not showing for one userSummary: We have created job sets in a lower environment and the users that need to access it are able to with the exception of our Director of Projects. She is still no…
-
Procurement OTBI DashboardsSummary ERP Procurement OTBI Reports and Dashboards uploaded for the CommunityContent Sharing a procurement to pay dashboard with multiple tabs containing example report… -
How to restrict User From Submitting Create Accounting for a Certain SubledgerSummary: How to restrict User From Submitting Create Accounting for a Certain Subledger Content (please ensure you mask any confidential information): Hi All, We have a …
-
Table to get the field of Condiion under Manage Chart of Accounts MappingsSummary: We need a table and column where the Condition field information stored for the setup "Manage Chart of Accounts Mappings". Attached the screenshot with highlite…
-
how add user variable to report header #2Summary: I need to add user variables into a report header. Is there any way to do this? What is shown below doesn't work. -
how add user variable to report headerIs there any way to put a user variable into the header of a report?
-
How to create a Fusion Data Intelligence DV Report using OTBI Fusion TableI have an OTBI BIP Report which is sourced from Data model using OTBI Fusion database tables. I need to recreate the report under FDI DV. I am not sure how to find same …
-
How can i get currency report to show currencies and the exchange rate against a currency in OTBISummary: How can i get currency report to show currencies and the exchange rate against a particular currency in OTBI. I know I can get it through BIP report but i need …
-
Number format in oracle reportHello, when in a report we have #missingData, if i export the report in excel, we have 0 but not in number format. How can fix this, to have always number format? Thanks
-
What reports are available for agent level productivity metrics?Summary: We are looking at agent level productivity metrics. What seeded reports are available in Oracle? Or are these custom created reports? This ask is across all the…
-
What is and when should the "Synchronize Transaction Workflow Status" process be run?Summary Listed in Scheduled Processes is "Synchronize Transaction Workflow Status" with description "This process ensures that the workflow status is updated correctly i… -
How to Fix Height of table In An RTF TemplateSummary: Hi Team ,Can anyone tell me how to Fix Height of table In An RTF Template. Example: If table has 1 or 10 invoice the height of table should be same. I have chec…
-
How to send an ESS job output on email?Summary: Need to send an ESS job output (ex: .pdf) on email, to certain people Content (required): Needed functionality: send ESS job output on email. Tried from: Schedu… -
Remaining Life of an Asset in Fixed AssetsContent What is the query to calculate the remaining life of an asset year and months wise in oracle fixed assets.?
-
How to add Hyperlink to BI Excel template fieldSummary: We have a requirement to show Oracle AR Invoice Page and when click on Invoice Number in BI Excel template. Excel template has list of Invoice Numbers and its d…
-
How to schedule FRS reports in Fusion FinancialsSummary: I need to run an FRS report in Fusion Financials using scheduling. In EPM the process would be to create a batch and then add the batch to the schedule. In Fusi…
-
Scheduling "report" based on column with user emailSummary: I developed an SQL report on OTBI and an EXCEL output should be delivered to corresponding users. There is a column containing email address of the user and use…
-
Newsfeed vs Banner vs PanelSummary Default Home Page Layout OptionsContent Is there a recommended option for Default Home Page Layout? Are there benefits of going with one over the other? Looking … -
Request Read Receipt while scheduling BI ReportsContent I have scheduled a BI report and enabled Request Delivery Status Notification and Request Read Receipt Option. But I havent received any email or notification af…
-
Searching in Reports and Analytics using the magnifying glass icon giving internal server errorSummary: In reports and Analytics, users wanted to search for some related reports and so by using the search option(magnifying glass icon), they entered some options an…
-
How to fetch only current/latest updated eff data from EGO_ITEM_EFF_B table?Hi, We need to extract current item eff data. We are using EGO_ITEM_EFF_B for fetching the same. But this table is fetching all the values updated for effs till date. Bu…
-
Can we data mask certain fields within BICCSummary: As Oracle provides BICC as a tool to extract data from Oracle Fusion Cloud through UCM for customers to further analyze or report this data. We have a legal req…
-
OTBI Report for General Ledger - Journals Real Time Not Displaying Correct AmountsSummary: Entered Credit & Debit Amounts and Accounted Credit & Debit Amounts are not displayed correctly in the OTBI Analysis using the General Ledger - Journals Real-Ti… -
Submit button is disabled for Trial Balance Report ESS JobSummary: When user is running the Trial Balance Report ESS Job, Submit button is disabled.
-
Seeking Innovative Solutions for Stale Dated Check Letter Report in Oracle Fusion ERP CloudSummary: Hi Team, We're developing a report to identify stale dated checks, specifically those exceeding 180 days from their issue date. Our goal is to automate the dail… -
List of Special character which cannot be loaded through FBDI file.Summary: We have around 50 Inbound integration from various sources for GL, AP, AR, PO, Receipts. We have observed that if special characters are present in the file lik…
-
Redwood Impact for Oracle Cloud FinancialsWe have been working on the HCM side for the Redwood updates and wanted to confirm the impact that Redwood will have on the Oracle Cloud Finance side. Please let us know…
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Deve…
-
Can you run a process and have the report/file generated from the process sent to a set folder?Hi Everyone, Is it possible to have a process run adhoc or scheduled and when the process finishes the report output is sent to a file/folder location? For example, if o…