Category 129
Discussion List
-
How to configure an additional Input parameter in Account Analysis Report XLAAARPTHello, We have a requirement to add additional department type Input parameter as a filter in BI Account Analysis Report XLAAARPT. This report is being run through the E… -
How to schedule an OTBI report to generate monthly with dynamic prompt?Summary: We have an OTBI report that contains a datetime prompt. I'd like to schedule the OTBI report to run each month and have the datetime prompt automatically popula…Steven Woods 51 views 7 comments 1 point Most recent by Steven Woods Reporting and Analytics for ERP
-
Cannot Deliver More Than 75K Lines to an OTBI reportSummary: Hi, The customer needs to extract data from an OTBI report with more than 75,000 rows. How can we change this limit, which is already pre-set in the report? Cur…Silas Henrique Silva 21 views 2 comments 0 points Most recent by Silas Henrique Silva Reporting and Analytics for ERP
-
Migration of FRS reports from one server to anotherSummary: Hello, I want to migrate my FRS reports from test to production server. After archieve and unarchieve, I changed my database connection as well but it didn't wo…
-
Display days of a week in order using rtf templateI have a rtf template which is using days of week to display receipt totals for each day for different entities I am using pivot table to display data weekday vs entity …Ninad Joshi 13 views 1 comment 1 point Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
HCM OTBI Report on all absences with a future or missing end dateSummary: Our IT dept are having a hard time identifying logins that are due for auto deletion due to inactivity but that actually need to be kept open (eg those on long …KerryanneLee 16 views 3 comments 0 points Most recent by KerryanneLee Reporting and Analytics for ERP -
Approval History - AP Invoice Account Coding Workflow Notification CustomizationSummary: We need to customize "AP Invoice Account Coding Workflow Notification" to display approval history using SQL Query. In BPM Workflow notification we can see the …Surya Chandaka 81 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Fixed Asset Register report is not working when you select a date in the past like OCT 2023.Summary: Fixed Asset Register report is not working when you select a date in the past like OCT 2023. it only returns the current Open period after running depreciation.…
-
Budget Transactions - Original Estimate / Revised Estimate - where are the tables??Summary: I am looking for the Oracle transactional tables that are posted to when creating budgets (not control budgets but 'reporting' budgets and not balances but tran…Robert of STAU 21 views 4 comments 0 points Most recent by Robert of STAU General Ledger & Intercompany
-
Get Recipients from the Analysis as Task Owners from Project Subject AreaSummary: Cannot set dynamic recipients of an email with analysis. The standard functionality should be available using an Agent. The agent was setup for an analysis done…Dejan Begovic 1 view 1 comment 0 points Most recent by Andreea Versanu-Oracle Reporting and Analytics for ERP
-
Unable to see requests run by service account.Summary:Unable to see requests run by service account. We have few service users defined through which we run some scheduled jobs. Recently we have created new service a…Niraj Kumar 1 view 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to find indexes really used in OTBI - Subject Areas ?Summary: How to find indexes really used in OTBI - Subject Areas ? The document R13_23D_FIN_OTBI_database_mapping_with ViewObjects.xlsx doesn't give really indexes used …LaurentDup 31 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
AR_STATEMENT_HEADERS and AR_STATEMENT_LINE_CLUSTERS are interiam tablesSummary: AR_STATEMENT_HEADERS and AR_STATEMENT_LINE_CLUSTERS are interiam tables. Content (please ensure you mask any confidential information): We are looking actual ba…
-
Need Outstanding Check Report in Oracle fusionSummary: Hello, We are looking for a report that shows payments that were issued but have not cleared the bank account yet. Is there any report already available in Orac…Sushmitha G 128 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Customizing Accrual Reconciliation report and status is Retrying when running ess jobSummary: Customizing Accrual Reconciliation report and create a new custom ESS job by copying standard ESS job but when running it then the status is Retrying Standard E…MANOJVERMA090908 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Issue Number formating causing reporting issuesDear All, The format of numbers in the purchase order standard report are not displayed correctly, because the NLS_NUMERIC_CHARACTERS setting is not configured at the da…George Mattar 33 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
how to exclude not applicable journey tasksHow would we exclude tasks that have been 'Marked not applicable'? I seartched the PER_ALLOCATED_TASKS and PER_ALLOCATED_CHECKLIST tables and could not find the field th…
-
Query or the table that contains columns of the Account Analysis ReportSummary: Content (required): Hello everyone, I have a requirement to make a custom report for the Account Analysis Report. I need to pick some of the columns in the seed… -
YTD balance (ending balance) for each source, category and accountHi, We have a requirement to develop a BI report to fetch YTD balance for each source & category. In this case , I cannot retrieve YTD balance from the gl_balances as th…
-
Audit Report for Oracle backup Log in Oracle fusionSummary: Hello, We are looking for report where the Oracle system backs up all data, libraries, applications, and user profiles daily/on a regular basis. Is there any re…
-
How to delete chart of accountsSummary: How to delete chart of accounts Content (please ensure you mask any confidential information): Hi All, How to delete chart of accounts which is defined wrongly?…Venkatesan 14 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Printing multiple report prompts in FRS report out of ERPSummary: We have an FRS report where the report prompts for company and the user can choose multiple companies. The report output is the total of all of the chosen compa…K McMillan 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Additional levels listed in OTBI for GL segments in GL Subject AreasSummary: We have levels listed for all of our GL segments in OTBI. We would like to know where these come from and if there is a way to remove them from OTBI if possible…Kristina P 31 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Member Selection on FRS ReportWe have business requirement to rename tree version via Manage Account Hierarchies. We able to make the changes but we encountered some unexpected changes in our FRS Rep…Aaron Leus 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Export a FRS report book to excel where each report exports to separate tabSummary: I have seen the question posted but am not able to find an update after 2019. Is there yet a way to export a book with 15-20 reports in it to excel with each bo…K McMillan 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
How can we see who/if someone has created a database connection in FRS?Summary: We have noticed an extraneous database connection in FRS that is not one of the ones we have created ourselves in our production environment. Is there a way to …
-
Future dates (i.e. 1/1/3000) appear as null or blank in OTBI analysis results for ContractsSummary: Using the "Enterprise Contracts - Contracts Real Time" subject area, the analysis/report doesn't display some End Dates even though they appear on the Contracts…Dawn Tilson 12 views 1 comment 0 points Most recent by Alexandra Rabaea-Support-Oracle Enterprise Contracts
-
Reconciliation Report using Supporting Reference segmentsWe have a reporting requirement to track a transaction (together with natural account) from GL to subledgers. A DFF is created at Journal header level to capture 'Transa…Kalyani-Oracle 23 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
24A ERP OTBI subject areas to database tables mapping spreadsheetsSummary: 24A ERP OTBI subject areas to database tables mapping spreadsheets Content (please ensure you mask any confidential information): Where can I find 24A SCM and P…Bea 65 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Pivot using Mulitiple groupsSummary: I have a requirement to have supplier response and prices details based on the items. Suppliers, Response and its prices should be in Pivot format. We are unabl…