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
-
Customize seeded report "Award Approval Notification Report"Summary: We need to customize this seeded report "Award Approval Notification Report". We have made the changes as per the process but the Award approval notification is… -
Pass parameters from excel to BI Publisher reportSummary Pass parameters from excel to BI Publisher reportContent Hi, I run BI publisher report directly from excel by using soap and it works ok as long as i don't use a… -
Report gives an errorI created a excel template report which data model is working fine but when i run the report which is excel template its give me an error Error The report cannot be rend… -
Audit Report for OTBI Reports Metadata ChangesSummary Audit Report for OTBI Reports Metadata ChangesContent Hi Gurus, It is year end Audit time and we need some information on the changes made to "Key Reports" durin… -
Unable to get parameter values using ExternalReportWSSService - getReportDefinitionSummary: Content (required): Using the below WSDL and Operation: WSDL: https://xxxxxxx.xx.****.oraclecloud.com:443/xmlpserver/services/ExternalReportWSSService?WSDL Oper… -
How to create Report Filter that only provides results based upon Current DateSummary: I have a BI report with I need to retrieve all transaction created on current date Content (required): Report is BI Publisher Report based upon Receivables Tran…
-
RTF Template - To Display Total Amount in last row of the pageSummary: Hi All, We have requirement to display Total Amount only in the last row of the last page, even if the report data ends middle of the page Total should be displ…
-
How to add standard report icon in springboardSummary: I have a requirement to add icon of a standard BIP report in springboard. I am using static URL to create page entry. We cannot open a standard BIP report from …
-
How can I display a CLOB column value in a Data Model created from Oracle BI EE data source?Summary: Unable to display a CLOB column value in a Data Model created from Oracle BI EE data source Content (required): I have created a data model from a OTBI subject … -
How to Pass Parameter value Of All in REST APIWe use REST API to call BIPublisher report - we are able to pass specific values in the parameters however if the report parameter has a Value of All (aba.batch_name in … -
How to get list of all the reports that are run in the last 3 monthsSummary: Is there a way to get list of all the reports that are run in the last 3 months in Oracle Fusion(Not just ESS Jobs but also run directly in catalog). Content (r…
-
Adding and embedding BI content into Fusion Cloud ApplicationsSummary Looking for guidelines on which Fusion Cloud Applications pages we can add or embed BI content intoContent Hi All, Our client wants to be able to add some BI con…
-
Award Project amountsSummary: Award Project amounts Content (required): Can you please help me with table name or query to extract amount on Manage Award --> Open award --> Financial Perform…
-
How do I implement custom barcode fontSummary: We have a requirement to print barcodes in BC3of9 and Code128 fonts. We implemented using the delivered Oracle-supported fonts. However, the client tested and s…
-
Is it possible to report on requisition approval volumesSummary: Our business users are asking for reports to see who has approved purchase requisitions made in the business so that they can track volumes etc. Does anyone hav…
-
How to add Asset Category and Project Number to What-if Report?Summary: We are trying to add Asset Category and Project Number to the code of the delivered What-if Report. Please see attached SQL. We added a few joins, but the resul…
-
Asset Number not displaying in ascending order in OTBI reportSummary: OTBI report using Fixed Assets - Asset Depreciation Real Time displays asset numbers different sort order. screen shot attached. How to display asset numbers in…
-
Table details which store scenario present on Inquire on Detail BalanceSummary: Table details which store scenario present on Inquire on Detail Balance Content (required): Version (include the version you are using, if applicable): Code Sni…
-
Delete: ID10T error!Summary: Content (required): Version (include the version you are using, if applicable): Oracle Fusion Cloud Applications22B (11.13.22.04.0) Code Snippet (add any code s…
-
QR CodeSummary: Normally we will add one field/ concatenate more than one field to generate the QR code from oracle bip rtf template, can we generate QR code for complate XML f…
-
Business Process training and certification for Oracle Cloud Applications is now availablePrepare for successful Oracle Cloud Application implementations with a common foundation of business process knowledge across all teams. Learn more about how new Busines… -
Print Receivable Transaction Program sending invoice to all contacts of an accountSummary: Print Receivable Transaction Program sending invoice to all contacts of an account despite invoice having a single contact associated. We have an invoice in our…
-
Same report two different envonments different date formatsSummary: We created an OTBI report and the template specifies the field with a date format. We are trying to force the mm/dd/yy date in there. It works in our test envir…
-
ESS Job Report Output File NameSummary: Content (required): We used Bursting to set the file name of the report. It is displayed correctly on the ESS Job screen but when we click on the file to downlo…
-
Calling BICC Rest API Service in ODISummary: Calling BICC Rest API Service in ODI 12c Content (required): Need help to know the step by step configuration for calling BICC Rest API services from ODI . How …
-
Can BI Deep Link use variable to represent the servername in the URLSummary: Deep Links present an issue during P2T environment copy downs because after each refresh all Deep Links embedded in BI report definitions have to be modified, i… -
How to Schedule a CUSTOM BI Publisher Report with Dynamic Date ValuesSummary: Content (required): I want to schedule a custom BIP report with dynamic date and run time should be Daily. Date parameter should pick current system date every … -
Display and ability to change parameter values in OTBI reportSummary: In BI Publisher report, report parameters are displayed and user can change the parameter values and run the report all on the same screen. Can the same be done…
-
BI Template Sum Function Not Working ProperlySummary: The Sum function in the BI template not working as expected. Content (required): We have a custom report where we used the sum function on specific field but it… -
Performance Issue caused after 22B upgrade for CF Activity ReportSummary: Hi Team, We have performance issue in our report after 22B update. Regards Nidhi... Content (required): Version (include the version you are using, if applicabl…