BI Publisher
Discussion List
-
Query to extract open AP and AR invoices with all FBDI template fields to upload in another accountSummary: We are splitting our Legal entities and hence we need to extract all open Invoices and upload into a different account. Can you please help me with a query to e… -
A Functional Guide for customizing Disbursement Payment File Format in Oracle Cloud ERPHi All, Please find below detailed steps on how an Oracle Finance Functional Consultant should approach the customization of any payment file (Disbursement Payment File)…CA Nirmal Choudhary 126 views 3 comments 3 points Most recent by Swapnil Kashid Payables, Payments & Cash Management -
Suppliers are not receiving remittance adviceSummary: I've a customer who moved to 24C in August, since then remittance notices are not being received by suppliers - they are all reporting not receiving them, not j…Maria Smith- de Novo Solutions 346 views 7 comments 0 points Most recent by Shashidhar AM Payables, Payments & Cash Management
-
Custom ESS Job submit window is not opening in Schedule New Process ScreenHi Team, We have encountered an issue with the custom ESS Job. When attempting to submit the job via the Scheduled Process Screen in our lower environment, the parameter…Vigneswaran Ck 20 views 4 comments 0 points Most recent by Vigneswaran Ck Payables, Payments & Cash Management
-
Requirement to customize the Payables Selected Installments Selection data model to add new columnSummary: We have a requirement to customize the Payables Selected Installments Selection report data model to add new column, but the customize option is not available f…Shailender Ahuja-Oracle 43 views 6 comments 0 points Most recent by Kunal Vatyani Payables, Payments & Cash Management
-
Connect to PaaS db from BIP to create report from custom tables created in PaaSSummary: Connect to PaaS db from BIP JDBC / JNDI connection to create report from custom tables created in PaaS Content (please ensure you mask any confidential informat…Jepson Erattuparmbil 2 views 1 comment 1 point Most recent by Suresh Mohan Gulrajani BI Publisher Learning Center
-
Accrual Month end Report Query based on CMR_PO_ACCRUAL_AMTS tableHi All, Business Background: Our business requires an automated PO Receipt Accrual Period End Process to support end-of-month activities related to purchasing. The curre…
-
Invoices incomplete status with yellow exclamation markSummary: Invoices imported by IDR are in an incomplete status. The lines on the invoices have a yellow exclamation mark, with type Item. We have a requirement to report …Narinder Sian 50 views 3 comments 0 points Most recent by Kanika Matta Payables, Payments & Cash Management
-
How to Include Supplier Site-Level Details in Payment XML generated by Oracle FusionWe are working with Oracle Fusion Payments and have a requirement to include supplier site-level information in the payment XML (Seeded XML generated by Fusion) and the …mauryapradhyumn420 27 views 2 comments 0 points Most recent by mauryapradhyumn420 Payables, Payments & Cash Management
-
Addition of columns to U.S 1099 Payment reportHi, We had requirement to add below columns to U.S 1099 Payment Report. Vendor Type of TIN ( E/S) Vendor Recipient Address 1 Vendor Recipient Address 2 Vendor Recipient …Ismail Sherief 2 views 0 comments 0 points Started by Ismail Sherief Payables, Payments & Cash Management
-
Customizing Separate Remittance Advice Subject with dynamic valueSummary: Customizing Separate Remittance Advice Subject Content (please ensure you mask any confidential information): Hi Team we should customize the subject with PAYEE…Luca Nobili PWC 141 views 4 comments 0 points Most recent by CristinaV1-Oracle Payables, Payments & Cash Management
-
AP_INVOICES_UTILITY_PKG.GET_APPROVAL_STATUS p[erformanceSummary: Performance issue in AP_INVOICES_UTILITY_PKG.GET_APPROVAL_STATUS pkg Content (please ensure you mask any confidential information): Hi, I am using SELECT distin…azodpe 79 views 1 comment 0 points Most recent by Gabriela Patrascu-Oracle Payables, Payments & Cash Management
-
How to incorporate count of payment numbers in rtf template Positive pay file in fusionHow to incorporate count of payment numbers in rtf template Positive pay file in fusionKavitha Nanjundaiah-Oracle 5 views 1 comment 0 points Most recent by Kavitha Nanjundaiah-Oracle Payables, Payments & Cash Management -
Why does the logo for our Separate Remittance Advice ends up as attachment via emailSummary: Our Separate Remittance Advice is customized and our client wants to have a logo on the SRA. When the delivery method is via Email with .pdf as attachment, the …Christian Roxas 13 views 2 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Report to view unprocessed IDR InvoicesSummary: I have a requirement to create a report to show all unprocessed IDR invoices. Is there a table that provides this information? Content (please ensure you mask a… -
in Payment Files using SWIFT MT103 file format, how do I get 2 zeroes for the Decimal?I have an issue with regards to the decimal of the PaymentAmount/Value field. Below are the details of the field. Length - 2 Format - Number, Decimal Data - PaymentAmoun…
-
query to get page customization data through sandboxSummary: Required SQL table name where page customization information stored throgh Sandbox Content (please ensure you mask any confidential information): Hi Team, Can a…
-
How to hide custom Report from BIP page and ESS job from Scheduled Process ?Hi Team, I have a requirement to hide Custom Report and Respective ESS job (BI catalog page and Scheduled process) From User's view. Tool → Scheduled Process →ESS job. T…
-
Format Payment File -ORA-64451: Conversion of special character to escaped character failed error?Summary: Hello, has anyone received the error above when attempting to run Format Payment Files? If so, have you developed approaches to either proactively prevent the i…
-
facing error in OIC with reference to argument9 parameter from supplier balance aging report.Summary: We are facing error/exception in OIC with reference to argument9 parameter from supplier balance aging report. There is no option to check the attribute name fo…
-
How to send formatted Payment Files from Oracle Cloud to a SFTP-server automaticallySummary: How to send formatted Payment Files from Oracle Cloud to an external SFTP-server automatically? Content (please ensure you mask any confidential information): H…Marcus S. 190 views 12 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management -
Flexibility of Separate Remittance Advice Email BodyContent (please ensure you mask any confidential information): Currently, our client would like to have an email body to an SRA if the delivery method is 'Email with .pd…Christian Roxas 15 views 3 comments 0 points Most recent by Christian Roxas Payables, Payments & Cash Management
-
Why cant I find AI Apps Administrator under Tool (quick link)Summary: We planned to use newly (23B) rolled Intelligent Account Default AI feature in Fusion Payables. The first step is to add role 'Application Implementation Consul…Bikash Khilar 354 views 21 comments 0 points Most recent by Beat Nuolf-Oracle Payables, Payments & Cash Management
-
Check Print Page countHi Team, We have a requirement of developing a report which gives the count of pages that was used for a particular check in Oracle Fusion. Questions: 1. Are there any b…Sandipan Pal 2 views 1 comment 0 points Most recent by Nani Prasanth Doredla-Oracle Payables, Payments & Cash Management
-
I m getting below error on job run####[2025-06-04T06:47:38.908+00:00] [INFO] dummy file is deleted ================ BIPJobExecutable Execution Started ============ OutputFile : /u01/APPLTOP/instance/ess/…Tejashwini K H 22 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Payment File formatSummary: Payment File format Content (required): Hi All, We got a requirement from the bank to modify the Payment file format . Currently the format is, R|DEBIT_ACCOUNT_…Venkatesan 33 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Custom Data Model Not Reflecting in Payment File – Fix?Summary: Context: We have set up a transmission configuration to transmit files to an SFTP server. Additionally, we have: Created a Data Model to extract the required fi…Sandeep cheerla 3 views 2 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
SQL query or link between CE_CP_OPTIONS and CE_CP_OPTION_TIME_DIMSSummary: Hi TTeam, Could you please help us on this below SQL query or link between CE_CP_OPTIONS and CE_CP_OPTION_TIME_DIMS in Specify Cash Positioning and Forecasting …Opkey PA 11 views 3 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Unable to find validation status in AP_INVOICES_ALLWe are creating a custom report and we need to give invoice validation status as a parameter. I am not able to find anything with validation status. Need some help on it…KabirB 27 views 4 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management -
SQL query to get Manage Withholding Tax Classifications setup dataSummary: Hi Team, We need a table where the information of Manage Withholding Tax Classifications setup data. The table ZX_ID_TCC_MAPPING_ALL have the classification cod…