Reports
Discussion List
-
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… -
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…
-
How to read AUDIT_CHANGE_BIT_MAP_Hello Guys I am in need to read data from tabel: FND_VS_VALUES_B_ Because i need to understand which field has been changed in the Value set I've activated the audit and… -
BI Publisher Word Plug-In ErrorI have the Word Plug-in that has previously worked without issue, however it is now kicking back an error when I attempt to preview my data. Steps taken: Opened rtf temp…
-
Remove Banner from BIP Report templateIs there a setting to remove the below banner from BIP templates (.rtf) that output in Excel format, either globally or at the report level? This banner is not in the ac…KDR 81 views 14 comments 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center
-
Job code with Null profilesSummary: Hi Everyone! I am trying to create a report which should fetch the job codes with No profiles in Manage job page. I hard coded one job code which is having no p…
-
BIP Samples?Is there another place to see samples of reports? the links from this page are brokenWayne Van Sluys 21 views 3 comments 1 point Most recent by Bhaskar Konar BI Publisher Learning Center -
Maximum Number Of Columns Created In Excel RTF TemplateHi All, What is the maximum number of columns supported by Oracle Fusion BIP report having Excel Template. Regards VijaiVijai Bhatia 51 views 4 comments 0 points Most recent by Raghavan p-Oracle BI Publisher Learning Center
-
Does oracle has any table that give us Users Signin and signout details for the past few weeksFor auditing purpose we want a report to extract the users who login and logout in the past 7 days login datetime logout datetime if any table or pre-build tables please…Chandra Thangavelu 71 views 5 comments 0 points Most recent by Chandra Thangavelu BI Publisher Learning Center
-
Would like to report on HR Help Desk Audit History table in BI PublisherHello, We would like to report on HR Help Desk audit history in a BI Publisher report. Has anyone done this and might be willing to provide instruction? Thank you, Natal…Natalie Andrek 51 views 1 comment 0 points Most recent by Raghavan p-Oracle BI Publisher Learning Center -
Narayanan Subramaniam-Oracle 61 views 2 comments 1 point Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center
-
Is there a way to organize the Shared Reports and Analytics in PD?Currently we have a list of shared reports under the Shared Reports and Analytics task drawer drop down in Product Development. Is there a way to setup folders for bette…Candice Chacon - Dexcom 1 view 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center
-
Report Missing NotificationsHi All, We have loads of notifications we have from Oracle and few we develop custom. We have them scheduled and some are BI Bursting notifications. Due to multiple reas…Vibha Pandey - Oracle 41 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 -
Aggregation function like stringagg() is supported in oracle BI queriesselect string_agg(goal_name,',') from (select distinct goal_name from HRG_GOALS) t Received ORA-00904: "STRING_AGG". invalid identifierChandra Thangavelu 122 views 1 comment 0 points Most recent by MandeepGupta BI Publisher Learning Center
-
BIP Jobs list detailsIs there a way to get the list of jobs scheduled in BIP (And the job run history details) exported into a document?Jahnavi-Oracle 21 views 2 comments 0 points Most recent by Jahnavi-Oracle BI Publisher Learning Center -
Bursting by quantity of results? And "pull" delivery???I need to export a couple million rows of data from Financials as CSV files or similar. Even when I limit the output by fiscal year, some years produce well over a milli… -
BI Publisher Report Timeout error on accessing it from Oracle Integration CloudOracle Integration Cloud process invoking (https://XXXX.xx.xx.oraclecloud.com/xmlpserver/services/ExternalReportWSSService?WSDL) a BI Publisher report error out with the…
-
Combine BIP report with dashboard promptI've heard from a different post that it is possible to use filtering on a report through a dashboard prompt. However I haven't been able to find out how exactly to conn…Annie Cho 11 views 2 comments 0 points Most recent by Rajasekhar Bandaru-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_2025-02-12-15-34-52-841 102 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle 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 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…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by AjayKumar Maddipati BI Publisher Learning Center -
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?Rajeev Nayan 11 views 1 comment 0 points Most recent by Raghavan p-Oracle 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 … -
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…
-
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 -
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?