BI Publisher
Discussion List
-
How does Group Notification Configuration works-Send One email containing all email addressesSummary: We are trying to update the Notification Settings for the Invoice Approval Workflow (Approval Group) to Send One Email with all user emails instead of separate …Baskara Sateesh-Oracle 16 views 0 comments 0 points Started by Baskara Sateesh-Oracle Payables, Payments & Cash Management -
How to create a report in OTBI of Manage Payment Process Requests informationSummary: The customer needs to have the information regarding the related invoices in a payment batch. Content (please ensure you mask any confidential information): I a…SERGIO BARRETO 75 views 3 comments 0 points Most recent by Basavaraj Navalagi Payables, Payments & Cash Management -
Positive Pay File in ISO20022 XML formatHi All, We have a requirement from BMO bank to generate Positive Pay file in XML format and should be compliant with ISO20022 format. I have downloaded ISO20022 xsl temp…Alekhya_N 21 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Table and column name in oracle fusion payables to derive the "Allow tax applicability" flagSummary: Hi Team, I need the table and column name to derive the allow tax applicability flag. The "Allow Tax Applicability" flag Appears Checked in the UI but Remains N…SunilPradhan 19 views 5 comments 0 points Most recent by Purvi -Oracle Payables, Payments & Cash Management
-
Custom Disbursement Payment File Format Not Appearing in 'Manage Format' SetupDear All, I have successfully customized the Disbursement Payment File Format report: I also added two custom templates: However, nothing appears in the 'Manage Format' …George Mattar 101 views 6 comments 0 points Most recent by Mark Stonerock Payables, Payments & Cash Management
-
AP_TRIAL_BAL_REPORT_PKGSummary:AP_TRIAL_BAL_REPORT_PKG body code is required Content (please ensure you mask any confidential information): Version (include the version you are using, if appli…
-
Need attachment url from AP invoicesSummary: Need invoice attachment url for approval notification Content (please ensure you mask any confidential information): Trying to add the invoice attachment url to…
-
Supplier Spend Analysis report fails with error ORA-06503: PL/SQL: Function returned without valueWe are trying to run standard report Supplier Spend Analysis report, but as soon as we open the report, it tries to load and fails before we submit the report with error…Shailender Ahuja-Oracle 13 views 2 comments 0 points Most recent by Shailender Ahuja-Oracle Payables, Payments & Cash Management
-
Bank is eliminating weak Ciphers and requiring Oracle to allow specific Ciphers for them though whenSummary: Bank is eliminating weak Ciphers and requiring Oracle to allow specific Ciphers for them though when our Payment process automatically transmits from Oracle Clo…Danny P Smith 33 views 2 comments 0 points Most recent by Katy T Payables, Payments & Cash Management
-
Assistance Required: Locating PVOs for ar_batch_sources_all and ar_credit_memo_amounts Table in BICCSummary: I am currently working on extracting BIP tables from BICC to UCM, but I am unable to locate the tables ar_batch_sources_all and ar_credit_memo_amounts within th…
-
Query to find the approver name for AP invoicesWhat is the query or table name where we can find the approver name and approval date(action date) for an AP invoice. The table ap_inv_aprvl_hist_all gives the approver …KanikaGupta 6.2K views 4 comments 2 points Most recent by User_QTQ8P Payables, Payments & Cash Management
-
Table with error messages and warnings of Supplier Bank Accounts FBDI ImportContent Does anyone know if the error messages and warnings of the Supplier Bank Accounts FBDI Import are stored in a base table of which we can report through BI Publis…User_CR41D 805 views 8 comments 2 points Most recent by Ankit.K Payables, Payments & Cash Management
-
CAMT053 Bank Statement Import is failing with ERROR [LINE_NUM_MISSING]Summary: All Bank Statements imported with CAMT053 format is failing to import with the error message below for each of the lines: [2025-07-15 14:19:59.048] ERROR [LINE_…PwC Team Member 51 views 2 comments 0 points Most recent by Pablo IH Payables, Payments & Cash Management
-
How to get delivery status of each bursting file of BIP report using Sql QueryHow to get delivery status of each bursting file of BIP report using Sql QueryPrafulla_Chaskar 1 view 0 comments 0 points Started by Prafulla_Chaskar Payables, Payments & Cash Management
-
why are the CST_%_DAILY tables on our instances emptyThese tables are purportedly available for use in BI Publisher reports, but all are empty in our instance. Why?
-
Custom Remittance Advice Template not appearing in Manage formatsSeparate Remittance advice do not have a data model. I have created a custom template that in BI publisher in custom folder custom>financials>payments, but my custom tem…KanikaGupta 161 views 2 comments 0 points Most recent by GIRIJA BODLA Payables, Payments & Cash Management
-
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 283 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 20 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 83 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 21 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 72 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 23 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 12 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 24 views 0 comments 1 point 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…