To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
BI Publisher Learning Center
Discussion List
-
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 … -
Connect to PaaS db from BIP to create report from custom tables created in PaaSSummary: Connect to PaaS db from BIP JDBC / JNDI connection to create report from custom tables created in PaaS Content (please ensure you mask any confidential informat… -
I have requirement on HCM where i need sql for employer rejection reasonHCM Report: I want to extract query for WithdrawalReason and EmployerRejectionReason
-
Would it possible to extend the sql quey time limit.Hi Team, There is an BIP report scheduled and it was taking more than 1800 secs to run. While it was crossing 1800secs the report is failing. Is there any way we can ext…
-
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…
-
How to review scheduled BIP jobs not yet running?I'm submitting several jobs to run at different hours and I would like to review the schedule before report are running. How can I do this? Thanks -
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… -
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…
-
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…
-
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.
-
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?
-
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 …
-
Multiple Delivery By options in Oracle BI ReportSummary: Hi All, I have developed Oracle BI report in fusion, facing an below issue - I have 4 data sets A,B,C,D and joined A-B and A-C-D, included KEY in all the datase…
-
Report required to generate the privileges or roles assigned to seeded reports in Oracle fusionWe are looking for a report or any work around to find what roles or privileges assigned to oracle fusion seeded reports (BIP & OTBI)
-
The 'Custom' folder under the BI reporting is deleted, not able to recoverThe 'Custom' folder under the BI reporting is deleted, not able to recover how can we recover the Custom folder /backup as that folder is deleted.
-
Changing the POV of migrated Financial Report to Reports (Insert Formatted) reportWhen I edit the POV of a report downloaded using Insert Formatted Report, it appears to open a new Excel sheet rather than simply refreshing the values within the existi…
-
Is there a way to create a JDBC Connection to Oracle ERP Fusion Database from External IDE?We are looking to connect to the BIP tables as if from the BIP Data Model creation → SQL Query. There is a possible connectivity using an outside software called CloudMi…
-
BIP report output is not delivered to email id'sHi Team, BIP report output is not delivered to the internal DNS email ids (for both individual's and DL's). Is there any such restriction in Oracle ? However the report …
-
Transmissions Configuration - Bank not accepting old key pairs from OracleSummary: Our Bank is using new key pairs for transmission. Oracle uses and outdated configuration for these transactions. We are finding that the new key pairs provided … -
Oracle BI report for account hierarchyI am trying to create a oracle BI report for account hierarchy, but I'm a bit stuck. I used the code below but get a message of missing right parentheses. SELECT LEVEL A…
-
where to find the database connection manager in FRS workspaceHi, I am trying to get the database connection definition and details for FRS report, however i can't find the database connection manager in 23D. I do see the Essbase a…
-
Image reflecting differently in RTF Template and BI Report OutputIn RTF Template I have made the background transparent But in the BI Report Output it is coming as
-
Logged in User display on OTBI reportHi Team, Both below do not generate the logged-on user at filter condition on OTBI once moved into 24A even if a person's security profile is active on view employee's o…
-
How to add new columns in a Pivot table developed using BI Publisher extension.The requirement is to add calculation columns like Average and Variance in a BIP RTF template which has a pivot table. The calculation columns need to added after the pi…
-
BI Publisher - Obtain YTD / accumulated payroll 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…
-
get user environment languageThere is one requirement to get user environment language. I logged into the cloud application with German language to get the expected output. However, when I run the f…