Category 67
Discussion List
-
OTBI Prompt returning wrong DataWe are creating a report in OTBI using subject area "Maintenance Management-Work order performance Real Time". Select Work Order Priority in Data as well as Prompt. In D… -
Schedule BI Publisher report to run every first Monday based on Fiscal Month EndWe need to schedule a BI Publisher report which should be ran on every first Monday when the Fiscal Month ends. For exm : January 2025 Fiscal year starts from 12/28/2024…Lakshmi Prasanna Bandaru 4 views 1 comment 0 points Most recent by Shankar-Oracle BI Publisher Learning Center
-
BI Publisher - Obtain YTD / accumulated balances via SQLGreetings, We are trying to pull custom balance totals via a SQL query in BI publisher. So far, we have been able to obtain individual run results but cannot pull the to…
-
Number to name conversion of currency value in RTF templateI have currently developed a BIP report using RTF template for a receipt voucher. It contains values in both Arabic and English. I would like to know whether there is a …Manu Krishna T M 8 views 1 comment 0 points Most recent by Ravi Tilekar BI Publisher Learning Center
-
How can I build an ASL report in BI Publisher with supplier, item, and organization names?Hello, I am currently building a BI Publisher report based on the PO_APPROVED_SUPPLIER_LIST table. The report works fine when using this table alone, but I need to enric…
-
Inquiry Regarding Availability of "Go Noto" Font Installation Files in Cloud ERPMay I confirm that, as a Cloud ERP product, there is no available feature to download the installation files for the "Go Noto" font used in the PDF reports generated by …
-
FA Asset Addition and FA Asset Register reports lexical parameter and Temporary tableHi , Both of these reports use lexical parameter &l_fa_whatif_rep_t. We want to understand how this parameter value is derived. We tried to use fa_whatif_rep_t table, to…
-
Unable to find audit logs for archive or unarchive activity on BIP data model/report in ERP FusionOur client has a requirement to build a BIP report for audit purposes that can fetch information, such as when a user archives or unarchives the BIP data model or report…
-
HCM Tables which store BIP/OTBI Scheduled Report email recipientHi Team - We've requirement to list down all the BIP & OTBI reports which are scheduled along with their email recipient details. (some notification could be dynamic bas…
-
Is it possible to send email with multiple attachments in a single email with the bursting process ?Hi Team, We are currently working on bursting an invoice format using a BI Publisher data model and scheduling it to send invoices in PDF format via email. Currently the…Gavindu Saranga 18 views 0 comments 0 points Started by Gavindu Saranga BI Publisher Learning Center
-
Custom Recruiting Report Using Message TemplateGood Day Experts, Is it possible to create a custom recruiting report using OTBI or BI Publisher to extract 'Start Date Change Request' message template in Oracle fusion…
-
Reports to get Service Usage in fusion HCMWe need reports for below: 1) Anonymized Authorized User Names by Service Details 2) Authorized User Names by Service 3) Authorized User Privileges by Service 4) Authori…
-
Which SQL Table store the Activity Information of Time Entry in OTL.Which SQL Table store the Activity Information of Time Entry in OTL. Please share the inputs if you know -
How to Burst Email and FTP Output Delivery from the Same Schedule in BIP Report?I have a data model and a report in BIP, and there is a requirement to distribute the report output both by email to HR representatives and also to store the output on a…JayeshKori-Oracle 8 views 2 comments 2 points Most recent by Ketan Janva-Oracle BI Publisher Learning Center
-
How to Trigger 'Send to Fixed Email' for an Integrated Report in a Dashboard Using Action LinksHello, We are trying to automate a dashboard that contains a report (prompted by an OpportunityID) to be sent to our automation server, for example, via a button. Unfort…
-
Oracle Fusion Publisher - How to design a template with merged cells and recurring rowsHi Community, I am trying to develop a excel template report for my client with Oracle Fusion Publisher. This report composes of multiple tables with recurring rows at t…
-
Generate multiple Excel sheets based on parameter valueHi All, We are using Oracle Fusion Cloud Application 25C and Oracle BI Publisher Desktop for developing data template reports. Our requirement is to generate Excel outpu…Sonia Choudhary 12 views 0 comments 0 points Started by Sonia Choudhary BI Publisher Learning Center
-
セールスクラウドで、ロックされたユーザーのリストを毎日出力したいセールスクラウドのユーザーでロックされた人のリストを出力し、毎日特定のアドレスにメール送信したいです。 BIのエージェント機能を使って送信できたらと思うのですが、確認できる… -
BI report data limitationWhat is the BI report data limitation or ideal batch size when used by MuleSoft via API fetch records from FusionAnkit Aggarwal 1 view 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle BI Publisher Learning Center
-
Ability to view the output of BIP reports run by other users in Scheduled Processes.Hi Team, Is it possible to view the output of BIP reports run by other users from the Scheduled Processes tab without the BI Admin role? I assigned the necessary data se…
-
BI Publisher not working in MS Word, and how can I fix it?I downloaded BI Publisher to work on an RTF template, but every time I try to open MS Word, it crashes and becomes unresponsive. The issue resolves only when I remove th…
-
How can we apply conditional formatting in rtf templateNeed to put condition on rtf template , our requirement is to display the 'Accomplishment' section if there is data(count > 0) for accomplishment ,if there is no data ,e…Anjali_Kumari4121 1 view 0 comments 0 points Started by Anjali_Kumari4121 BI Publisher Learning Center
-
bi report and otbi svswe have svs but is possible to have bi report and otbi with svs apply? how can i do?
-
Authenticationadf.login=true issue when opening the hyperlink in excel outputHi Team , can anyone help me in resolving the issue Authenticationadf.login=true when trying to open the invoice pdf attachment available as hyperlink in excel output of…
-
requirement to automatically trigger BICC/BIP batch jobs after the ComCal are completed in the FIC.We have a requirement to automatically trigger BICC/BIP batch jobs after the Compensation Calculations are completed in the FIC (Fusion Incentive Compensation) applicati…Anita_ABR12 41 views 4 comments 0 points Most recent by Varun Malhotra-Support-Oracle BI Publisher Learning Center
-
Is there a way to increase the BI Publisher FTP connection timeout?We are currently utilizing a BIP report as part of an integration process with an external system, transmitted via FTP. While the process executes successfully on most d… -
How to create dashboard with all BIP reports and BI/OTBI analysis reports with action links?Hi All, We are planning to create a dashboard with all custom reports (including BIP report and OTBI Analysis reports) created in Oracle Fusion cloud. Our requirement is…
-
ESS Job Status Shows "Error" Despite Successful Report Output in Oracle FusionHi Team, We are facing an issue in Oracle Fusion Applications where a report or ESS job scheduled via "Schedule New Process" generates the expected output file, but the …
-
How to add response of questionnaire?Hi team, I want to add response of questionnaire for below query. Could anyone help me? SELECT distinct paam.person_id ,to_char(paam.person_id) PERSON_NUMBER ,PPNF.DISPL…
-
How to insert a new line in rtf templateHow to insert a line break dynamically inside RTF Template?