Category 67
Discussion List
-
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 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… -
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 13 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 -
<?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 134 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 617 views 3 comments 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center
-
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 …AjayKumar Maddipati 21 views 6 comments 0 points Most recent by AjayKumar Maddipati BI Publisher Learning Center
-
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 -
Payroll Reports output is URL LinkHaving issues where Payroll Reports (ex: Payroll Balance Report) are producing url link for PDF output. I am submitting reports from Submit a Flow and when I do not sele…
-
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…AjayKumar Maddipati 11 views 4 comments 0 points Most recent by AjayKumar Maddipati BI Publisher Learning Center
-
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 helpShivaji Muttarapu 21 views 2 comments 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center
-
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…Elena Tudor 11 views 1 comment 0 points Most recent by Gaurav Bharadwaj-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
-
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…AjayKumar Maddipati 21 views 20 comments 0 points Most recent by MandeepGupta BI Publisher Learning Center
-
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…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by AjayKumar Maddipati 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
-
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
-
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 11 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 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…