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
-
Need to fetch the amount( Debit - Credit) from XLA tablesSummary: Need to fetch the amount( Debit - Credit) from XLA tables Content (please ensure you mask any confidential information): We developed the query to fetch the amo… -
How to submit BIP Report in oracle fusion with soap webserviceSummary: How to submit BIP report in fusion with soap Webservice https:///xmlpserver/services/ExternalReportWSSService In this soap webservice need sample payload forsub…
-
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…
-
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…
-
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… -
Submit button is disabled for Trial Balance Report ESS JobSummary: When user is running the Trial Balance Report ESS Job, Submit button is disabled.
-
How to retrieve Custom Child Object and Custom Field in BI PublisherSummary: Hi, Would like to check how do I retrieve Custom Child Object and Custom Fields in BI Publisher? For example, under the SCM»Innovation Management»Proposal - I h… -
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?…
-
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 : https://www.oracle.c…
-
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…
-
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…
-
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…
-
Automating BI Catalog archivingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
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… -
We are trying to access OTBI Reports on Screen Cloud using RSS Feed optionSummary: Not able to access the OTBI reports in the screencloud or any RSS platform. Content (please ensure you mask any confidential information): RSS Feed Version (inc…
-
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 …
-
How to send excel output to legacy systemHi, We have a custom ESS job and generates the output in excel format and can't enable it in csv format as it's exporting all the columns which we don't want. We have a …
-
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…
-
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…
-
Oracle Fusion BI Publisher - Pivot table - Dynamically derive headerSummary: Hi All, We have a requirement where we have to calculate opening balance of a fund(GL_CODE_COMBINATIONS.SEGMENT6) from GL balances and pivot it to the fund name…
-
General Ledger Balances Real Time OTBI not fetching Cost center values from COASummary: I am using General Ledger Balances Real Time Subject Area to extract all COA value set values and i am able to derive all COA values except for Cost center, Onc…
-
Payment Approval HistorySummary: We need the payment approval history data to capture the approvers at template level Content (please ensure you mask any confidential information): Hello Team -…
-
How to use if statement for comparing dates in BIP templateSummary: How to use if statement for comparing dates in BIP template Content (please ensure you mask any confidential information): I have customised the Customer Statem…
-
How to increase the attempts to fetch UCM document ID from Oracle Fusion ERP CloudSummary: We have ESS job in source Fusion and we running it from data management side. Sometimes job run long and not able fatch DocumentID. How to increase the attempts…
-
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…
-
How to Link a Column in OTBI to a Parameter Based on Conditions?Hello, I am working on a report in Oracle Transactional Business Intelligence (OTBI) and I need some help with linking a column to a parameter based on conditions. Speci…
-
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…
-
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…
-
Issue on Transaction Class in Receivables TransactionCredit memos always have "Credit Memo" as the transaction class. But some of the Transactions were populated on the report as "ONACC" as Transaction Class instead of "CM…
-
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…