Category 129
Discussion List
-
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 192 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 123 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…
-
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 -
Job Definitions Created Did not Connect to BIP reportSummary: l need to create job definitions to run reports as scheduled processes. However after l maintained the job definition and BI report's property, the schedule pro…Abby Chen522 61 views 11 comments 1 point Most recent by Lucky Sharma Reporting and Analytics for ERP
-
The search is not working in the drop down menu in Data set BU publisher reportI have this parameter that is related to a list of value that give all the contract number. the query i am using for the list of value is: select DISTINCT TV.CONTRACT_NU…Omran Zeaiter 52 views 1 comment 0 points Most recent by Andreea Versanu-Oracle Reporting and Analytics for ERP
-
can we fetch report for how many times a report runHi Everyone, we have a requirement to fetch the all custom reports in the fusion, along with their information of how many times that report run in 2024 and what is the …
-
open PO report with receipt datesSummary: We are trying to build a report with open POs and their associated receipts. Content (please ensure you mask any confidential information): Requirements are ori… -
Parameter values to pass to save update Data model of Subledger Period Close Exception ReportSummary: Customer is looking for Customized Subledger Period Close Exception Report to add Supporting Reference columns. Thus looking for an input to know which valid va…
-
where are segment member aliases stored in the oracle financials database?Summary: Where can I find the aliases for individual segment members in the oracle financials database tables? Content (please ensure you mask any confidential informati…josstenger 1 view 1 comment 1 point Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Custom role Project Administrator and Cost Controller cannot see AnalyticsThe custom role that we made Project Administrator and Cost Controller should be able to see the Analytics Widget with Project Dashboard information. However its missing…Fred Benedict 1 view 3 comments 0 points Most recent by Fred Benedict Reporting and Analytics for ERP
-
What is the impact of General Ledger Segment Security on OTBI reportsOracle document 2486655.1 refers to a document which state in Page 26 he operator "Is last descendant of" is not currently supported for Segment Security Conditions in O…ramesh.sivapalan 31 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Convert English numbers into Arabic numbers in rtfI used function to calculate the summation of the VARI variable in the page and used this to show the number in footer, I need this number to be displayed in Arabic, n…Salma Mohamed Salem 81 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Project receivable invoices payment statusIs there any analysis or OTBI subject area that can help in tracking the Project AR invoices status based on the applied amount. the image below is captured from the man…Mohamed Abdelbar 1 view 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to download entire Data ModelsHello, We have created an update of a very complex data model and would like to compare it with the old one. We remember that in the previous versions it was possible to…simonl 51 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to export 500K rows from OTBI report into ExcelSummary: We have a report where total data is coming close to 500K and we are only able to export 25K in Excel, is there is any way to do this? If I develop this in BI P…Sam Samaddar 57 views 4 comments 0 points Most recent by Sam Samaddar Reporting and Analytics for ERP
-
What is the field where I can check the inactivated date of user in fusion.Summary: I want field where inactive date of user gets stored . Also if I delete some role from user I want to have when did I delete the role. Also in Front end I am ab…
-
Execute SQL Query against Cloud ERP/HCM without using DataModel/BI ReportSummary: Hello, Usually Oracle Fusion BI Report/Data model was used to create SQL(like "select * from poz_suppliers_int") against Fusion DB ( like ApplicationDB_FSCM,App…Vetrivel J 603 views 10 comments 0 points Most recent by Shyam Patel Reporting and Analytics for ERP
-
24B INV_ORGANIZATION_DEFINITIONS_VHi , We were using the following query and post 24B its not fetching data set for users who are restricted for specific BU. Let me know if any one are facing similar iss…Rakesh Sreenivasa 85 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Procurement - Purchasing Real Time project DFF missing after 24B updateSummary: Procurement - Purchasing Real Time project DFF missing after 24B update. This was working fine before the update. Did this get removed from the subject area? Co…MichelleHaynes 13 views 2 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Need to know the table and api for Fusion application notification setupWe want to know the tables and web service APIs of the below two locations of notification setup. As we are creating bip reports and integrations for the same. Navigatio…
-
Not able to rename or delete existing folder in BI catalogSummary: Content (please ensure you mask any confidential information): Hello All, Hope you are having a great day. We are facing an issue while renaming a folder in BI …Lucky Sharma 31 views 5 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP