Category 67
Discussion List
-
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 can we add a chart or graph in RTF template of a BIP reportWe need to build a report that shows a table with all the data and then a graph/chart for the same data. We have an RTF template built for the same. Please advise if its…Ashu Raj-Oracle 32 views 4 comments 1 point Most recent by ALOK SH-Oracle BI Publisher Learning Center -
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 84 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…
-
Conditionally send report to email ONLY if query returns data resultsIs it possible to setup a schedule in BI Publisher to run every day that will only output a report to EMAIL if the query fetches at least one row of data? In other words…
-
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 118 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center -
Security in Oracle Business Intelligence - BI Consumer Role securing by content area?Hello, Is it possible to secure data for users with the role BI Consumer by subject area for example limiting to just GL or just Accounts Payable or Order Management? Th…James O'Brien 51 views 2 comments 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center
-
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 52 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 52 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 -
Multiple null columnsHello, How can I display multiple empty columns, with empty column labels? The aim is to send a csv like field1,field2,field3,,,,,field4,field5 When I try NULL multiple …User_2025-07-18-02-04-51-132 41 views 8 comments 0 points Most recent by RichardChan BI Publisher Learning Center
-
How to insert a static hyperlink in an excel template of a BI Report?I am building a BI Report that has an excel layout attached. In the layout, I display employee missing timecards and would like to add a hyperlink to our Oracle system s…Elena Tudor 555 views 6 comments 0 points Most recent by Gaurav Bharadwaj-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… -
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 121 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… -
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 12 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 -
<?for-each:G_INV_INV?><?if xdofx:substr(FLEX_TYPE_INV,20,6)='101000'?> IF statement doing nothing.I have a column FLEX_TYPE_INV in my rtf template, there are many data Groups being used here. One of them is G_INV_INV which has the column FLEX_TYPE_INV. I only want a …
-
Help creating a table to use as BIP Bursting delivery data sourceI am seeking additional documentation or white papers describing how to create a table for use as a delivery Data source for bursting with more detail. I have read the O…
-
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…
-
Where to find Oracle documentation on ExternalReportWSSServiceHi, Do we have Oracle documentation for the below webservice : https:///xmlpserver/services/ExternalReportWSSService?wsdl Can any one please share the oracle doc link. T…Shashidhar Goud 138 views 8 comments 0 points Most recent by Gaurav Bharadwaj-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 597 views 3 comments 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center