BI Publisher
Discussion List
-
CSV file bank statement importSummary: We have reached out to our BANK, but they are unable to provide statements in the BAI2 format. One BANK can provide statements in CSV format, while the other do…Naresh12345 11 views 3 comments 0 points Most recent by Naresh12345 Payables, Payments & Cash Management -
Query to fetch Approvals Groups Across Workflow ModulesSummary: We need to update a workflow approval group. I’d like a query that shows, by module, every workflow rule that will be affected by this change. Exemple: Approval… -
1099k reportingSummary: As there is a requirement for suppliers to generate the 1099-K form, is it possible to handle 1099-K reporting within Oracle Fusion? If so, how can this be achi… -
Schedule the ESS Job set in Oracle fusion for Mon-FridaySummary: How to schedule an ESS job set in Oracle fusion to run for week days only and exclude Weekends. Content (please ensure you mask any confidential information): H…Sridhar_Rejeti_1423 10 views 2 comments 0 points Most recent by Sridhar_Rejeti_1423 Payables, Payments & Cash Management -
How to enable deep link in payment approval notificationSummary: How to enable deep link in payment approval notification? Content (please ensure you mask any confidential information): Hi all, We got a requirement to show in…Venkatesan 48 views 2 comments 0 points Most recent by User_W53WG Payables, Payments & Cash Management -
How to disable "Import Payable Invoices Report" generating for every Import Payables ESS Job run?Our client uses another system to process their AP Invoices. They validate the invoices triggering the web service for Invoice Import (7.5-10k per day). This process is …Camilo Botín-Oracle 48 views 1 comment 0 points Most recent by dwalia-Oracle Payables, Payments & Cash Management -
Where to find the client channel data (i.e., the payment initiation method) in ERPHi, The requirement is to identify where the client channel data (i.e., the payment initiation method, such as H2H or J.P. Morgan Access) is stored in Oracle Fusion, and…Keerthana Sekar 13 views 2 comments 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management -
can not see all records in AP_IDR_INVOICE_TRACE_DYD tableSummary: Table - AP_IDR_INVOICE_TRACE_DYD, this table is used in standard invoice document recognition tracking report. But when we have queried the table, we can not se…Rama Krishna T 24 views 2 comments 0 points Most recent by Rama Krishna T Payables, Payments & Cash Management -
Custom Payables Invoice Aging Report did not copy the parameterSummary: copy of the Payables Invoice Aging Report did not copy the parameter Content (please ensure you mask any confidential information): Version (include the version…ERP User 7 views 1 comment 0 points Most recent by HD - Oracle Fusion ERP-Oracle Payables, Payments & Cash Management -
Updated Supplier Profile/Address level bank account number is not visible before change req approvedHello Team, I'm in need of information regarding supplier-level bank account number updates. When we do any update in bank account number in supplier profile or supplier…SritharThangavel 123 views 4 comments 0 points Most recent by Anum Arshia Payables, Payments & Cash Management -
Payment Approval Is Not TriggeringSummary: Payment approver is not triggering any approval for condition is 1=1. It means approval should trigger for all the payments. But its not triggered. I am not als…Kish_Hariharan 20 views 4 comments 0 points Most recent by Kish_Hariharan Payables, Payments & Cash Management -
How to restrict Asset Book parameter in ESS Job and BIP based on user granted access?Summary: Content (please ensure you mask any confidential information): We have a custom BIP report to extract asset details which contain the 'Asset Book' parameter, th… -
Network configuration and printer settings when printing directly from ERPWhen using the AP module to run PPR to make payments, is it possible to select a printer (TROY) connected to a PC terminal by cable and print checks directly from the ER… -
Suppliers are not receiving Remittance AdvisesSummary: For some reason, none of our suppliers are receiving any Remittance Advises. The configuration on disbursements options, Payment process profiles, and supplier …Murali M. 492 views 17 comments 0 points Most recent by Thriveni Gudipati Payables, Payments & Cash Management -
Display Latest Approver in Custom Payables InfoletSummary: Hi All, Currently, I have created a custom Payables Infolet, in which I added the "Approval Status" and "Approver" information. However, the application display…Ucup Maulana 29 views 1 comment 0 points Most recent by Cosmin Nadolu-Oracle Payables, Payments & Cash Management -
Check print using Dot Matrix printer on Oracle FusionSummary: Unable to print a check on a Dot Matrix printer. Content (please ensure you mask any confidential information): We are attempting to print a preprinted bank che…Dinesh_Mani 31 views 1 comment 1 point Most recent by SankarBalu Payables, Payments & Cash Management -
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 268 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 362 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 13 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 200 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 134 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 12 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… -
How to join CE_STATEMENT_LINES, CE_RECON_HISTORY, CE_RECON_HISTORY_ITEMS, AP_CHECK_ALLWe are building a BI publisher report to list Bank Statement Number, Bank Statement Line, Statement Line Amount, AP Payment Number Using the tables CE_STATEMENT_HEADERS …Pradeep Kumar Reddy V 42 views 2 comments 0 points Most recent by Pradeep Kumar Reddy V Payables, Payments & Cash Management -
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 42 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 22 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…User_7KNJ1 10 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 5 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 29 views 5 comments 0 points Most recent by Mahmoud Adel Payables, Payments & Cash Management