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 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… -
Getting the the error when executing the ess job ?####[2023-10-26T09:15:36.294+00:00] [INFO] dummy file is deleted ================ BIPJobExecutable Execution Started ============ OutputFile : /u01/APPLTOP/instance/ess/…
-
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…
-
What is the support version of Excel in Oracle Fusion BI Report?Is it only support Excel 97-2003? Does it support .xlsx format, please?
-
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…
-
How to attach PDF of BIP report as document of records in oracle fusion hcmHi, This document details the steps to create document records for one or more workers using BIP Report. we have a business use case to add service credits for General P…
-
Sql query or table joining link between Project and expense reportHi Team, Can anyone please let us know the table or SQL queries for getting Project number along witht Expense report number ?. Need to connect table PJF_PROJECTS_ALL_B …
-
Documents Of Record BIP ReportHi, Is there any way to see person related information in a report. while submitting a Documents of Record . I know we have view document option . But the out put is com…
-
How can we send a file at UCM on "prc/supplier/export" folder location?Hi I want to send a supplier report at UCM on "prc/supplier/export" folder location using bursting, but I'm not able to find this location. There is only "prc/supplier/i…
-
What values should be provided to lexical parameters for seeded BIP data model?I am working on the SQL query for Oracle Seeded Data Model - Transactions Print Data Model for Invoice Print Template report, where it shows some lexical parameters and …
-
Global Level Function By Expression does not show anythingHello, I'm trying to use the below Global Level Function expression in a RTF but even though it shows in the XML outpout it doesn't in the Table view not RTF. Do you hav…
-
How to Schedule Load Interface File for Import Program in Oracle Cloud by Specific file name patternSummary: Hi Team, We want to schedule load to interface program in Oracle Cloud and program should pick the file from UCM with a specific file pattern, We couldn't find …
-
Custom SQL Returns Only One RecordI am working on a new report using the below SQL and I am only seeing one Record when running it. I have confirmed that there are many users with no additional assignmen…
-
Do we have backup table for ESS request historyThe ESS request history table has data of last 90 days. Would like to know if there is any backup table which stores the entire request history information.
-
How to call a service logistics PVO from an SQL query from BI Publisher and BI AdministrationHow to call a service logistics PVO from an SQL query from BI Publisher . We are trying to use the PVO- oracle.apps.scm.serviceLogistics.billing.publicView.DebriefLinesP…
-
What is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' table to extract data from BICC to oacsSummary: What is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' table to pull data from BICC to OACS Content (please ensure you mask any confidential information): Version (inclu…
-
Seeded Function PER_AVAILABILITY_DETAILS.GET_AVAILABILITY_DETAILS takes longer to run in BI ReportThe function takes longer time to run in BI report and gives time out errors out when run in Adhoc. Since we are placing this report in dashboard as a link to BI, the re…
-
Why does the query in the dataset take an extended time to process?I have a query that typically takes around 2 minutes to process and returns the expected output. However, after adding a small condition to exclude a specific value, the…
-
Restricting BI Developer Data Access to Specific Business Units in Oracle FusionSummary: We need to implement a restriction in Oracle Fusion where BI Developers can access and customize report/Data Models only for their assigned Business Unit, ensur…Mohamed Yousif Mohamed Gadalla 53 views 0 comments 0 points Started by Mohamed Yousif Mohamed Gadalla -
How to Pass extract date to PVO's in BICC using APISummary: We are not able to pass the different extract date in the SOAP API while calling the BICC job using webservice call or not able to reset to full extract for BIC…
-
want to report on specific components of learning initiativeswant to report on specific components of learning initiatives. I've attached a screenshot of the various ways you can select learners when building a learning initiative…