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
-
Issue with .xlsx formatWhen scheduling a report and then the report is sent to the manager, manager cannot receive it because report cannot be sent. Could it be that .xlsx option is not suppor… -
Insufficient BIP privileges to run queries that fetch logs for an issue in Fusion Recruiting CloudWhen the queries that fetch Recruitment Content Library Notification Details and Email Message Content and Delivery Status details are run on BIP in order to collect log… -
How to pivot to display questions horizontally as the heading using answers instead of measureI wish to create a table of questions as the horizontal headings (dynamic from data) and the users as the vertical with the answers in the data section. Pivoting appears… -
How to display a 2nd signature based on Check AmountHi, we have a requirement to print a second signature on a check when the check amount exceeds a threshold e.g., $25,000. We have created our RTF template with one stati…
-
install BIPublisherDesktop64i installed BIPublisherDesktop64 , but still not appear in Microsoft world ... Please need to install it and appear in the World
-
Can we get Label Printer Model suggestions that can print Label in PDF format?We have made a custom report fetches the data of the Purchase Order (PO) and Return Merchandise Authorization (RMA) which are meant to be received in client’s sub-invent…
-
Can we extract the milisecond from sysdate in ETEXT TemplateSummary: Hi All I have a requirement to extract the milisecond value from sysdate in ETEXT Template Content (please ensure you mask any confidential information): Versio…
-
List of Values SQL query with multiple columnsHello - I want to know if it is possible to use a List of Values object (with a Parameter) and select 2 columns in the LOV query, and then display one column for the End…
-
AR Aging Report Issues in BI PublisherHi everyone, I'm hoping to get some help with an AR Aging Report built in BI Publisher. I inherited this report from someone else, and I'm facing two issues: Missing Cus…
-
query to get the due date in payment under invoices to payHi, Could you please advise in which SQL table can I find the Due Date in Payables → Payments → Create Payment under Invoices to Pay. Thank you.
-
how to Retrieve the GUID of a row (global unique identifier ) using SQL ,not RESTsome apis require the GUID to update a record , not the id or rowid We can retrieve that value using REST api (/fscmRestApi/resources/11.13.18.05/invoices/1/child/invoic…
-
Initial cap/upper case in BIP report RTFSeeded report column value is like 'ANNUAL' .I want to display the value as 'Annual' which is in Init cap format without having to modify the seeded XML. How to do that …
-
fr studio indentation issue after export to excelAfter Patch our Prod Fr studio indentation changed only when export to excel. Html indentation looks great. Other instance have no issues with the export indentation. *R…
-
Is there any report or SQL which says that a report was accessed by user in HCMIs there any report or SQL which says that a BI or OTBI report was accessed by user in HCM
-
How do I keep a table with repeating elements from breaking across multiple pages?Summary: I am trying to develop a PO rtf template to upload in BI Publisher. When the file runs if the PO is too long, part of the items table that has a repeating eleme…
-
Query to get the tax name and rate from a draft invoice under contractI need to retrieve the tax name and tax rate applied on the draft invoice (without calculating it manually) under contract management. In the tables pjb_inv_line_dists a…
-
BICC Union all - documentationSummary: Does someone have any experience or documentation on implementing using UNION all in BICC on incremental extracts? Content (please ensure you mask any confident…
-
-
Unable to preview attachment without download the attachment in ReportHi All, Unable to preview the attachment without download the attachment Below steps are we following:- step1:- we have made one custom report step2:- we have added the …
-
Need to control the access for users from copying/moving BI folders.Summary: Users with BI Author role are able to Move (Drag and drop) the BI folders to a different location. This is causing issues since the report/folder is not found i…
-
How to populate Period dynamically as 'Feb-2024' from sysdate while scheduling BIP reportSummary: How to populate Period dynamically as 'Feb-2024' from sysdate while scheduling BIP report Content (please ensure you mask any confidential information): Version…
-
Is there any Alternate option for Encryption Type or SSL is the only option in BI Publisher ?Summary: The Villages IT team has plans to disable SSL on servers in the coming months as it is deemed a deprecated protocol. Basic authentication using SSL is our only …
-
Audit Report BI Publisher does not show folder informationHello! I would need some help with Audit Report from BI Publisher. It is assumed that it is not showing the information of all the operations performed at the folder lev…
-
Client requesting data to be not split into multiple sheets in excel or rtf templateSummary: Our client is requesting that the output does not be split into different sheets if the count of records are more than 65K in Excel and 1M in RTF while generati… -
Is there an excel template based report delivered by Oracle in FusionHas Oracle created any report with excel template inside Fusion Applications?
-
combine or overlapping to different sub templates in a main templatehow can we achieve combine or overlapping to different sub templates in a main template of rtf and output to be in html -
How to retrieve asset category base rate for previous month & current month using sqlRetrieve asset category base rate for previous month & current month using sql
-
BI Publisher Report- Learning Initiatives including Course number and Title-LearningHello All, I have the SQL code that fetches the learning initiative number, name, Course Number, and Title, but I have found duplicate rows because the Course titles do … -
Oracle Fusion Application MT Timezone is not reflecting sometimes in OTBI ReportsHi Everyone, I have set the timezone in oracle fusion application as UTC-07:00 Denver - Mountain Time (MT) and now when I am creating an OTBI analysis and using Now() fu…
-
Bi Reporting Error #221When attempting to open our organisation structure report we are being hit with an error as shown in the screenshot attached. This error is occurring when initially tryi…