Customizing Reports
Discussion List
-
Can we generate output from different layouts based on the conditions?We have created multiple layouts in the report, Can we get the output from different layout based on the conditions without changing the default layout in the report. -
How to use IF conditions in BI Publisher Excel TemplateFor Example, we have 2 columns A and B, Our requirement is to show 'Yes' in column B if column A value is not null, else if column A value is null then show 'No' in colu…
-
How to Create Custom PVO on Oracle Interface TablesWe have a Requirement where we want to use BICC Console to extract data for oracle Interface Error Table. Can anyone please help with Guided Steps.
-
BIP report scheduled with ET time zone and the report got triggered in UTC timescheduled the BIP report in ET time zone at 1:00 AM but the report got triggered at 9:00 AM ET. ca anyone help us to understand what causes this?Akhila.Allagadda 2 views 1 comment 0 points Most recent by Akhila.Allagadda BI Publisher Learning Center
-
BIP report scheduled with ET time zone and the report got triggered in UTC timescheduled the BIP report in ET time zone at 1:00 AM but the report got triggered at 9:00 AM ET. ca anyone help us to understand what causes this?Akhila.Allagadda 1 view 0 comments 0 points Started by Akhila.Allagadda BI Publisher Learning Center
-
How can we implement SQL-based data security in a BI Publisher Data Model to restrict PII columns?We have a custom BI report which contain 5 columns of data and out of these 3 columns are related to PII(Personal Identifiable Information). These 3 fields are secured o…
-
Schedule BI Publisher report to run every first Monday based on Fiscal Month EndWe need to schedule a BI Publisher report which should be ran on every first Monday when the Fiscal Month ends. For exm : January 2025 Fiscal year starts from 12/28/2024…Lakshmi Prasanna Bandaru 11 views 1 comment 0 points Most recent by Shankar-Oracle BI Publisher Learning Center
-
Number to name conversion of currency value in RTF templateI have currently developed a BIP report using RTF template for a receipt voucher. It contains values in both Arabic and English. I would like to know whether there is a …Manu Krishna T M 23 views 1 comment 0 points Most recent by Ravi Tilekar BI Publisher Learning Center
-
FA Asset Addition and FA Asset Register reports lexical parameter and Temporary tableHi , Both of these reports use lexical parameter &l_fa_whatif_rep_t. We want to understand how this parameter value is derived. We tried to use fa_whatif_rep_t table, to…
-
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…
-
Which SQL Table store the Activity Information of Time Entry in OTL.Which SQL Table store the Activity Information of Time Entry in OTL. Please share the inputs if you know -
BI Publisher not working in MS Word, and how can I fix it?I downloaded BI Publisher to work on an RTF template, but every time I try to open MS Word, it crashes and becomes unresponsive. The issue resolves only when I remove th…
-
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…
-
OAS Report to query completed UDFs that did not produce System Documents due to bug 30724880Looking for guidance on creating a report in OAS that could show candidates that have completed and signed a specific UDF, but did not produce a document under their Sys…
-
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 21 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. -
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…
-
SQL Query to get Change Order TasksHi. I am looking for Query to get Change Order Tasks from SCM Oracle fusion tables. Attaching Screenshot -
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 …
-
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.Nitesh Hiremath 32 views 1 comment 0 points Most recent by Swapnil Kashid BI Publisher Learning Center
-
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…nehayadav86 11 views 2 comments 0 points Most recent by Prasanna Villari BI Publisher Learning Center
-
How can be achieved a report in different tab by using guided journey pageSummary: Added Report path link through guided journey in position page , While clicking report the report it open in same I want that report should directly display in …
-
Pivot table is not working in OTBI report with 2 subject areas, columns are not working properlySummary: Pivot table is not working in OTBI report with 2 subject areas, columns are not working properly as per the pivot table layout. Created a report with subject ar… -
Hyperlink Requisition IdentifierSummary Want to create a dynamic hyperlink on the Requisition Identifier field to the job on the career sectionContent Hi, I have a analysis (report) in OBIEE which is s… -
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 …
-
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…Nalsoft Pvt Ltd 21 views 0 comments 0 points Started by Nalsoft Pvt Ltd BI Publisher Learning Center
-
Applicant and User Login MetricsHello, Is there somewhere or somehow I can pull metrics for number of applicant logins and number of smartorg user logins? I checked in the metrics portal but can only s…
-
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…