BI Publisher
Discussion List
-
Customizing data model in BI Publisher (Cost Detail Data Model)Summary: I would like to add some fields to the data model "Cost Detail Data Model" in Assets Balances. Content (required): I have copied the file to the custom folder, …Anders W. Langholm 126 views 3 comments 0 points Most recent by Akshay Acharya-Oracle Reporting and Analytics for ERP -
Is there a function to get the display name from the username?Summary: Content (required): I'm looking for a function where you can pass the username and get the display name returned? I know I can do a query to the per_users table… -
Bank Return Records BIP queryHi All, I m new to fusion finance module, we have a requirement to fetch all the bank return records through BIP query, Can anyone help us with SQL query or the table na…Yuvraj S-Oracle 31 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Tracking bounced back emails Print Receivables TransactionsAR invoices need to be delivered through email to customer email ID. Is there any tracking mechanism to monitor the bounce back? So that, a valid email address can be ob…Dhruvjoshi23 42 views 3 comments 2 points Most recent by Lukas Oleksiak Reporting and Analytics for ERP -
Is there any way to add Item number in seeded account analysis report?Summary: Customer is interested to see Item number in Account analysis report so that he/she can perform GRNI reconciliation Content (required): Version (include the ver…Naga Hari Krishna P-Oracle 44 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
Two basic BI Report QuestionsSummary: Hi - I am using a custom data model which contains a mandatory parameter. I have defined the report output to default to Excel. I have 2 questions - please see …
-
SUM each Payment row Running Total (YTD) by Vendor ID/Name?Summary: My code succeeds when my query for one Vendor, but needs to be reset for the whole report (muliple Vendors) A running total ( YTD Amount) for each group of Vend… -
Need to perform YTD calculation over ap_checks_all for reportSummary: Hi Forum: my customer would like to insert a YTD column right after Payment_Amount (SQL is over ap_checks_all) but there is no seeded YTD in ap_checks_all table…
-
In Cloud Data Model, is combining multiple Select using "With" Statement with trailing joins allowedSummary: Hi R&A forum: In a Data Model for Cloud ERP or Cloud HCM, is SQL beginning "WITH ( as " allowed ? See Code snippet. Thank you, Content (required): In a Data Mod…
-
ESS job for IICS web serviceSummary: IICS related ESS job in Oracle fusion Content (required): I have a requirement where I created an ESS with Webservice DM and created an ESS job. When submitted,…
-
Can you please help me to join AOR to ORC tables.Summary: Can you please help me to join AOR to ORC tables. Actually we are fetching HRBP and HR Administrator names based Legal employer, Country, Location and Organizat…User_2025-03-07-21-19-21-057 23 views 0 comments 0 points Started by User_2025-03-07-21-19-21-057 Reporting and Analytics for ERP
-
Delete BI Folder with permission set to OpenSummary: Delete option Enabled even when permission is set to Open Content (required): With admin user we created the following folder structure Shared Folders>Custom>Cu…Sahil Makhiza 62 views 5 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP
-
Location of Tax Recovery Rate used for requisition or Purchase Orders in data tablesSummary: I'm trying to find where in the data tables the Tax Recovery Rate used on a requisition or a Purchase Order is stored. Content (required): This is the Tax Rate …
-
Send Report to Employee That Have a Certain RoleSummary: Our finance team is interested in scheduling a report to be sent to any employee who has a particular role. The report should have parameters set to filter for …David Rabalais 88 views 5 comments 0 points Most recent by David Rabalais Reporting and Analytics for ERP -
Is it possible to create a tile which will open a BI report?Summary: Is it possible to create a tile which will open a BI report? Content (required): Hello We would like to add a tile to the Procurement tab, that when you open th…Helen Thomas 268 views 3 comments 0 points Most recent by Helen Thomas Reporting and Analytics for ERP
-
How to encrypt the bip report response with SOAP web serviceSummary: Hi Experts Currently the response from the SOAP web service returns the BIP report data in base64 encoded format but I want to encrypt the response in some othe…
-
How to send large attachments in BIP email deliverySummary: How to send large attachments in BIP email delivery Content (required): Email delivery failed in BIP for large report output. Below is the error, 'emailOutbox r…Ananya Sadhukhan 145 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
How do i make a report which i created via OTBI available to be submitted via Scheduled processesHow do i make a report which i created via OTBI available to be submitted via Scheduled processes ? Version (include the version you are using, if applicable): 22A (11.1…
-
How to add dynamic logo to a BI Report ?Summary BI Publisher : Dynamic LogoContent Good People, How to add dynamic image from an URL / website to RTF template ? Or we need to have it fixed always ? Thanks, Sou…Soumya Prakash Parhi 91 views 6 comments 2 points Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP -
Can we write PLSQL in BI Data Model ?Summary Is PLSQL supported in ERP Cloud ?Content Good people, Can we use PLSQL in BI Data Model ? If so is there any documentation on the same ? Thanks, SoumyaSoumya Prakash Parhi 108 views 4 comments 1 point Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP
-
Unable to view xml tags in RTF templateSummary: Content (required): Hello all, I'm facing difficulty in editing old custom reports and seeded reports since the XML tags are not visible as they should be. For …Sushan Peiris 262 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
How to run seeded PO Dashboard from the Procurement iconSummary: How to run seeded Dashboard from the Procurement springboard icon Content (required): Hello There is one PO Dashboard and the users wants to run from the Procur…Cesar Saveedra 61 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
Need recommendation for Printer Model for Label Printing for a Manufacturing ClientSummary: Hi Team, we are trying to find recommendation for Printer Model for Label Printing for a Manufacturing Client. Any help you can provide would be really helpful.…Abhilash K - Deloitte USI 12 views 0 comments 0 points Started by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Would anyone with experience with OTBI be willing to serve on a panel with OATUG ERP CLoud SIG?Summary: I am the VP of the OATUG ERP Cloud SIG who is hosting a panel in September called " ERP / HCM Cloud: OTBI, Third Party – lessons learned / improvement opportuni…Jeff Hare CPA CISA CIA 32 views 0 comments 0 points Started by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP -
BIP Data format on group-sumSummary: Content (required): I'm trying to create a report in BIP (in a RTF file). So I have used table wizard to create a for each on the values I need. In the actuals …Nicolas Vahman 42 views 4 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for ERP
-
Need the query to get the data on the Review Budgetary Control Balances UISummary: We need a query for a report, which happens to be the details of the Review Budgetary Control Balances UI. Please assist. Please assign this SR to the relevant …Sushan Peiris 292 views 3 comments 0 points Most recent by Catherine Myrand Reporting and Analytics for ERP
-
Is there an option to update Oracle or Vision logo once to reflect in all seeded reports?Summary: Client is asking for one single update of oracle or vision logo so the users doesnt see Oracle /vision logo in out of the box report when run. Client requests t…Abhilash K - Deloitte USI 122 views 5 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
UCM Bursting not working for Fixed Assets Seeded ReportSummary: Issue in UCM Bursting for Seeded FA report Content (required): Hi, We are trying to create bursting for seeded FA What-If Depreciation Analysis Report to push o…
-
Are there a Financial statements reclassified according to the 4th CEE Directive available in ERP?Summary: Are there a Financial statements reclassified according to the 4th CEE Directive available in ERP? Content (required): Dear All, I would need to know if a Finan… -
Large number value pushing out as scientific E numberSummary: I have a rtf template that must show opening balance, total invoices, total credit memos, etc and a closing balance. My amount coluns are pushing out values lik…