BI Publisher
Discussion List
-
How GL Trial Balance Report is designed to sort account codes?Summary: Hello community members, I am wondering if anyone know how GL Trial Balance Report is designed to sort account codes? It looks like the report is designed to so…T. Kosami-Oracle 11 views 3 comments 0 points Most recent by Venkatesh Padamwar General Ledger & Intercompany -
Excel output from RTF template is having one blank line in the topContent Hi All, I am using the RTF template to get the output in Excel format. I have used the page break to get the output in different sheets in excel. When the output… -
Delivery Filename in BIP Bursting definitionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
My rtf template has "È" but report shows "Č" insteadSummary: Encoding issue Content (please ensure you mask any confidential information): Rtf template is: Final result is: Why? Version (include the version you are using,…Stefano_Mazzocca 11 views 4 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
Need Assistance on How to Filter Data by Creator in the Invoice DashboardSummary: Hi All, I would like to ask if it is possible to filter data by creator in the Invoices Dashboard, specifically for Holds, Approval, and Prepaid data? Because w…Ucup Maulana 21 views 5 comments 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management
-
How to give access to Learning reports onlyHello, Do you know if there are any privileges/ duties for Learning reports? We have couple of users (HRBPs) who need to see how many employees completed a specific cour…
-
Will Oracle Fusion Cloud BIP report Bursting supports Dot Matrix PrinterSummary: one of the report needs to be printed in Dot Matrix Printer. So, We need below information 1. Will Fusion BIP bursting supports Dot Matrix Printer? 2. If so, in…
-
How can I add distributions to the Print receivables seeded report after customizationHi Team, I’m facing an issue while adding the Distributions data as a separate data set in the Print Receivables Report. The problem is related to data grouping: When I …
-
Virus Scanner Not Reachable - Unable to Archive Files in My Folders / Shared FoldersSummary: Content (please ensure you mask any confidential information): Hi, We are encountering an issue when trying to archive files in My Folders and Shared Folders. E…Sankalp Shukla 1.5K views 11 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is there a report to monitor Microsoft outlook notification send to learners and instructors?Summary: To monitor the MS outlook notifications for learners and instructors Content (please ensure you mask any confidential information): A report that can provide de… -
Payroll - Personal Payment Details Real Time gives an errorSummary: Hi Everyone, Currently, I'm working on the "Payroll - Personal Payment Details Real Time" Subject Area. when I'm trying to add employee bank details, it gives m…Saher 52 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
What are the considerations of enabling and disabling the global "SQL Pruning" setting in BIP?A customer enabled the global SQL pruning setting in production which caused various BI publisher report issues (primarily, missing columns from various CSV and RTF outp…Harrison Jacob 12 views 0 comments 1 point Started by Harrison Jacob Reporting and Analytics for ERP
-
How to schedule the Payables Period Close Exceptions Report with incrementing period name monthlySummary: I want to schedule the Payables Period Close Exceptions Report monthly that increments the period name parameter in analytics. We have moved the seeded report i…Mikee Tamonan 11 views 1 comment 0 points Most recent by Karun Jain-Oracle Payables, Payments & Cash Management
-
Funds Capture Batch Acknowledgments FormatsSummary Unable to find the Format to customize or to review the structure of the file formatContent Hi, we are not able to find any format listed for "Inbound" formats u…
-
Is there a PVO (or combination of PVOs) that returns the accounting status of a Payables invoice?I need to return the accounting status (Accounted, Partially Accounted, Selected, Unaccounted) for a specific AP invoice but using PVOs. The column "ApInvoicesPostingSta…
-
How to count the number of pages per supplier in a report using RTF.Content (please ensure you mask any confidential information): I am creating reports using BIP (BI Publisher), and I use RTF templates for the layout. The report outputs…
-
Which table holds the error details for unsuccessful imports of Customer Credit hierarchy data?Summary: Hi Team, I am in the process of importing "Credit Hierarchy" data through "Import Management" (Object = Hierarchy & Hierarchy Member) and am working on a BIP re…Dhilip Kumar P. 1 view 1 comment 0 points Most recent by Jesús Vega-Oracle Receivables & Collections
-
How to customize email body and subject and split it by invoice number/customer name?Summary:Hi team, We request some support in modifying the SJG Dunning letter (Reminder emails for unpaid invoices). The email notification to customers/clients only rece…Somnagho_in-Oracle 131 views 1 comment 0 points Most recent by Jesús Vega-Oracle Receivables & Collections
-
Run a BIP report and get the output via REST APISummary: We are trying to run a BIP Report via REST API, but getting 404 not found error. /services/rest/v1/reports/{reportPath}/run Content (please ensure you mask any …Abhilash G S 449 views 5 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
How to build an Custom AP trial Balance report without having to use ap_trial_balances tableSummary: 1. We are trying to build a custom AP trial balance table which we will be sending to ARCS returning the output in a csv format, but without using the ap_trial_…sunny.k.singh 111 views 1 comment 1 point Most recent by NJ.Mazumder Reporting and Analytics for ERP
-
R23 HCM OTBI subject areas to database tables mapping spreadsheetsSummary: I am looking for the R23 HCM OTBI subject areas to database tables mapping spreadsheets. I am looking for the educational major and name fields in the Skills an…User_2025-10-31-00-42-31-597 271 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Printing Count Field in RA_CUSTOMER_TRX_ALLSummary: Hi All, We are trying to use the Printing Count field in the RA_CUSTOMER_TRX_ALL table. The requirement is as follows: For the first three prints, the invoice s…
-
How to Include Invoice Legal Entity in Custom Oracle Payment File for Third-Party IntegrationSummary: We are working on integrating Oracle ERP Cloud with a third-party platform to process Accounts Payable (AP) payments. The process involves submitting a Payment …Khushbu Mahindru 3 views 2 comments 0 points Most recent by George-Oracle Payables, Payments & Cash Management
-
"Go Noto" Font Used in PDF OutputRegarding the default "Go Noto" font used in PDF reports generated by BI Publisher or OTBI, could you please let me know whether the font available for download from the…
-
Query or the table that contains columns of the Account Analysis ReportSummary: Content (required): Hello everyone, I have a requirement to make a custom report for the Account Analysis Report. I need to pick some of the columns in the seed…Sushan Peiris 573 views 8 comments 0 points Most recent by User_K7YG4 Reporting and Analytics for ERP -
AP_Invoices joins for Supplier Detail where vendor_id is negativeSummary: Sql question, I am looking for ap_invoices_all joins where vendor_id is negative, for the following scenarios; - expense (vendor id = -10016), one time supplier…Robert of STAU 857 views 9 comments 0 points Most recent by Adnan Saleem Reporting and Analytics for ERP
-
Need a SQL Query For Segment Value Data SecurityContent Hi there Building a report that show the charts of account data security condition and value. Please advise. Thanks.User_DDXB9 79 views 11 comments 2 points Most recent by Abhisek Choudhury Reporting and Analytics for ERP
-
SQL to fetch Amount Type in Review Budgetary Control BalancesHi All, We would need guidance in identifying the table where the amount type is stored, we could find the amount type in table 'FND_LOOKUP_VALUES_VL' for the lookup typ…
-
COA Segment Values based on Security RulesSummary COA Segment Values based on Security RulesContent We have a requirement to get the Individual COA Segment Values based on the security rules defined for the Role…Vinay Gharge 147 views 5 comments 2 points Most recent by Abhisek Choudhury Reporting and Analytics for ERP -
Is it possible for BI Publisher to read from external Excel file?Summary: Content (please ensure you mask any confidential information): We'd like to integrate Oracle data with an external Excel file stored in a shared location. Such …Stefano_Mazzocca 31 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM