Customizing Reports
Discussion List
-
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… -
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 11 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 597 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…
-
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 12 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!
-
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 …
-
BIP Report Alignment IssueIn the BIP report the alignment is coming up differently in different mail applications i.e. table alignment looks fine in Thunderbird but the same is misaligned in MS O…SaurabhJaiswal-Oracle 93 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center -
I can't view a job option in more menu for default report ?I can't view a job option in the more menu and the scheduled job doesn't appear on the Manage Report Jobs page for default reports. but it works well and shows scheduled…New 41 views 3 comments 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center
-
Can we suppress a hyperlink in BI Publisher Report PDF Output?We are building a BI Publisher Report in which one of the field has email ids. We are using an RTF template to generate the report output. When we view the output in PDF…Pinky Mukherjee 51 views 2 comments 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center -
Create BIP Report to Fetch the ESS Job Name, ID, And the SubmitterHi, We would like to create a report to fetch the ESS job name, id, and the submitter. ThanksAhmed Maher Kadeh 51 views 5 comments 0 points Most recent by Abhijit Sahu-Oracle BI Publisher Learning Center -
Custom privilege associated to my BI Publisher query does not work from custom job.We created a BI Publisher query to pull time and labor information into a report. We then created a custom privilege associated to an ESS process so the user can run thi… -
How to recover overwritten BIP templatesSome of our seeded BIP templates have been overwritten and I am looking for a way to restore the original template. Specifically the Performance Document Worker and Mana…Karlie Backman 11 views 5 comments 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center -
When we run the below query only few country's results working remaining are timed out error comingHi Team, When we run the below query with help of parameter of date and country only few country's working and remaining are not coming AND error is time out coming. ERR…AjayKumar Maddipati 11 views 9 comments 0 points Most recent by Raghavan p-Oracle BI Publisher Learning Center -
How to connect BI publisher to microsoft Sharepoint?Hi Experts, We have a requirement to transfer file from Oracle fusion BI to Sharepoint without using any middleware tool. Any lead will be appreciated.Rajeev Nayan 463 views 3 comments 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center
-
Hiding list of values in parameters of bip report according to user data access role.Can we hide the list of values in parameter scetion of a bip report for users according to the roles and priviledges they have. For eg we have ledger names coming from l…User_M14OP 71 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle BI Publisher Learning Center
-
Covid _19 report on Category code Not reflected it takes old oneHi Team, when we create the covid-19 report Now we changed document type is 'COVID-19 Vaccination Details' to 'COVID_19 Vaccination Details' show its come but issue with…AjayKumar Maddipati 11 views 0 comments 0 points Started by AjayKumar Maddipati BI Publisher Learning Center
-
Reports and Analytics- Folder Security changes after 22a?We are noticing changes in security access to BI Publisher reports in our Custom Reports and Analytics Folders and Sub Folders. Example 1: Employees with only the Employ… -
How to access Custom BIP reportsHi, We have some custom BIP reports developed. Want to know what are the options that are available for users to access these other than through Reports and Analytics-Br…NMM 21 views 3 comments 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center
-
IN below query working in production but not in testingHi Team, when i do query in testing suite national id number is coming with data but in testing suite having data and coming production working find could please assist …AjayKumar Maddipati 11 views 5 comments 0 points Most recent by AjayKumar Maddipati BI Publisher Learning Center
-
How to restrict the employee through working daysHi Team, we have one BIP certificate so we need to restrict the downloading of certificate for only who have complete greeter than 6 months in organization then only dow…AjayKumar Maddipati 11 views 0 comments 0 points Started by AjayKumar Maddipati BI Publisher Learning Center
-
BI Publisher Report producing values for next row when values cannot be foundHi all, Hoping you can assist me with some off behaviour that I am experiencing when producing a report in BI publisher. We have written a data model that when run appea…Luke.Findex 11 views 2 comments 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center -
BI Publisher Desktop for BIP 11.1.1.9.0 not working with MS Office-365 & WIN-10Hello Experts, Can you please guide me if you have faced the similar issue while installing BI Publisher Desktop for BIP 11.1.1.9.0 which not working with MS Office-365 … -
full outer join in BIP fusionHi, I have two queries and I want to use full outer join in BIP but it does not work. I am using select * from t1 full outer join select * from t2 on t1.A = t2.A but giv…Morad Alshammari 31 views 10 comments 0 points Most recent by Morad Alshammari BI Publisher Learning Center -
CLOB Column generate multiple sheets/columnsHi Experts, Upon converting HTML Tags into actual formtting of a CLOB field the output in XLSX format automatically generate multiple sheets and that CLOB column appears…
-
BIP Extensibility Training - How to Customize an RFT Report LayoutSummary This short tutorial details how to customize an RTF report layoutContent This short tutorial details how to customize an RTF report layout. You will learn how to…Neil Dickens-Oracle 566 views 8 comments 23 points Most recent by Tamer El-Tonsy - Tatonsy BI Publisher Learning Center
-
Please share tutorials on how to make SQL Queries for BIP ReportsSummary of Request Please share tutorials on how to make SQL Queries for BIP ReportsContent Hi, I am interested in learning SQL query building for BIP Reports. Please sh…Renuka Soneja-154959 56 views 0 comments 1 point Most recent by Renuka Soneja-154959 BI Publisher Learning Center