Category 129
Discussion List
-
BI Publisher Excel TemplateSummary: How to display a column conditionally in BI Publisher Excel Template? Also I want to display a hard image in excel based on condition of data source in excel te… -
Outbound Integration - Every one hourSummary: Outbound Integration - Every one hour Content (required): Hi All, We got the requirement for GL Journal outbound integration through BI report. The job should r…Venkatesan 62 views 9 comments 0 points Most recent by Sandeep S. Chauhan-Oracle Reporting and Analytics for ERP
-
Oracle Fusion BI Catalog Folder ControlSummary: Oracle Fusion BI Catalog Folder Control Content (required): We have encountered multiple times where users have accidently moved or made changes to BI Catalog F…Rihan Jameel 61 views 4 comments 0 points Most recent by Rihan Jameel Reporting and Analytics for ERP -
Financial Reporting Webstudio Performance IssuesSummary: Oracle closed out the old discussions on this topic. We are still facing (on 22B) performance issues with Financial Reporting Webstudio. We are interested to he…
-
How to send BI Publisher reports to FTP folder from ESS jobSummary: How to send BI Publisher reports to FTP folder from ESS job Content (required): Hello All, I will appreciate your support in the following: When I schedule the …Bernard T 765 views 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Report that shows project codes and cash receipts associated with that projectSummary: I am working on generating a report that shows both the project codes and the associated cash receipts/revenue detail with regard to that project - grant revenu…
-
Working on PO detail report that includes change ordersSummary: I need to create a detailed report that shows all PO detail including all change order activities - this could also be a requisition report if that is the prope…Sara Ro 41 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
Receivables: Status Tracker in OTBI/BIPSummary: Content (required): Is it possible to report on this Status Tracker in OTBI? Or BIP? And if so which which subject area or which tables are these to find in? St…Nicolas Vahman 207 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
How to convert hexadecimal to Base64 in BI ReportSummary: How to convert hexadecimal to Base64 in BI Report Content (required): Hi All, How to convert hexadecimal to Base64 format in (SQL) BI report. Need to generate Q…Venkatesan 73 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Where to find the Building Society Roll number for a supplier on OTBISummary: I'm based in the UK and need to pull together a report (preferably using OTBI) listing suppliers' bank details that includes the Building Society Roll number or…Fraser HES 188 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Fixed column for year and other columns are promptedSummary: Content (required): Hi all I would like to know if it is possible to have one fixed column which always shows the forecast for e.g. 2022 while other columns are…Nicolas Vahman 41 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Is it possible to set up triggers for BICC extractsSummary: Is it possible to trigger a BICC extract to occur only when data has changed? Content (required): We would like to extract data stores that don't support increm…Holly Wells 51 views 2 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
How to modify Asset Cost Summary ReportSummary: I'm trying to modify the Asset Cost Summary Report. I created a copy of the DM (path = /shared/Custom/Financials/Fixed Assets/Asset Balances/Data Model/Cost Sum…
-
Oracle Fusion the seeded report "Receivables Aging by General Ledger Account Report" custom steps ?Summary: Seeded Report name - "Receivables Aging by General Ledger Account Report" custom steps ? How to use the Report parameters used in this scheduled report in some …Ashish1Soni 511 views 4 comments 0 points Most recent by Ashish1Soni Reporting and Analytics for ERP
-
OTBI legal entity of AP invoiceSummary: Content (required): We want invoice header LE information in the report but as soon as we are adding payment details it starts showing payment LE information. S…Vinay Gharge 51 views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Invoices on Hold with Matching DetailsSummary: I cannot find a good screen that will show you the pricing or quantity details that are behind a matching hold, so I created this set of reports that I hope you…Pam Clark-Oracle 42 views 1 comment 2 points Most recent by Pam Clark-Oracle Reporting and Analytics for ERP -
Is there a setting in BICC so that data store extracts handle special characters correctly?Summary: We are finding that special characters are not being exported correctly in our data store extracts. Is there something we can do to export the characters correc…
-
Data missing in outbound integrationSummary: Data missing in outbound integration Content (required): Hi Experts, We implemented GL Journals outbound integration between fusion and AWS SFTP server. We have…
-
Is it possible to hide a graph prompt?Summary: I have a requirement to hide a graph prompt, because the graph is being updated by clicking in another table as a master-detail event. Content (required): It se…Anders W. Langholm 41 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
How to access the sample XML for the Printable Expense Report Template?Summary: I need to customise the Printed Expense Report Template to suit client's requirements. I understand that the seeded report does not have an associated Data Mode… -
Sequence Command for BI PUblisher eTextSummary: Sequence Command for BI PUblisher eText Content (required): Hi Folks, I'm using eText template to do payments, I need a unique id for each payment but for each …Eliel Douglas 32 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
How many columns we can have in data modelSummary: Maximum number of columns we can have in data model Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code s…Nidhi Chhajed 31 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Failing to retrieve data from presentation layer when trying to export BIP folderSummary: Our team is using the VBS pipeline to export BIP reports from the dev region to the sat region. Everything was working correctly and then it stopped working on …User_2025-03-07-05-28-28-079 31 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
How do I remove grouping of grouped columns?Summary: I have created a report with a subject area and it has worked fine... For some reason, it's suddenly decided to group almost all my chosen columns and I simply …Anders W. Langholm 32 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
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…Ashu Raj-Oracle 53 views 2 comments 0 points Most recent by Ashu Raj-Oracle Reporting and Analytics for ERP -
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 51 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 44 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 33 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 537 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 343 views 1 comment 0 points Most recent by Ramneek Grover-Oracle Reporting and Analytics for ERP