BI Publisher
Discussion List
-
Exclude 0 amount tax boxes from tax box allocation (e.g. cancelled tax lines or invoices) and xml ouContent Hi everyone, I am finishing implementation of JPK (Polish SAFT file) in our instance. Allocations and rules work perfectly with one exception. We should not repo… -
Get the description of a value in a valueset using HCM ExtractSummary: Hi, I need to extract the field description from the value set for each value and I need to insert the description as an attribute in the HCM extract Content (p…
-
Need fusion table details for Tax Classification Code for supplier in Fusion.Summary: Need fusion table details for Tax Classification Code for supplier in Fusion. Content (please ensure you mask any confidential information): Version (include th…ManishaPatil 23 views 4 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Is Reginal information for Mexico field stored in GL_INTERFACE Table?Summary: We have a requirement to upload journal lines under Reginal information for Mexico with UUID but we are unable find the exact column from GL interface, Is there…Sreenivasulu Donka 81 views 3 comments 0 points Most recent by martingabriel Kinovisques General Ledger & Intercompany
-
User Prompt Results Causing ORA-01795 Error (IN statement 1000 expression max limit)Summary Need solution to get past ORA-01795 error caused by expressions returned from user prompts into an IN statement when selecting AllContent Hello, Appreciate any h…User_2025-12-05-01-24-53-219 17 views 3 comments 0 points Most recent by Vinith Kumar P V Reporting and Analytics for HCM
-
Hide Disable Actions Menu in BI Publisher Report or Hide Export and Schedule buttonSummary: I want to hide Action menu in BI Publisher Report or want to hide Export and Schedule button. Only need online view. Is there any way to do this ? Version (incl…
-
Download External certificateSummary: Dear Expert, Is there any way to download the non-catalog item certificate for a user via the BIP report? Content (please ensure you mask any confidential infor… -
How to enter a different date as the Value Date in Payment FileSummary: I have a requirement where I have to generate the payment in Oracle Fusion Payables AP on 2/15/2026 but I want to send the Value Date to the Bank as 2/17/2026. …Srinivasan1 2 views 0 comments 0 points Most recent by Srinivasan1 Payables, Payments & Cash Management
-
What are the limitations for BI Published reports?Summary: What are the limitations for BI Published reports? Content (please ensure you mask any confidential information): What is the maximum number of rows I can expor…Max Prestes 1 view 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
SQL query or Table for Double Opt In Management in Fusion ORCSummary: Hi, Which table is having the information of the task "Double Opt In Management" or please provide query Content (please ensure you mask any confidential inform…Opkey PA 11 views 1 comment 0 points Most recent by Kunwar Singh-Oracle Recruiting, Opportunity Marketplace
-
Custom template is not reflected in ap invoice approval notificationSummary: Custom template is not reflected in ap invoice approval notification Content (please ensure you mask any confidential information): We've customized the AP invo…VenkatesanR-Oracle 31 views 3 comments 0 points Most recent by VenkatesanR-Oracle Reporting and Analytics for ERP
-
For recording External Learning, we intend to create a BI Publisher (BIP) reportSummary: Hi Team, For recording External Learning, we intend to create a BI Publisher (BIP) report that displays employee details along with the approver information and…
-
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 191 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 244 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 11 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…BeachDreamer 531 views 6 comments 0 points Most recent by User_525NM Reporting and Analytics for HCM -
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 26 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 134 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. 51 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 277 views 6 comments 0 points Most recent by Lucas B Maciel Reporting and Analytics for HCM
-
Course/Offering Status Code Change Impacting BIP Report Output Across EnvironmentsSummary: We created a BIP report in DEV2 using the status codes ORA_COU_ACTIVE (Course Status) and ORA_CLS_ACTIVE (Offering Status). The report had been working correctl…
-
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 91 views 3 comments 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM