Customizing Reports
Discussion List
-
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… -
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 Mandeep Gupta 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!
-
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 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 …
-
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 …JBabbit121 81 views 5 comments 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center
-
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 51 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 K. 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 Cowell 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 12 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 191 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 52 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 12 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 12 views 2 comments 0 points Most recent by Gaurav Bharadwaj-Oracle 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…Ashu Raj-Oracle 22 views 1 comment 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…nedicken-Oracle 555 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 Started by Renuka Soneja-154959 BI Publisher Learning Center -
How to Draw vertical lines in BIP ReportSummary of Request How to Draw vertical lines in BIP ReportContent HI All, I want to draw vertical lines in my BIP report. When I am adding those as a object, it's start…Ashutosh jain 39 views 3 comments 0 points Most recent by Kristine Kukich-Oracle University-Oracle BI Publisher Learning Center
-
BIP Extensibility Training - How to Create a New ReportSummary This short tutorial details how to create a new report:Content This short tutorial details how to create a new report: You will learn how to: * Create the data m…nedicken-Oracle 428 views 2 comments 12 points Most recent by Farooq Syed, CPA, PMP, CISA BI Publisher Learning Center
-
BIP Extensibility Training - More on Customizing RTF Report LayoutsSummary 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…nedicken-Oracle 231 views 1 comment 15 points Most recent by ROHIT.R-Support-Oracle BI Publisher Learning Center