Customizing Reports
Discussion List
-
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. -
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 12 views 1 comment 0 points Most recent by Swapnil Kashid BI Publisher Learning Center -
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…Omran Zeaiter 282 views 8 comments 1 point Most recent by GauravSethiya 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…
-
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…
-
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 12 views 2 comments 0 points Most recent by Prasanna Villari BI Publisher Learning Center
-
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 13 views 0 comments 0 points Started by Nalsoft Pvt Ltd BI Publisher Learning Center
-
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 -
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…
-
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 3 views 0 comments 0 points Started by Manu Krishna T M BI Publisher Learning Center
-
Sending new hires notifications to managers before the actual hire dateHi All, Is there a way that we can create a BI report and using bursting we can send new hires notifications to managers before the actual hire date. Notification email …
-
How to call fast formula using procedure call sql typeHow to call fast formula using procedure call sql type such that i can use for the remaining calculation to build BI report.
-
Dynamic BIP Query executionWe have a requirement to execute dynamic query using BIP in oracle ERP Saas and was going through this (Doc ID 2636492.1) which says passing dynamic query as parameter d… -
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 22 views 0 comments 0 points Started by Harikumar S - NetApp BI Publisher Learning Center
-
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 13 views 0 comments 0 points Started by Lucky.Rana-Oracle BI Publisher Learning Center
-
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?
-
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 …
-
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 2 views 0 comments 0 points Started by Aditi Agrawal2650 BI Publisher Learning Center
-
How to print label on zebra printerHi Team, We have requirement to print labels zebra printer using BI report. Can you please guide if anyone already implemented.vikram khengare 14 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle BI Publisher Learning Center
-
Unable to retrieve Reviewer's data for an employee in Talent review meeting using TablesWe are unable to make an BI Report on Reviewer's data using oracle tables. We got the list of participants for an particular review meeting but unable to fetch the Name …
-
Sql query or table joining link between Project and expense reportHi Team, Can anyone please let us know the table or SQL queries for getting Project number along witht Expense report number ?. Need to connect table PJF_PROJECTS_ALL_B …
-
Documents Of Record BIP ReportHi, Is there any way to see person related information in a report. while submitting a Documents of Record . I know we have view document option . But the out put is com…
-
What values should be provided to lexical parameters for seeded BIP data model?I am working on the SQL query for Oracle Seeded Data Model - Transactions Print Data Model for Invoice Print Template report, where it shows some lexical parameters and …Kratika Sharma 207 views 4 comments 0 points Most recent by Dhinakaran G BI Publisher Learning Center
-
How to call a service logistics PVO from an SQL query from BI Publisher and BI AdministrationHow to call a service logistics PVO from an SQL query from BI Publisher . We are trying to use the PVO- oracle.apps.scm.serviceLogistics.billing.publicView.DebriefLinesP…P.S.Nikhitha Muduliar 24 views 1 comment 0 points Most recent by Shrikant Nene-Oracle BI Publisher Learning Center
-
Seeded Function PER_AVAILABILITY_DETAILS.GET_AVAILABILITY_DETAILS takes longer to run in BI ReportThe function takes longer time to run in BI report and gives time out errors out when run in Adhoc. Since we are placing this report in dashboard as a link to BI, the re…
-
Why does the query in the dataset take an extended time to process?I have a query that typically takes around 2 minutes to process and returns the expected output. However, after adding a small condition to exclude a specific value, the…
-
Which column from REVISIONS table needs to be mapped to Document ID of Content server dataset?My goal is to read contents of file in UCM and append it to PO PDF. Currently, I am using DID column from REVISIONS table and mapping it to Document ID of Content server…
-
Pivot balance rolling basis calculated using rtf template in BI reportHi, I hope this email finds you well. I facing some issue from balance logics in rtf layout, Also, balance is equal to (On-hand + current commit – demand qty) on a rolli…