Category 67
Discussion List
-
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… -
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 42 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?
-
Is there any table which stores Subledger balances for sources like Payables and specific accounts?I need an information about the tables through which Subledger level balances for specific sources like Payables, Receivables and Fixed Assets and specific accounts (GL_…
-
How to display date in the format (like April 1st 2025) using RTF tags.The requirement is to display the date like April 1st, 2025 in the RTF Template using RTF Tags.Nalsoft Pvt Ltd 23 views 3 comments 0 points Most recent by Hari Haran Reporting & Analytics for Fusion Service
-
how BIP job that retrieves data from an Oracle Database table containing a BLOB columnWe have a BIP job that retrieves data from an Oracle Database table containing a BLOB column (e.g., storing PDF or image files). For downstream processing and integratio…
-
Hi everyone, could you share an SQL to fetch the latest HCM Group of an employee?Hi everyone, could you share an SQL to fetch the latest HCM Group of an employee?
-
How to burst the BIP report output to AWS S3 bucket?We have created a BIP report with FTP delivery bursting, and now the report output is being uploaded to an SFTP location. I would like to store the same file in an AWS S…User_K040A 17 views 2 comments 0 points Most recent by Ashwin GSC-Oracle BI Publisher Learning Center
-
EBS sftp connection does not establish BI Admin (FTP), what need to be donehi, I am developing cloud BI report with bursting mode FTP delivery mode, file transfer scp cloud to EBS. Creating FTP connection (BI admin) based on EBS FTP details. it…
-
Custom Fonts Not Reflected in PDF Output – BI Publisher RTF Template (OLC Certification)Hi All, In the OLC module, our client provides certifications with text styled in custom fonts. I have uploaded an RTF template in BI Publisher and exported it to PDF fo…
-
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…Logan B. 303 views 2 comments 0 points Most recent by Prashant Prabhakar Fusion BI Publisher Learning Center
-
How to pass multiple values for a parameter in BIP report URLWe are trying to access a BIP report via URL. It is working fine when single values are selected. However when multiple values need to be passed for a parameter in URL, …
-
How to send report output files over email or as a link based on file sizeWe have a custom BI report. The report generates excel output and the file size can be of 100 MB or more. We have a requirement that if the file size is less than 10 MB … -
OTM BI Publisher - barcode fontHi, We are modifying a report in Oracle Analytics using LibreBarcode39Extended-Regular.ttf font but when making any changes to the existing report the barcode is not dis…Carolina Alves Silva 16 views 0 comments 0 points Started by Carolina Alves Silva BI Publisher Learning Center
-
How lexical parameters are replaced in fusion BI reportHow is lexical parameter like &LP_FA_DEPRN_DETAIL getting replaced in Form 4562 - Depreciation and Amortization Report.
-
How lexical parameters are replaced in fusion BI reportHow is lexical parameter like &LP_FA_DEPRN_DETAIL getting replaced in Form 4562 - Depreciation and Amortization Report.
-
What Value should be provided to Lexical parameter for Seeded Report Data modelHi All, What value should be provided to below Lexical parameter for Seeded Report Data model of Uninvoiced Receipts Accrual Report ? &ACCRUAL_ACCOUNT &CHARGE_ACCOUNT Th…
-
How do I adjust time zone ins rtf date fieldI'm configuring a RTF template to a term document, but here's my problem, in that document it must contain the from date of a compensation plan, but when I put the field…Lucas Gaspechach 4 views 0 comments 0 points Started by Lucas Gaspechach BI Publisher Learning Center -
Need the last modification date of 'Generate Audit Report'Hi Cloud Community, Currently, we don't have access to data model/report for the seeded report 'Generate Audit Report' in Oracle Cloud Fusion. Business user has a requir…Tushar_Singhania 4 views 2 comments 0 points Most recent by Tushar_Singhania BI Publisher Learning Center
-
How to add Images from URL dynamically based on PO in RTF template as PDF output.?I am seeking guidance on a requirement to dynamically render images from URLs onto an RTF template for PDF output. I have attempted the following methods: URL Tagging: I…Sai Teja Madishetty 36 views 1 comment 0 points Most recent by Sharon Harper BI Publisher Learning Center
-
SQL Query to get Change Order TasksHi. I am looking for Query to get Change Order Tasks from SCM Oracle fusion tables. Attaching Screenshot -
The steps to configure attachments on Movement RequestWe have a requirement to incorporate an attachment feature into the user interface for creating movement requests. Kindly advise on how we can fulfill this requirement.Anil Appanaboyina-Oracle 4 views 2 comments 0 points Most recent by Ravi06-Oracle BI Publisher Learning Center
-
What is the support version of Excel in Oracle Fusion BI Report?Is it only support Excel 97-2003? Does it support .xlsx format, please?Venus Yim 12 views 1 comment 0 points Most recent by kanchana venkatasubramanian BI Publisher Learning Center
-
Need A COBRA Qualifying Life events - Sample ExtractLooking for sample COBRA qualifying life events extract & SAMPLE - Dependent Hi All Anyone has the extract for benefits Strategies for COBRA Qualifying event. a sample e…
-
CTE does not work for all casesI’ve received a request to create a BI Publisher report that meets the following business requirement: Given a date parameter (e.g., 31/12/2024), the report must return …