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
-
Support Incremental is not enabling for BICC extractSummary: Hi Team, we are using application composer custom objects and looks like supports incremental is not getting enabled to this like it happen for seeded ones. Can… -
Inquiry Regarding Dynamic User Inclusion in Report Emails via BurstingSummary: Hi Oracle Experts, We have received a request from our users to include the username of the individual executing a report in the email body after the "Thanks" s… -
How to update Data Time Zone offset in the Data Format tab of Column PropertiesSummary: OTBI report using Posting Date can be displayed in Sydney timezone but when it is used in a calculation in Edit Column Formula, it reverts back to UTC timezone.…
-
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…
-
Capture change in TAX lines on RA_CUSTOMER_TRX_LINES_ALL on BICC extractionSummary: As per business, we understand they could change the Invoice Tax lines attached to a given invoice in Fusion. Since we maintain the Invoice Lines data in TRANSA…
-
How to install oracle report builder to read legacy reportsHi All, we are in process of decommissioning r12 as we have moved into cloud. For reporting purpose we need some of the custom, standard rdf reports and their underlying…
-
Splitting Of master detail records into new detail result if detail data exists more than 2k recordsSummary: Hi Team, We have a requirement to develop master detail report with master data set containing header level details of transaction and detail data set containin…
-
How to show the data label (Count) in all the colors of Stacked Bar Chart in the RTF Template?Summary: We have a requirement to display the number as data label in the RTF Template – Stacked Bar Chart. The count is being displayed only in one colour and it’s not …
-
Custom Report error out due to in put string ending with "."Hi - We have a custom report which uses XSL Stylesheet which errors out due to input string ending with "." which is a valid value. I would like to ask how we can modify…
-
Error in OTBI report while using 2 Procuement subject areasSummary: I am trying to create a OTBI report to understand Non catalog Requisitions which are not created from Smart forms. For this i am combining 2 subject areas namel…
-
OTBI Bad Performance- After Adding Accounting Class Code - Subledger Accounting - Journals Real TimeSummary: Using subject area Subledger Accounting - Journals Real Time, for example looking at source: Projects with a filter on natural account/concatenated segment and … -
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 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 …
-
Will Oracle provide NAUPA Reporting format for unclaimed property filings to State?Summary: State of Illinois requires electronic reporting for the unclaimed escheatment property. Will Oracle Fusion create a reporting format in later releases to accomo…
-
facing trouble in printing repeating fields on PDF templateWe are having an issue on PDF template where we need to print multiple invoice lines on an invoice but issue is that we have to fix the space on template where these lin…
-
In Event Triggers: Alternative solution for passing multiple values into a single parameterIn event triggers, I need to pass a multiple values to a single parameter and upon research I realized that oracle does not provide such feature. I need a alternative so…
-
Is there a way to delete data from FND_SESSION_ATTRIBUTES, FND_SESSIONS tablesSummary: Hi Fellow Developers, The requirement is to delete all data from FND_SESSION_ATTRIBUTES, FND_SESSIONS tables for security reasons. Content (please ensure you ma…
-
Is it possible to schedule a BICC job to run twice in a day? If yes, how can this be achieved?Summary: My goal is to schedule a BICC job to run twice in a day but turns out its not possible to have 2 active schedules for a job Content (please ensure you mask any …
-
general ledger journals via subledger to receivablesSummary: BI publisher → SQL → Journal General Ledger Journal Data joining to Receivables at distribution level of detail Content (please ensure you mask any confidential…
-
็How to custom Trial Balance ReportSummary: How to custom Trial Balance Report by adding Filter Conditions accounting segment in Trial Balance Report Content (please ensure you mask any confidential infor…
-
Requisition Approvals History - Approval history has been purged and no longer availableWe are getting the error 'Approval history has been purged and no longer available' when to view document history in requisition and purchase order. Is there any tables …
-
How to print "All" value in the output if BIP report is run for all parameter valuesHello Oracle Gurus, I have a requirement where the user is running the report with all parameter values. The parameter is Source. Currently if the user runs the report f…
-
What are the tables or SQL query to fetch ESS job name, Report name, Report path detailsHi Team, I have requirement to develop custom SQL query to fetch details like All ESS Job names, Display names, Report names, Report paths etc. I have used tables like E…
-
how to get json formatSummary: Hi, We've a requirement to format output into Json format. Is it possible to do OTBI / BIP Report in this format? Any help is highly appreciated. Thank you! -
Drill Down To Fusion Financial Applications from OTBI ERP ReportsSummary The purpose of this White Paper is to demonstrate how users can drill from Oracle Transactional Business Intelligence (OTBI) adhoc reports to transaction details… -
Automatically create a prepayment invoice from POSummary: Is there a way to automate the creation of prepayment invoices in AP from a PO? We would like to be able to create a PO and somehow specify the PO is expected t… -
SQL for Project Events InvoiceSummary: Trying to get the approved Invoices only and I am getting incorrect values. Content (please ensure you mask any confidential information): Code Snippet (add any…
-
FUSION_APPS_PROV_PATCH_APPIDSummary: we saw in audit log that the user- Provisioning Patch Application Identity - user ID: FUSION_APPS_PROV_PATCH_APPID has added the role ORA_FND_APPLICATION_DEVELO…
-
OTBI DocumentationContent i need a documentation in OTBI , or videos .
-
How to Include Accounts with No Activity in customized reportContent Dear , I create customized trial balance report. in which i create a opening balance but in some accounts its shows wrong data. so i figured out and now i want t…