-
Not getting Bold font in PDF output while translating to Japanese for Print Receivables Transactions
When text headings are specified to be bold within an RTF template but still the bold font/text is not reflected for any Report Definition PDF Output using the template while we are trying to generated output in Japanese language using XLF file. In RTF template, text heading only uses Arial font with bold. Please suggest…
-
Audit tables for Project Tasks and Sub Tasks in Oracle fusion cloud and policies to enable
Hi, Are there any Audit tables for Project Tasks and Sub Tasks related in Oracle fusion cloud to create a BI publisher report? I was able to enable the audit policies for project foundation category, but these didn't included task and subtasks attributes. Also, i was only able to see two audit tables in projects…
-
How to Encode/Encrypt BLOB Column to Base64 Format for BIP Job
Product: Oracle BI Publisher / Oracle Database Description: We 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 integration, we need to encode (or encrypt, if possible) the BLOB data into Base64 format within the SQL…
-
What version of Java should you install so the BI Publisher Word add-in will work and page preview
We used to have JRE installed on our devices to enable the BI Publisher Word Add-in tool to work and to page preview templates. As JRE is no longer supported it was classed as a security concern and has recently been removed from our devices, I raised a call with MOS asking what version of Java we should and were it can be…
-
Need to query PVO data in BI Publisher Data Model
We need to query PVO data in BI Publisher Data Model, here's the PVO name: FscmTopModelAM.ScmExtractAM.ScmRcsBiccExtractAM.ItemUOMConversionPVO
-
first day of previous month and last day previous month Schedule Report Job in oracle fusion
I want to schedule a BI Report job - first day of previous month and last day previous month Schedule Report Job in oracle fusion using : {$FIRST_DAY_OF_MONTH()$} {$LAST_DAY_OF_MONTH()$} For example : i am scheduling on 1st AUG - need to schedule dynamically every month ( 1st day) From date : 01-JUL To Date : 31-JUL-25
-
How I access the oracle tables in Oracle BI EE Publisher
What are the recommended steps to access Oracle database tables directly within Oracle BI EE for reporting and analysis?
-
looking for REST API for Oracle analytics publisher
I am looking for REST API for Oracle analytics publisher , (Syntax )to Run a report using parameters. Kindly share me the details if anyone has available
-
How to manage empty last page when there is not enough space to print the footer
Hello guys Currently we are developing RTF templates to use with Oracle EBS R12 12.2 instance, to address a government requirement to show Arabic labels on all documents given out to customers (Sales Order invoices, delivery notes…) We've already achieved a major part of it, however having a minor issue when the current…
-
Request for Guidance – Embedding PDF Attachment in "Preview Invoice Report" Output
Hi Experts, Hope you're all doing well. We have a requirement customize the oracle seeded report "Preview Invoice Report"(Navigation: Shared Folder/Project/Project Billing/) where we need to display a PDF attachment (that currently available in the UI under Invoice Header> Attachments. Navigation: Contract…
-
custom repot output required in excel format. limited to 65000 lines only
custom developed report output to be in excel format. created a RTF rxcel format oracle only allowing 'xls' format. limiting the record line upto 65000 only
-
Issue creating RTF Template using Non-standard SQL Data Model
I have created a new Data Model in Fusion BI Publisher that uses Non-standard SQL and I have that functioning at intended. However when I try to create the report template layout I am having an issue. After saving the Data Model and also saving Sample Data, If I select "Generate RTF layout based on selected Data Model."…
-
Need table name storing reporting period and status after "Finalize Transactions for Tax".
We need to retrieve the final reporting status and reporting period in Oracle Fusion tables after running the "Finalize Transactions for Tax Reporting" ESS job. This ESS job finalizes the tax reporting period in Oracle Fusion. We are developing a custom report that will include the finalized reporting period and the…
-
Is there a REST or SOAP API to post receipts to the ledger in Oracle Cloud Financials?
Hello everyone, I'm currently working with Oracle Cloud Financials and looking to automate the process of posting cash receipts to the general ledger. In the user interface, this is done using the "Post to Ledger" button within the "Manage Receipts" screen. I would like to know if there is a documented way to perform this…
-
Cannot Display BIP Field Properties
Summary Cannot Display BIP Field Properties Content I am running BIP template builder v12.210 with MS Word 2013 (32 bit) and I cannot display the BIP properties dialog in some templates. I've tried double-clicking on the field as well as right-clicking and selecting 'BI Publisher -> Properties' from the menu. Oddly, the…
-
Bursting BI publisher report with Excel file or creating each record as one report from in excel dat
Summary Bursting BI publisher report with Excel file or creating each record as one report from in excel data file with PDF output format? Content Hi Gurus, i have created report by using excel file as data set and used rtf template for field mapping. But i have to burst the report. Is it possible? or is there any other…
-
Access to tables
I want to give access on table level to developers as want to restrict the sensitive or salary related data Also they should not be able to see the data in table even in Data model using select query Eg: select * from "Salary_tb"
-
how to Add Bursting logic based on a Employee's Legal entity and Business Unit for an existing one.?
we have a report which sends output with employees who are pending workers. And these emails go to the employee's(pending workers) Line_Managers. i.e., Slit by and Deliver by is Line_manager_email but Now user has come back with the new condition saying that when a Pending worker is added and if he belongs to a one…
-
Oracle Analytics Server Reports Run 1hour end process Failed
Product: Oracle Analytics Server 7.6 OS: Linux 7.9 After upgrading from Oracle Analytics Server 5.5 to 7.6, we started encountering a 'Socket read timed out' error for reports that consistently finish in exactly 1 hour. Interestingly, reports running for more than 1 hour do not face this issue. This problem did not exist…
-
How to get active bip session token from front end of standalone application?
Hi, How do we get the active bip session token from Fusion to the standalone application after logging in to Fusion like sso login? Thanks in advance Srimathi
-
How to pass ESS requestid to BIP report
Summary Is it possible to pass the ESS job id/process id/requestid as a parameter to BIP report Content In fusion application, an ESS Job is defined as BIPJobType which calls a BIP report. We want to populate a parameter in BIP Report with the ESS process id. Is there a way to achieve this?
-
BIP LOV not returning desired value
Hi, We have a requirement to add an employee parameter in the report where the format is "Full Name + (Person Number)" E.g. Smith, John (12345) The LOV that we created looks like this but some values are not displaying in the LOV of the report itself. SELECT (PPNFV.FULL_NAME || ' (' || PPSLV.PERSON_NUMBER || ')'),…
-
We have a requirement to automatically trigger BICC/BIP batch jobs after the Compensation Cal
We have a requirement to automatically trigger BICC/BIP batch jobs after the Compensation Calculations are completed in the FIC (Fusion Incentive Compensation) application. We have already set up an API integration to initiate the BICC/BIP batches. However, to invoke the OIC integration, we need a trigger from FIC once the…
-
Number fields losing format in BI Publisher
Hi, I have a BI Publisher report using an analysis as source in Data Model. However, when I run the analysis, the number fields have been shown with their correct formatting (Ex.: 999.999,99). However, when I open the BI Publisher report the format changes to 999,999.99 and I am unable to change the data format on Data…
-
is there any way to export deployed custom report list and report location from fusion cloud
is there any way to export deployed custom report list and report location from fusion cloud
-
BI Publisher Report Leaving out Duplicates
When I run my query I get the full report but when I created a BIP excel report, I find that rows with a duplicate person id are missing. This is a first time issue, is there a way around this? Thanks.
-
Any webservice available to unarchive catalog file in fusion?
-
Is there any rest api to run BIP report from fusion
-
Invoke fusion webservice as BI Publisher Web Service Source
Hi Team, can you confirm Invoke fusion webservice as BI Publisher Web Service data Source? We try to invoke esswebservice from BI Publisher Web Service Source it is not working. We added SSL Certificate also. Please help on this.
-
ESS Job Output Not Printing to Printer
Hi All, I’m submitting an ESS job using the advanced option to print the output to a specific printer. I’ve provided the printer name in the destination field. However, the BIP data model used in the report also includes a bursting query to FTP. When I submit the ESS job, it only triggers the bursting logic defined in the…
