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
-
Licenses for Development ToolsSummary: Hello All, We are using the below development tools provided in Oracle Fusion and want to know if any additional licenses are required apart from Oracle Fusion … -
Assets - The following segment labels have misspelled BI Object Name setSummary: Hi What are correct spelled BI Object Name set for Assets. I have hit the following error: Regards, Bo Content (please ensure you mask any confidential informat…
-
SOAP Web Service to download attachmentsSummary: I'm trying to download attachments using ERP Object Attachment Service () but I'm getting an error: An error occurred: JBO-Request Failed : Reason- User did not…
-
removeposted to the wrong place!
-
Access to Project Budget vs Actual and Project Capital Costs reportIs there a specific privilege or data policy to access Project Budget vs Actual and Project Capital Costs report? Project Accountant gives us access however it has too m…
-
ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMPSummary: we have one custom report keeps failing with error ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMP in saas application. could you plea…
-
How can I replicate data from a pivot table in an RTF report (BI Publisher)?I have a report for transaction build using BI publisher what is giving is the customer X is shown just once with multiple transaction what i want is to have the custome…
-
Oracle BIP Report Not SummingI need your help in my RTF template that has a sum for every each segments. I added the field in the cell, set the Calculation to Sum and checked the Grouping. Generated…
-
Can we get ZPL output for Zebra Printer from Oracle BI PublisherSummary: We need to get ZPL output for Zebra Printer from Oracle BI Publisher. Is it possible to get that. Please advise. Content (please ensure you mask any confidentia…
-
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 …