Reporting and Analytics for ERP
Discussion List
-
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 …
-
Calling Sub template -IssueSummary: calling Subtemplate from main template is working fine for one user and is giving error from another user. Content (required): We have created a custom job to r…
-
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…
-
Merge Two OTBI Subject AreaSummary Develop a OTBI report by Merging two OTBI Subject AreaContent I have a requirement to develop OTBI report using two OTBI subject areas. Following OTBI subject ar…
-
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…
-
Query or report to show B2B Communication details for each supplier siteSummary Query or report to show B2B Communication details for each supplier siteContent Is there a query/analysis/report/data model, etc. available in OTBI to show which…
-
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…
-
API to update SSH Key every 90 days in Oracle BI Admin and Manage Transmission ConfigurationSummary: Content (required): Is there any API to update SSH Key every 90 days in Oracle BI Admin and Manage Transmission Configuration Version (include the version you a…
-
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…
-
Backend table for Payment process request statusSummary: Need to fetch payment process request status from backend Content (required): Hi There, we are building a report where in the customer needs the payment process…
-
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…
-
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…
-
Is there a REST API to get the submission and completion time details of an ESS Job ?Summary: Is there a REST API to get the submission and completion time details of an ESS Job ? Please provide pointers if available. Dhruv