Category 67
Discussion List
-
What does the asterisks in table comments mean?Hi all When reading the table definitions, for example here: https://docs.oracle.com/en/cloud/saas/project-management/25a/oedpp/pjcexpitemsall-24862.html#Details there i…Anders W. Langholm 1 view 0 comments 0 points Started by Anders W. Langholm BI Publisher Learning Center
-
How to call a web service in BIP SQL queryI have implemented a web service call in Oracle Fusion. Is there any way we can invoke the web service within an SQL data model in BIPHarikumar S - NetApp 17 views 0 comments 0 points Started by Harikumar S - NetApp BI Publisher Learning Center
-
schedule or live execution discriminatingHi I want to ask you if there's a way in BI to discriminate if the execution of the report is live or scheduled? i would like to variate the template layout based on the…
-
how to disable value details from bar Graphs and Pie chart in BI Publisher Layout(xpt template)Hi All, We have created a report which shows output as Pie chart and Bar graph. when report runs in Interactive mode, and when placing the cursor over pie chart or Bar g…
-
How to send data from one dataset to another dataset?Hello guys, I have created one data model in which two datasets are there. is there any way to get data from one dataset to another dataset in bi publisher? for eg. I ha…Parthiv_Patel 17 views 3 comments 0 points Most recent by Swapnil Kashid BI Publisher Learning Center
-
SFTP private key using SSH-KEYGEN command and import the same to SaaSHi, We are trying to set up SSH key authentication when we connect to the SFTP folder to transfer files from Oracle Saas through BI publisher. We followed this documenta…
-
How can we find out if there has been a recent change to Oracle ISP geolocation reporting?Summary: We're having new difficulties since about 1/25/2025 with the reported geolocation of an Oracle IP address used to deliver reports. Can we find out if there has …
-
How to make US1099 report to be emailed to Vendor?Is there a way to email US 1099 to the email addresses on file? User has run this in excel and .pdf - just need to know how to distribute by email to the vendor to the a…
-
How to implement a link in BIP report to dynamically download logged in user's detailsWe have added a download link in BIP report and inserted following URL: https://"Environment link"/filepath".xdo?param1=@{PERSON_ID}&_xpt=1&_xf=pdf But the downloaded re…Lucky.Rana-Oracle 15 views 0 comments 0 points Started by Lucky.Rana-Oracle BI Publisher Learning Center
-
BI Publisher - Interactive PDF report output with Checkboxes, drop downs and text boxHi, I am working on a BI Publisher report where the report output should be in PDF format. After the report is downloaded, the user should be able to select check boxes,…
-
Need to schedule BICC jobs every 5-10 minsWe need to schedule BICC jobs to run every 5-10 minutes. Is it feasible to schedule these jobs through a web service or user interface?
-
Time Stamp Date and Time in BIP report NameHi, I am Scheduling BIP report for everyday. I wanted to Timestamp the Date and time in the output file name. For Example : The Schedule process is run on 15th June 2022…Shashank Verma-Oracle 1.4K views 7 comments 0 points Most recent by Ken Padgett BI Publisher Learning Center
-
Table that stores the file contents of an attachmentHello, We need a table that stores the base64 format of the attachment uploaded in a work order or if there is any table that stores the binary format of the file conten…
-
Need to know which bi reports are being run by a user in a monthly basis and how oftenWe need to know which bi reports are being ran by a user in a monthly basis. Here the challenging thing is report ran might be scheduled or adhoc (ran directly) , we nee…
-
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…
-
Oracle BIP Access Denied, check SOAP privilegeI'm doing an automation for Oracle BIP when I got an Access Denied error but the credential I'm using is an Administrator account. I'm using the login method from the ht…Carlito Conrado 52 views 1 comment 0 points Most recent by Pankaj Pandey BI Publisher Learning Center
-
How to remove new Line from a clob column?Hello experts, I am trying to write a report which includes a CLOB column. But in the table there's blank line in every row, and getting an issue in excel output where t…
-
BI report scheduled jobs are skipping though the trigger is returning recordsBI report scheduled jobs are skipping though the trigger is returning records.Swapna Rachamalla 3 views 0 comments 0 points Started by Swapna Rachamalla BI Publisher Learning Center
-
How do you write a query for standard working hours in BIP?I need to get the standard working hours for employees into my query. I can see the standard working hours work is worked out in the following order : 'Standard Working …
-
Sql query to get payroll process name Under a batch Name /Instance nameHi , I am looking for SQL table to get payroll process name currently i can get batchname/Instance name via below query : SELECT pfi.instance_name FROM pay_flows pf,pay_…Surbhigupta_88-Oracle 173 views 3 comments 0 points Most recent by User_ADBMS BI Publisher Learning Center
-
Link between the gl/xla tables and tax tablesHello, I need to display the tax information (tax code, tax rate) for Journals having source 'Tax' (Note that these are journals created using the 'Create Taxable Transa…Varun Dhondea 37 views 2 comments 0 points Most recent by Varun Dhondea BI Publisher Learning Center
-
Missing/incomplete Data produced in the Oracle fusion BI publisher reports XML FormatWe have developed a custom BI Publisher report in the Oracle Fusion Cloud instance. The report is expected in the xml format. We have an issue here. i.e., the report com…
-
BI multivalue filter with bad performanceHello, We are tuning a query and see that the performance issue was in the multivalue filters. We are filtering invoices with the Code combinations table and filtering d…
-
RTFtemplate sorting data is there any limitWe want to sort the data in alphabetical order for “Payment Process request status report”. This is the seeded report provided by oracle when PPR is ran. Seeded report i…SivaRamaKrishna-Oracle 12 views 1 comment 1 point Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
New RTF Layout Not Reflecting in BIP ReportHi Everyone, We're encountering an issue in the lower instance of our BIP Report where we upload new layout of a seeded report in the Custom folder. Last week, it was wo…Sofia Danielle Sarmiento 28 views 1 comment 0 points Most recent by Daniel Sobotka BI Publisher Learning Center
-
can we add columns with name spaces while creating an eText format of the BI publisher report?We have requirements to create and extract CSV files for another system as integration. The requirement was to have column names with space (e.g. First Name). We have do…
-
Bursting Email not getting sentHI While I am using Parameter3 of query as my company's domain mail. It is not getting sent . Please suggest client does not want email sender to be shown as Oracle. How…Aditi Agrawal2650 11 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle BI Publisher Learning Center
-
How to send bursting email using personal email address?How to send bursting email using personal email address?Do we need to configure something or mail address can be used directly in bursting query?Aditi Agrawal2650 3 views 0 comments 0 points Started by Aditi Agrawal2650 BI Publisher Learning Center
-
What is the difference between Uploading a BIP report to xmlpserver vs. Catalog option?There is an option to Download/Upload BIP objects from xmlpserver. There is also an option to archive/unarchive from the Catalog folders. What is the difference between …
-
EDI Transactions Each Day, Total for AP Checks and Total Funding Required for Paymode ReportTrying to Create a Report Current Reporting Tools: They currently don’t pull reports from the HOST system but use IBM Document Direct linked to HOST activities. Identify…