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
-
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…
-
How to pass Request Payload for POST Method in BIP DataModelI am currently working on a project where I need to invoke a REST API from a BIP DataModel/Report. However, I'm facing an issue with configuring the request payload for …
-
sent automated email when records are more than 50I have a report which lists failed records for ar invoice. I need to send a email with list of records, when there are more than 50 records failed. Can this be achieved …
-
Hi Team, In BIP report I'm calling a rtf sub template. Report error out.Hi Team, In BIP report I'm calling a rtf sub template. Report error out for reason "Template invoked but not defined.". Can you advise what could be the issue I used the…
-
From which table can I obtain the name of the owner of a Succession Plan?Starting from this query, i try to obtain the name of the owner plan but without results. Can you help me with one suggestion, please? SELECT HP.PLAN_NAME, HP.PLAN_TYPE,…
-
How to update a DFF field from a BI publisher report?We need to modify Generate Extensible Work Order Traveler Report and accommodate a print counter, last print date, last printed by at the top of the report. The purpose … -
How can i integrate the p_start_date and p_end _date parameters into this query in BI Publisher?Summary: I need to integrate the p_start_date and p_end _date parameters into this query in BI Publisher Content (please ensure you mask any confidential information): V…
-
BIP reports usageSummary: Is that possible to run a BIP report that show all BIP reports that have been running in our POD? We know we can see the scheduled reports in ESS table but we a… -
Displaying Data from Multiple Datasets in BI Publisher RTF Template with Hyperlink SupportWe have a business requirement to include hyperlinks in the output of an Oracle Fusion BI Publisher report, enabling users to directly navigate to specific application p…
-
Dynamic Picture watermark based on the conditionThe requirement is to get Picture Watermark only for a specific sponsor of the employee. If the employee has a different sponsor, we should not get any watermark. How ca…
-
How to Configure Request Payload for POST Method in BIP DataModelHello Oracle Community, I am currently working on a project where I need to invoke a REST API from a BIP DataModel/Report. However, I'm facing an issue with configuring …
-
IF condition issue in docx templateUsing the .docx template to generate reports in oracle APEX In this template, we are unable To include if condition To hide/show a table row based on if condition We hav…
-
I need to call external rest api to using custom ESS JobHi, I need to call External rest api using Custom ESS Job based on Datamodel (BI report). if you have any method available. please share me.
-
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…
-
What values should be provided to lexical parameters for seeded data model for Asset Register ReportWhat values should be provided to lexical parameters for seeded BIP data model for Asset Register Report - *&L_INVOICES *&L_SOB_INV *&d_category_segs *&d_asset_key_segs … -
Custom UCM datasource To Retrieve The Text Attachments for PDFHi. I used this document: How to create Custom UCM datasource To Retrieve The Text Attachments for PDF ? ( Doc ID 2643214.1 ). I was able to follow all of the steps and …