Category 129
Discussion List
-
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 32 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 - National Heritage Academies 33 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 11 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 22 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 113 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…
-
How to create a new KPISummary: How to create a new KPI Content (please ensure you mask any confidential information): Hi Team, How to create a new KPI reports for Finance? Could anyone guide …Venkatesan 1 view 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Project Resource varianceI have created an analysis that reflects the variance of actual cost to the budget at resource level and also the variance of the same cost but related to the whole proj…Mohamed Abdelbar 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to add category parameter to account analysis reportSummary: We need to add category parameter to customized account analysis report and it runs into error "'P_CATEGORY' must be declared ORA-06550: line 2, column 1: PL/SQ…Akshitha Vyas 11 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Unsupported use of WITH clauseSummary: My custom report is producing the error of Unsupported use of WITH clause Content (please ensure you mask any confidential information): I have developed a repo…Chez 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Different Checklist IDSummary: Checklist_ID is always equals to Task_ID for the task associated with the particular checklist. do there is some cases where it can be different, please help. C…Yashpal_Mahto 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
FR WEB: What is the audit option in FR EPBCS?Summary: What is the audit option in Financial Report EPBCS ? Content (please ensure you mask any confidential information): What is the audit option in Financial Report…
-
Allocation percentage for resources in the projectSummary: Hi everyone, We're looking to gather details on project resources, specifically allocation percentages. It's important that these resources are currently assign…
-
How to enable Export options when analysis added to Reports and AnalyticsSummary: Enable export options below a report from an analysis Content (please ensure you mask any confidential information): We have created custom analysis and made th…Alexandre Chea-Oracle 156 views 10 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Using BICC with UCM - Expected CostSummary: I am intending to use BICC (Business Intelligence Cloud Connector) in combination with UCM as an external Storage. What are the costs I can expect related to th…FusionAnalyst_95 122 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Why OTBI report output file in excel is not showing morethan 25000 recordsSummary: Is there any OTBI Developer can help me resolve this issue. If the output excel file of AD PO ALL PURCHASE ORDERS Report is morethan 25003 records it is skippin…
-
BI Report Exported Data Wrong in Date but Become Correct after ReopenSummary: When I exported the report data. I find that when I chose the period like from 2024.06.01-2024.06.30. but the export date period in the report parameter will be…
-
How to include attachments from the main transaction page into a custom reportSummary: Hello team, greetings for the day!! I was asked to develop 'AR Payment Plan' bursting report which triggers an email consists of 3 PDF pages. out of those pages…
-
Custom Folder is unavailable to all the UsersSummary: Our users are not able to see the Custom Folder under Shared Folders All our reports are in the Custom folder. Possibly -mistakenly the permission of the folder…
-
Navigation to ERP AnalyticsSummary: Hi All We have client that buy ERP Analytics license. How to navigate to this ERP Analytics? You can check the screenshot using this link : But, I dont know how…
-
Oracle Fusion Workflow Report for all pending transactionsSummary: Is there any seeded Report available for all pending Workflows (PR,PO,AP Invoice, Payment, GL Journals, Expenses, HCM, PPM, OTL,etc). The report should show tra…
-
OTBI PO Balance Report to Tie to Budgetary Control Obligation BalancesSummary: I am attempting to build an OTBI report that will pull PO balances by PO that will ultimately tie to a cost centers obligation balance in Budgetary Control. We …Ashley Dore 21 views 1 comment 0 points Most recent by Andra Maria Popescu-Oracle Reporting and Analytics for ERP