BI Publisher
Discussion List
-
Cannot drilldown to Invoice UI from Payment approval notificationThere is no hyperlink to drilldown to Payables invoice from PPR notification for the approver. Is there a way to enable this? Or is there a report that can be run that h…SarahL 15 views 1 comment 0 points Most recent by HD - Oracle Fusion ERP-Oracle Payables, Payments & Cash Management -
how DOCUMENT_CLOB gets populated in IBY_TRXN_DOCUMENTS table?We have requirements to create custom payment documents. We are reusing ISO20022CGI.xsl file from Disbursement Payment File Formats. The data model has SELECT DOCUMENT_C… -
1099 Future Support for IRS A2A (Application-to-Application) XML File FunctionalityDescription: We are seeking information on whether Oracle plans to support IRS A2A (Application-to-Application) XML file functionality within the product in future relea…Senthil Murugan J 57 views 1 comment 0 points Most recent by Dhaval Patel-Oracle Payables, Payments & Cash Management -
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 26 views 5 comments 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management
-
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 16 views 1 comment 0 points Most recent by Karun Jain-Oracle Payables, Payments & Cash Management
-
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 8 views 2 comments 0 points Most recent by George-Oracle 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 34 views 5 comments 0 points Most recent by Mahmoud Adel Payables, Payments & Cash Management
-
Please help us understand if we can use 'JPMPOSITIVEPAY.xsl' file for generating XML output for BankAfter designating JPMPOSITIVEPAY.xsl (Standard Oracle Template) as the default template for the "Disbursement Positive Payment File" XDO, we are unable to generate the X…
-
Separate Remittance Advice sent as Email - formatting of email bodySummary: How can I generate the SRA in email with the formatting in place? Content (required): We have created a custom Separate Remittance Advice (SRA) format. When the…Niall McColl 134 views 3 comments 0 points Most recent by Bhawna Payables, Payments & Cash Management -
Trial Balance Report data model errorHi, I'm trying to customize 'Trial Balance Report'. When I run TrialBalanceDm with relevant parameters, its throwing below error. ORA-20101: ORA-06512: at "FUSION.GL_TRI…Manavalan 281 views 5 comments 0 points Most recent by Lasantha Ranjana Bandara Payables, Payments & Cash Management
-
I want joins for ap_terms_tl and FND_SETID_SETS tabSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Sushmita Nagaraj Doddamani 10 views 2 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
How to Unmask Bank Account Details when Masking and Encryption is EnabledSummary: Hello Everyone, In Oracle Fusion Applications, we have enabled "Bank Account Encryption" and also "Bank Account Number Masking (last 4 digits)" through System S…Bharath2712Automus 85 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
How does Group Notification Configuration works-Send One email containing all email addresseshttps://us.v-cdn.net/6034893/uploads/L3VF2N09KV4L/bpm-group-notification-configuration.docx Summary: We are trying to update the Notification Settings for the Invoice Ap…Baskara Sateesh-Oracle 24 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 82 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 38 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 30 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 128 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…
-
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 26 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 36 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 833 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 53 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 4 views 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 170 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 308 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 24 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 95 views 3 comments 0 points Most recent by User_U58AH Payables, Payments & Cash Management