BI Publisher
Discussion List
-
Enabling Pay Group in Payment File - 23A FeatureSummary: Reviewing some earlier What's New Features - I came across this in 23A: VAT PAYMENT IN LOCAL CURRENCY FOR POLAND FOREIGN CURRENCY INVOICES As part of this - I n…AllenN 193 views 4 comments 0 points Most recent by Anjali Jain Payables, Payments & Cash Management -
SQL to retrieve Supplier, sites and Sites assignments BUSummary: Hi, Can any one share the script for retrieving list of active suppliers and their sites and site assignement BUs. Many thanks for your help Content (please ens…
-
Extend OTBI Agent Extract Maximum Rows for Excel FormatSummary Extend OTBI Agent Extract Maximum Rows for Excel FormatContent We recently implemented OTBI Agents that delivers extracts from an analysis that captures data wit…User_2025-02-07-20-17-33-726 270 views 10 comments 1 point Most recent by Max Prestes Reporting & Analytics for Sales -
Can you please investigate why we cannot use the permissions against folders in OTBI ?Summary Why we cannot use the permissions against folders in OTBI ? what happens now is: when we got enough access, we can set up a specific permission at a certain leve…Aarti Karale 2 views 0 comments 0 points Most recent by Aarti Karale Reporting and Analytics for ERP
-
UK BACS Format payment file output querySummary: Our requirement is to get the payment file (UK BACS) from OTBI report through MuleSoft invoking functionality. Content (please ensure you mask any confidential …Birley Varghese 41 views 0 comments 0 points Most recent by Birley Varghese Payables, Payments & Cash Management
-
How to add the Requestor Name in the Seeded Report (DisbursementPaymentProcessRequestStatusReport)Summary: Requirement: - To modify “Payment Process Request Report” columns. To Replace Column Sequence Name with Requestor Name. Content (please ensure you mask any conf…Bhatt Deepak 3 views 0 comments 0 points Most recent by Bhatt Deepak Payables, Payments & Cash Management -
What Oracle IP address(es) should be provided to recipients of reports via SFTP delivery option?Summary: We need to provide IP addresses to an external third party so that they can whitelist them in order to successfully receive BI Publisher reports directly from O… -
cancelled invoice appearing in supplier balanceHi Team, We are facing issue with the Supplier Balance Aging Report. Customer created two payable invoices (INVOICE_1 and INVOICE_2) in August 2025, both were cancelled …Vishnu Kommineni-Oracle 21 views 4 comments 0 points Most recent by Karun Jain-Oracle Payables, Payments & Cash Management
-
Where can we get the History of the Position for a report.Summary: I am trying to do a report for Position Details and trying to find the 'History' changes which can be found in the Position "Details" page just below the "Grade…
-
Is there any table that stores the IDR invoice scan details in Oracle Fusion ?Summary: I am looking for a query/table name to get the IDR invoice scan details. There is a table AP_IDR_INVOICE_TRACE_DYD but scan details doesn't get persisted for lo…Dipak Das 122 views 3 comments 0 points Most recent by Dipak Das Payables, Payments & Cash Management
-
Formatting BI Publisher chart axis labels to display integers onlySummary: I am working on a complex report in BI Publisher that is based on uploading an RTF file, and in this chart I need to display only integer numbers on the X-axis.…
-
Chetana Pawar 151 views 5 comments 0 points Most recent by Tracy Garrow Reporting and Analytics for HCM
-
How to develop a BIP / OTBI report to fetch details from VBCS pageSummary: Hi Team, We have a customized VBCS page for Inventory transactions. Our requirement is to develop a BIP / OTBI report to fetch details from the VBCS page. Is it…Dhilip Kumar P. 78 views 6 comments 0 points Most recent by Abdullah Samy-Oracle Reporting and Analytics for SCM
-
SQL query to Backend table for Filtered List under Learning ManagementSummary: Hi Team, We need a back-end table or SQL query to get Filtered Lists in Learning Management module. Navigation: My Client Groups → Show More → click Filtered Li…
-
Workflow Transactions Detail BI ReportContent Hi All, We have a requirement to create a report to fetch all the details of all workflow transactions going through approval. Is there a way to create a single …User_Z7BKU 289 views 6 comments 0 points Most recent by Lucas B Maciel Reporting and Analytics for HCM
-
Example Feedback Report query for BI Publisher based on Feedback requests and Questionnaire tablesSummary: Our requirement is to generate a report based on feedback requests and questionnaire (eg. Annual Performance Feedback) tables. Manager will submit Feedback Requ…MadhuLekkala 129 views 3 comments 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM
-
Unable to pull E-Signature details from RequisitionSummary: I am looking to extract E-signature information, specifically the flow name, signature date and time, and the signer’s identity. My current approach joins IRC_A…Sandeep Aravindakshan 14 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
How to burst and deliver a single CSV file to SFTP when no column has a common value for all recordsHi team, I am working on an Oracle HCM Cloud BI Publisher report where the requirement is to: Generate one CSV file Containing all records Deliver the file to SFTP locat…Sammeta Srividya 36 views 5 comments 0 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP
-
Empty per_person_secured_list_v and per_assignment_secured_list_vSummary: I have admin profile but secured views are empty. Content (please ensure you mask any confidential information): I have admin profile but the following queries …Stefano_Mazzocca 511 views 7 comments 0 points Most recent by mgoswami Reporting and Analytics for HCM -
SQL query for View Item Landed Cost pageHi Team, How does View Item Landed Cost Page work? We want to create a BI report for all GRNs and view item landed cost. We have written a custom logic but this query is…Hariom_Rathore 201 views 2 comments 0 points Most recent by Dineshkumar.A-Oracle Reporting and Analytics for SCM
-
Connection Timeout (Error 404/504) when connecting BI Publisher to OIC File Server via Port 10134.Summary: Connection Timeout (Error 404/504) when connecting BI Publisher to OIC File Server via Port 10134. Content (please ensure you mask any confidential information)…Edward Villanueva 61 views 1 comment 0 points Most recent by Shradhanjali_Oracle-Oracle Reporting and Analytics for ERP
-
Is it possible to save my preferred filter within the dashboard?Users cannot save or retain their own personal filters in the reports or dashboards. I understand that we can only configure default report filters/parameters - this fea… -
How to increase the specific BIP report's runtime or timeout limit?The Query Time Out that has been configured within the Data Model>Properties was set to 36000. However, during running the report, I'm still getting this kind of error: …Welsey 5.4K views 6 comments 1 point Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Is there a way to fetch journal lines details which were updated while running the import correctionSummary: We have a requirement to create the BIP Report and show only journal lines which were updated while running the import correction process. Kindly let me know th…Basavaraj Navalagi 1 view 1 comment 0 points Most recent by Ganesh G R General Ledger & Intercompany -
Send Separate Remittance AdviceSummary Send Separate Remittance Advice process completes successfully but mail notification not receivedContent Hi All, We have Setup the Separate Remittance Advice and…Surya Muralidharan-185000 156 views 14 comments 1 point Most recent by User_H3XVX Payables, Payments & Cash Management
-
Query to fetch departments with cost centre and cost centre managersSummary: Hi, i need a query with departments assigned to cost centre and cost centre managers. Please help Content (please ensure you mask any confidential information):…
-
Custom lovSummary: How to incorporate custom lov Content (please ensure you mask any confidential information): I have an existing audit report which has two prompts. 1. Employee …
-
Getting Job offer details in HCM ExtractsHello, I am trying to bring Job offer letter comments in an HCM extract as an attribute, but job offer comments does not appear anywhere in the core. Can anyone please s…
-
Table per_national_identifiers is blank however there are data in the screenSummary per_national_identifiers table no dataContent Hi, I have a problem with person national identifier table is shown no data but the application screen shows data c…User_IYN7Q 991 views 7 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM