BI Publisher
Discussion List
-
Does the output of Payables Period Close Exceptions Report placed in UCM?Summary: Hello Everyone, We have a requirement where the output of report - 'Payables Period Close Exceptions Report' needs to be downloaded for users who does not have … -
Request for SQL Query to Retrieve Cash Balances with Specific ColumnsSummary: Provide a SQL query for Cash Balances to include columns with Legal Entity Name, Entity ID, Bank Account Number, Bank Account Name, Bank Account Type, Currency,…Guthi Mallikarjun 283 views 3 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
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 449 views 6 comments 5 points Most recent by MiguelMaldonado Payables, Payments & Cash Management -
Conditional Signature Printing in Disbursement Payment File Formats Based on Fusion InstanceSummary: In the Oracle Fusion ERP seeded report “Disbursement Payment File Formats”, I need to conditionally print a signature in the check template based on the Fusion …Basavaraj Navalagi 18 views 0 comments 0 points Started by Basavaraj Navalagi Payables, Payments & Cash Management -
Customization of seeded "Supplier Balance Aging Report"Summary:Hi, I am looking for customization of seeded Supplier Balance Aging Report in Oracle fusion application where I want to add currency as a parameter to run the re…Shraddhha Namde 204 views 12 comments 0 points Most recent by Smruthi M Reporting and Analytics for ERP
-
Oracle AI Apps: Intelligent Account Combination DefaultingSummary: Hi Oracle Team, https://us.v-cdn.net/6034893/uploads/2NO1N9TY10A9/iacd-supplemental-setup-guide.pdf When i going to enable this feature 'Oracle AI Apps: Intelli…Mina Sabry 148 views 13 comments 0 points Most recent by Sudip Dutta Payables, Payments & Cash Management
-
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 16 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 64 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 41 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 144 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 295 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 11 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 98 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 83 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 42 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 31 views 5 comments 0 points Most recent by Purvi -Oracle 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 30 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 40 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 845 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 55 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 6 views 0 comments 0 points Started by Prafulla_Chaskar Payables, Payments & Cash Management