BI Publisher
Discussion List
-
Restrict Quick Payment and Allow only Manual PaymentIssue: There ate no apporvals for Payments created via create payments tab. So, Business wants to restrict the users only to make manual payments from Create Payments Ta…Jagjit Singh Arora 277 views 4 comments 0 points Most recent by GIRIJA BODLA Payables, Payments & Cash Management -
Using Multiple SSL Certificates for Different PrintersDear All, I have multiple printers and multiple SSL certificates. I need to use a different SSL certificate for each printer. However, when I enter the Delivery configur…George Mattar 11 views 0 comments 0 points Started by George Mattar Payables, Payments & Cash Management
-
Query Supplier Account Bank Information TableSummary: I Want to export all information about supplier account bank via BI Report Content (please ensure you mask any confidential information): Supplier on Procuremen…Muhammad Fahmi 68 views 3 comments 0 points Most recent by User_U58AH Payables, Payments & Cash Management
-
We need show Invoice Distribution COA Account segment values on AP CheckSummary: We need to show Invoice Distribution COA Account segment values on AP Check in Fusion Cloud Accounts Payable. These fields are not available in XML. I cannot ad…Ibrahim Konak 22 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
How to Add Custom Email Body Text for Separate Remittance Advice Email (with PDF) in OracleHi All, In Oracle Fusion Payables, I need to send a Separate Remittance Advice by email with a PDF attachment and have a specific message appear in the email body. The m…Mukesh Sirigiri 64 views 3 comments 0 points Most recent by Mukesh Sirigiri Payables, Payments & Cash Management
-
How to use 'Ignore Participant' under the THEN option in the BPM Rules for Invoice Approvals?Summary: We are trying to use 'Ignore Participant' asunder the THEN option for one of the AP Invoice routing rules in the BPM but getting an error ' RUL-05730 : type "LI…AkashAgarwal 1.4K views 4 comments 0 points Most recent by RenganathanVenkatesan Payables, Payments & Cash Management
-
Add an Email Body to Separate Remittance Advice Emails with attached PDF by using BI ?Summary: Since there's still no Email Body feature available when using Separate Remittance Advice Emails with attached PDF -but- is it maybe possible to add an Email Bo…Marcus S. 35 views 3 comments 0 points Most recent by Sankalp Gupta Payables, Payments & Cash Management -
How to get XML extract "Funds Capture Payer Notification" ReportIs there any way or SQL query to get XML extract for Funds Capture Payer Notification There is a sample provided from Oracle but we want actual one. Is Any XML Output Fo…CA Nirmal Choudhary 2 views 1 comment 0 points Most recent by CA Nirmal Choudhary Receivables & Collections -
how to populate rejection reason for expense auto rejected by WorkflowSummary: Whenever an expense report is auto rejected due to workflow the user wants to see a descriptive reason for teh rejection but currently in expense report only th…User_PZTF9 13 views 4 comments 0 points Most recent by Yahya Khan Payables, Payments & Cash Management
-
Mapping Payment Format - Replace decimal with commaSummary: Mapping Payment Format - Replace decimal point with comma Content (please ensure you mask any confidential information): EText RTF Template - Fixed position tem…Amit Patnaik 11 views 1 comment 0 points Most recent by Amit Patnaik Payables, Payments & Cash Management
-
what is the relevant table for ap_batches_all table in oracle fusionwe have AP_BATCHES_ALL table in oracle fusion, but we don't see any data in table . Is there any relevant table for ap batchesHarshitha S Motagi 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
what is the XML Field for file modifier in payment file ACH formatwhat is the XML Field for file ID modifier in payment file ACH format for Bank of America. Attached is the bank specifications.Harshitha S Motagi 11 views 0 comments 0 points Started by Harshitha S Motagi Payables, Payments & Cash Management
-
Suggestion Needed: Removal of special characters at the XSL template level for Payment OutboundsHi Oracle Cloud Community, I hope this message finds you well. We are working on a project where our client requires payment outbound files generated in oracle cloud whi…Subhranil Maitra 22 views 0 comments 0 points Started by Subhranil Maitra Payables, Payments & Cash Management
-
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…
-
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 380 views 7 comments 0 points Most recent by Shashidhar AM 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 45 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 3 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 45 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 26 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 1 view 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 164 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 107 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 1 view 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…