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
-
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… -
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… -
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…
-
Oracle BIP Access Denied, check SOAP privilegeI'm doing an automation for Oracle BIP when I got an Access Denied error but the credential I'm using is an Administrator account. I'm using the login method from the ht…
-
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…
-
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…
-
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 41 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…
-
BIPCatalogObject AuditTrail when report is migratedDo you know if the Audit report BIPCatalogObject is auditing reports migration from other instances. If it does, how can we identify it? Thanks.
-
Pivot balance rolling basis calculated using rtf template in BI reportHi, I hope this email finds you well. I facing some issue from balance logics in rtf layout, Also, balance is equal to (On-hand + current commit – demand qty) on a rolli…
-
disable custom BIP report parameter once it's been selectedSummary: Content (please ensure you mask any confidential information): I have a custom BIP report it has parameter (list of value), say Invoice Number from AP table the…
-
Is there a system variable to display running environment like DEV/UAT/PROD in BI report?Without customizing the data model is there a way to identify the running environment in the rtf template.
-
Will PAAS & SAAS instances time zones be always in Sync?Will PAAS & SAAS instances time zones be always in Sync as we are fetching SAAS data(BIP Reports) from PAAS based on date parameters passed from PAAS. We need to ensure …
-
Do all view tables hold data constantly or is there a process to get the information to showHello, I'm using the view FND_BPM_TASK_HISTORY_VL to see the history of tasks and approvals for transactions. This is to create a report to show the approval workflow fo…
-
Can I SFTP the documents stored in documents of record through BI Publisher BurstingSummary: Can I SFTP the documents stored in documents of record through BI Publisher Bursting FTP? This is PDF attachments. Kindly assist. Content (please ensure you mas…
-
Invalid session ID or session expired error on custom BIP reportwe have a custom report which runs in fusion. the report used to run for almost 2hrs in past. but with increase in data now, the report is running for close to 2hr 30min…
-
I have requirement on HCM where i need sql for employer rejection reasonHCM Report: I want to extract query for WithdrawalReason and EmployerRejectionReason
-
Translation of Performance Document Reports RTF Templates to other languagesHi Team, Kindly suggest a best approach or is it feasible on how we can translate an English language Performance Document Worker Ratings Report RTF template & Performan…
-
Functionality of 'Every' Value in Weekely Frequency Report BI Agent Scheduler ?In BI Agent Scheduler, we have Frequency = Weekely and 'Every' = … Weeks so here what is meaning/functionality of 'Every' value. So suppose if we put Weekely Frequency a…
-
Learning DashboardDoes anyone have a template for Learning Dashboards in OTBI? -
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…