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
-
Limited Oracle Allow List IP's For Outbound Connectivity For Fusion ApplicationsSummary: Limiting Oracle BI reports direct transfer IPs Safe list Content (please ensure you mask any confidential information): Base on this doc "Oracle Allow List IP's… -
Table that stores the file contents of an attachmentHello, We need a table that stores the base64 format of the attachment uploaded in a work order or if there is any table that stores the binary format of the file conten…
-
Need to know which bi reports are being run by a user in a monthly basis and how oftenWe need to know which bi reports are being ran by a user in a monthly basis. Here the challenging thing is report ran might be scheduled or adhoc (ran directly) , we nee…
-
BI report scheduled jobs are skipping though the trigger is returning recordsBI report scheduled jobs are skipping though the trigger is returning records. -
How do you write a query for standard working hours in BIP?I need to get the standard working hours for employees into my query. I can see the standard working hours work is worked out in the following order : 'Standard Working …
-
Page break in BIP E-Signature RTF OutputWe've created a task which captures employee's digital signature which is being referenced to a BIP RTF template. The file has been made in reference to all the availabl… -
Sql query to get payroll process name Under a batch Name /Instance nameHi , I am looking for SQL table to get payroll process name currently i can get batchname/Instance name via below query : SELECT pfi.instance_name FROM pay_flows pf,pay_… -
Link between the gl/xla tables and tax tablesHello, I need to display the tax information (tax code, tax rate) for Journals having source 'Tax' (Note that these are journals created using the 'Create Taxable Transa… -
Table for Bursting Output ResultsWe have a required to update SO EFF based on bursting output results. However when few of the bursting fails, Job is completing in error and Logs are not providing any i…
-
Missing/incomplete Data produced in the Oracle fusion BI publisher reports XML FormatWe have developed a custom BI Publisher report in the Oracle Fusion Cloud instance. The report is expected in the xml format. We have an issue here. i.e., the report com… -
BI multivalue filter with bad performanceHello, We are tuning a query and see that the performance issue was in the multivalue filters. We are filtering invoices with the Code combinations table and filtering d…
-
New RTF Layout Not Reflecting in BIP ReportHi Everyone, We're encountering an issue in the lower instance of our BIP Report where we upload new layout of a seeded report in the Custom folder. Last week, it was wo…
-
can we add columns with name spaces while creating an eText format of the BI publisher report?We have requirements to create and extract CSV files for another system as integration. The requirement was to have column names with space (e.g. First Name). We have do… -
Bursting Email not getting sentHI While I am using Parameter3 of query as my company's domain mail. It is not getting sent . Please suggest client does not want email sender to be shown as Oracle. How…
-
How to send bursting email using personal email address?How to send bursting email using personal email address?Do we need to configure something or mail address can be used directly in bursting query?
-
What is the difference between Uploading a BIP report to xmlpserver vs. Catalog option?There is an option to Download/Upload BIP objects from xmlpserver. There is also an option to archive/unarchive from the Catalog folders. What is the difference between …
-
EDI Transactions Each Day, Total for AP Checks and Total Funding Required for Paymode ReportTrying to Create a Report Current Reporting Tools: They currently don’t pull reports from the HOST system but use IBM Document Direct linked to HOST activities. Identify…
-
rtf template payment "due date"Hi, I want to modify an XML template (rtf format) to payment batches formatting. I get now the invoice due date SUBSTR(to_char(to_date(to_date(PaymentDueDate,'YYYYY-MM-D…
-
How to print label on zebra printerHi Team, We have requirement to print labels zebra printer using BI report. Can you please guide if anyone already implemented.
-
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… -
How to remove img tag in BI Publisher Bursting Email Body ?We are trying to retrieve the message content uploaded on the Help Desk Service Request The following code has been used to remove html tag which were being triggered: S…
-
HCM Tables which store BIP/OTBI Scheduled Report email recipientHi Team - We've requirement to list down all the BIP & OTBI reports which are scheduled along with their email recipient details. (some notification could be dynamic bas…
-
Calling OIC Integrations from Oracle SaaS BIP is Deprecated or not?Currently we have reports Calling OIC Integrations from Oracle SaaS BIP but as per oracle documentation, this service is deprecated. Calling an ICS/OIC service from BI P…
-
Does OpenJDK certified to use it instead of Oracle JDK to see the preview in RTF TemplateWe are not able to see preview in RTF template (MS Word)
-
Ability to view the output of BIP reports run by other users in Scheduled Processes.Hi Team, Is it possible to view the output of BIP reports run by other users from the Scheduled Processes tab without the BI Admin role? I assigned the necessary data se…
-
Unable to retrieve Reviewer's data for an employee in Talent review meeting using TablesWe are unable to make an BI Report on Reviewer's data using oracle tables. We got the list of participants for an particular review meeting but unable to fetch the Name …
-
How ESS Job Parameters are mapped to BIP Data ModelI would like to know how ESS Job Parameters are mapped to the BIP Data Model? I have a BIP Data Model with some mandatory and optional parameters. I would like to use a …
-
How can I give managers easy access to BI and OTBI reports that are already written?We have a number of BI reports and OTBI analyses already created that would be useful to our managers. However, it is a daunting task for managers to navigate into the r… -
which tables stores interview evaluation feedbackHi Team, May I know which tables stores interview evaluation feedback ? If possible can I get a snippet of SQL code ? Regards, Harish
-
Uploading xdmz file via xmlpserver is failingSummary: Uploading xdmz file via xmlpserver is failing Content (required): I have downloaded ****.xdmz via xmlpserver. I then used winrar to unzip the file so that I cou…