Category 129
Discussion List
-
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 41 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 33 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 33 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 41 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 41 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 31 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 521 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 342 views 1 comment 0 points Most recent by Ramneek Grover-Oracle Reporting and Analytics for ERP
-
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 331 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 51 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
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 11 views 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…Lisa Taroma 121 views 2 comments 0 points Most recent by Lisa Taroma 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…DLMorgan 21 views 1 comment 0 points Most recent by Amrita Gupta-Oracle 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 11 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 312 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…
-
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…
-
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 31 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…LOGAN-FELLOWES 31 views 9 comments 0 points Most recent by LOGAN-FELLOWES Reporting and Analytics for ERP