Category 129
Discussion List
-
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…Mirza_Adeel 26 views 10 comments 0 points Most recent by Mirza_Adeel Reporting and Analytics for ERP -
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…Vinay Gharge 3 views 4 comments 0 points Most recent by Ramneek Grover-Oracle Reporting and Analytics for ERP
-
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…LE 24 views 7 comments 0 points Most recent by Ramneek Grover-Oracle Reporting and Analytics for ERP
-
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…User_T8NOH 5 views 1 comment 0 points Most recent by Ramneek Grover-Oracle Reporting and Analytics for ERP
-
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 …AeeTee 11 views 1 comment 0 points Most recent by Ramneek Grover-Oracle Reporting and Analytics for ERP
-
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…Amarnath G 14 views 2 comments 0 points Most recent by Ramneek Grover-Oracle Reporting and Analytics for ERP
-
22C PORTAL UPLOAD AS A DELIVERY METHOD FOR CUSTOMER TRANSACTIONSOracle has introduced this feature in 22C - I wanted to check if anyone has used this - I do see that delivery method LOV has a new value but I do not see where we need … -
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 …Sujay Bandyopadhyay-Oracle 7 views 2 comments 0 points Most recent by Sujay Bandyopadhyay-Oracle Reporting and Analytics for ERP -
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…VinayGeddam 19 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
FRS Heading not Centering in Excel exportSummary: Content (required): I have an FRS report that has about 13 columns. The header is centered across the report with the ability to autosize. Looks great online bu…Cathy Watson Moore 5 views 0 comments 0 points Started by Cathy Watson Moore Reporting and Analytics for ERP -
Did You Know? Accounting Period Close Exceptions DashboardSummary Sample dashboard that gives you an overview of your accounting period close exceptions Content The attached sample dashboard gives you an overview of your ac… -
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…Nidhi Chhajed 1 view 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
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…
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter …Rohan Lobo-Oracle 8.7K views 58 comments 20 points Most recent by User_3ORPJ Reporting and Analytics for ERP
-
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…Dawn Morgan 1 view 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Is there a subject area for Chart of Accounts in OTBISummary: Is there a subject are for Chart of Accounts in OTBI? Content (required): Looking for a Chart of Accounts subject area so that I can build an OTBI report Versio…
-
OTBI QuestionsSummary: Content (required): In "Payables Invoices - Transactional Real Time" subject area, why do we have so many invoice currency fields and why some of them are givin…
-
Adding Distribution Information to Payables Invoice InquiryYou can extend pages with custom OTBI reports, for example with budgetary control charge account and projects information is useful when viewing invoices. The Embedded I…Anne Wong -Oracle 160 views 2 comments 6 points Most recent by Alex Glose Reporting and Analytics for ERP -
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…Brad Kirschner 2 views 0 comments 0 points Started by Brad Kirschner Reporting and Analytics for ERP
-
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…Nidhi Chhajed 12 views 8 comments 0 points Most recent by Nidhi Chhajed Reporting and Analytics for ERP
-
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…Sahil Makhiza 11 views 3 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
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…Dhruvjoshi23 15 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
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…FELLOW02142022 11 views 9 comments 0 points Most recent by FELLOW02142022 Reporting and Analytics for ERP
-
Create List of Values for Dependent Segments in GL Custom BI Publisher Reports White PaperSummary: Your finance staff may modify standard GL BI Publisher (BIP) reports to address specific business requirements. They may need to run a GL BIP report by various …Helle Hennings-Oracle 38 views 1 comment 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP -
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…Vinay Gharge 16 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP