Customizing Reports
Discussion List
-
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 259 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 22 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…
-
Translation of Performance Document Reports RTF Templates to other languagesHi Team, Kindly suggest a best approach or is it feasible on how we can translate an English language Performance Document Worker Ratings Report RTF template & Performan…
-
BIP Letter Templates and ImagesHi all, I've created a simple data model that allows an end user to run a self service report where they input the employee number and it generates a semi complete lette…
-
can we use the regexp_replace function in a xsl bi publisher template?I'm trying to use the regexp_replace function in my xsl template to replace special characters and I receive an error. Is the regexp_replace supported by the xsl templat…
-
How to remove decimal value in BAR CHART - RTF Template - BIP Report?Decimal value is displayed in the Bar chart of RTF Template - BI Report. How to remove decimal values in the chart?SARAVANA KUMAR T-Oracle 4 views 0 comments 0 points Started by SARAVANA KUMAR T-Oracle BI Publisher Learning Center
-
How to find redline change data in the OBI tablesHi Experts/Team, Is there any OBI table that stores if any attribute is redlined on a change order, redline information i'm looking for a specific attribute is redlined …
-
Issue with .xlsx formatWhen scheduling a report and then the report is sent to the manager, manager cannot receive it because report cannot be sent. Could it be that .xlsx option is not suppor… -
How to display a 2nd signature based on Check AmountHi, we have a requirement to print a second signature on a check when the check amount exceeds a threshold e.g., $25,000. We have created our RTF template with one stati…
-
List of Values SQL query with multiple columnsHello - I want to know if it is possible to use a List of Values object (with a Parameter) and select 2 columns in the LOV query, and then display one column for the End…
-
AR Aging Report Issues in BI PublisherHi everyone, I'm hoping to get some help with an AR Aging Report built in BI Publisher. I inherited this report from someone else, and I'm facing two issues: Missing Cus…
-
fr studio indentation issue after export to excelAfter Patch our Prod Fr studio indentation changed only when export to excel. Html indentation looks great. Other instance have no issues with the export indentation. *R…
-
combine or overlapping to different sub templates in a main templatehow can we achieve combine or overlapping to different sub templates in a main template of rtf and output to be in html -
Can we Use .XLS template with Excel Macro enabledHi Team, Is it possible to utilize a BIP .xls template that has a macro embedded into it? Our User requirement is to have a Macro in excel template a user can run on the…
-
Use .XLS template with Excel MacroIs it possible to utilize a BIP .xls template that has a macro embedded into it? If so, are there any examples that can be shared with me? I am not sure how to apply for…
-
How to find the sum total of an element for all the groups in rtf template?Hi, I am working on an RTF template for Oracle BI Publisher and I am trying to get the total sum of amount for all the groups in the template. The scenario is there are …Kratika Sharma 1.2K views 0 comments 0 points Started by Kratika Sharma BI Publisher Learning Center
-
How to group rows based on one column and then find the sum for each group?Hi, I am working on a rtf template where it is required to group the records based on the tax code value. Now I want to show the sum of amount for each tax code in diffe…
-
how to add prompt of Start Accounting date and end accounting date in FRS reportHi, I am looking out for ways to pass a period range Prompt in FRS report based on which my columns will dynamically be fetched. However i can't seem to find the ways to…
-
Current Date in OTBI for Enterprise Hire dateHi Need to know the exact query to add up in Enterprise hire date filter , date should be current date , we tried with the below options CURRENT DATE 'CURRENT DATE' CURR…abhilashblackbox 12 views 1 comment 0 points Most recent by Swapnil Kashid BI Publisher Learning Center
-
Need help with checkbox wingding.ttf font fileHi All, we have a requirement to insert check box in a report. based provided "DocID: How to Add a Checkbox in a BI Publisher Report ( Doc ID 2692589.1 )" For the checkb…
-
Email Bursting not workingI have the below Email bursting definition configured. The Schedule job completes successfully, however I never actually receive an email from it, even though there was …KDR 905 views 6 comments 0 points Most recent by Sreekanth Chennabathini BI Publisher Learning Center
-
How to solve java error in the excel template while working on BI reportHi, I am getting this error while trying to get the excel template for my BI report "javaw -Xmx256M -jar "C:\Program Files\Oracle\BI Publisher\BI Publisher Desktop\Templ…nehayadav86 113 views 5 comments 0 points Most recent by Swapnil Kashid BI Publisher Learning Center
-
Adding a parameter to custom data model of a seeded reportWe need to customize a seeded report and add a new parameter. But when we create a copy of seeded Data model and add a parameter in the custom data model, it gives an er… -
How to add column in a seeded BI report with existing package, ESS jobs, before/after event triggerHi, I am trying to add two columns in a "Payables Payment Register" seeded report but i am getting errors like and I would need to add column "PAYMENT_INSTRUCTION_ID"fro…
-
Is there any way to invoke a soap service from a BIP report passing parameters dynamically?Hi experts, The idea is to invoke a soap service let say pressing a button on the BIP report layout and pass report parameters as part of a payload. Is it possible someh…Volodymyr Faranosov 11 views 4 comments 1 point Most recent by MandeepGupta BI Publisher Learning Center -
Which table stores the flag "Use Withholding Tax" at supplier levelHi, Kindly asking for help in locating the table which stores the supplier flag "Use withholding tax". Many thanks for your kind replies!