To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
BI Publisher Learning Center
Discussion List
-
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… -
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… -
Please assist on my code I'm unable to find where is wrong in join conditionsselect DISTINCT papf.Person_number, ppnf.Full_Name, pni.NATIONAL_IDENTIFIER_NUMBER, Pn.PASSPORT_NUMBER, pp.attribute3 as "Business Card Title", to_char(ppos.ORIGINAL_DAT…
-
How can I use a certain layout of a BI report?I have a BI report with 3 layouts (one default, of course). I need to access it in the application, but just for one of the three layouts (the others should not be visib… -
How to build a rule that is Malaysia pull the National Identifiers no, Non Malaysia pull passport noWe Need to build a rule that is Malaysia pull the National Identifiers Field, Non Malaysia pull the Passport number may i know how to write logic. and which field we nee…
-
Table details not found for the element configuration detailsHi Team I am developing a BI report to extract the element configuration details. Purpose is to verify the element details after creation in system. I have found all the…
-
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 …
-
Getting Log of ESS JobsHi Experts, We have a requirement to get the log of ESS job from fusion. Any pointer will be helpful like table name to get document Id or REST API to get this detail?
-
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…
-
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… -
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 … -
Filtering turned on for excel templateIs there a way to create an excel template so that filtering is automatically turned on when the excel report is generated? (I know you can set the 'freeze' view...so ma…
-
OAC Published Reporting - Audit and Monitoring AKA Usage TrackingDoes anyone know if it is possible to enable Audit and Monitoring AKA Usage Tracking for Published Reporting in Oracle Analytics Cloud. In OBIEE you needed to run RCU fo… -
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… -
How to fix width in excel output with rtf model on bi publisherSummary: We've made a template RTF using Oracle BI Publisher, when we print it in pdf it is good, but if we export in excel mode the cells are far too large, Content (re… -
Is it possible to create drilldown in BI publisher report?I have worked with drill down options in OTBI & OAC. Want to check if this option is available in BIP. Can you please advise?
-
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…
-
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… -
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…
-
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…
-
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…
-
BIP Extensibility Training - How to Delete a Report LayoutSummary This short tutorial details how to delete a report layoutContent Learn how to delete a report layout in this short tutorial. Runtime: 00:01:18 View the tutorial.
-
BIP Extensibility Training - How to Create a Report LayoutSummary This short tutorial details how to create a new RTF layout for your reportContent This short tutorial details how to create a new RTF layout for your report: You…
-
BIP Extensibility Training - BIP Customize FeatureSummary This short tutorial details how to customize an Oracle-supplied BI Publisher report using the BIP Customize Feature.Content This short tutorial details how to cu…
-
BIP Extensibility Training - Creating a Report Layout Using the Online Layout EditorSummary This short tutorial details how to create a report layout using the online layout editorContent This short tutorial details how to create a report layout using t…
-
BIP Extensibility Training - Enabling Additional Output Formats for Reports LayoutsSummary This short tutorial details how to enable CSV and Excel output formats for report layouts using the BIP Customize FeatureContent This short tutorial details how …
-
Error Displaying RTF TemplateSummary of Request ErrorContent Good afternoon, At the time of creating the template by the bipublisher extension of WORD and save it in RTF format and upload it to the …