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
-
How to derive number of working/Businessdays in Fusion AP OTBI reportsSummary: How to derive number of working or Business days in Fusion AP OTBI reports while selecting data items via AP subject area -
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. Thanks -
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…
-
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 identifier
-
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? -
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… -
-
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…
-
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… -
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…
-
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… -
<?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…
-
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.
-
Hiding Output TAB in Schedule Page of ReportSummary: Hiding Output TAB in Schedule Page of Report Content (required): Can we hide via Personalization or Role Duties and Privileges restriction hide the Output TAB i… -
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…
-
Time Stamp Date and Time in BIP report NameHi, I am Scheduling BIP report for everyday. I wanted to Timestamp the Date and time in the output file name. For Example : The Schedule process is run on 15th June 2022… -
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… -
How to add two legal entity's for one countryHi Team, For coming one country we have only one legal entity so we gave as haou.name='x' but now we need give two legal entity's for one country that is x and y how to …
-
Need to know Table information for Proxies screenSummary: Need to know Table information for Proxies screen Content (required): I am looking for Table information to check Proxies screen details and prepare Adhoc BIP R…
-
Digital Signature in BI publisherI want to test Digital Signature in BI publisher but how to get a sample cer file for a digital signature? Can somebody help
-
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…
-
where we see all Scheduled jobsHi Team, where we find the all scheduled BI jobs In instance and previously I checked through Administration>Manage Jobs . But In 22A I unable to to find out that sectio…
-
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… -
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…
-
How can I display a date on BI report with PDF layout?Hi, I want to display two date fields on a BI report PDF output. The two fields are the report parameters and are of type DATE (not char. I cannot/don't want to change t… -
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…
-
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…
-
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…
-
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…