BI Publisher
Discussion List
-
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 13 views 1 comment 0 points 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 255 views 3 comments 0 points Most recent by Alexandra Tam -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 5 views 0 comments 0 points Started by Rama Krishna T 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 4 views 0 comments 0 points Started by Keerthana Sekar 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 15 views 1 comment 0 points Most recent by Kish_Hariharan 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 310 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 14 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 188 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, When i going to enable this feature 'Oracle AI Apps: Intelligent Account Combination Defaulting' , I can't find the mentioned job role AIAPPS_BI…Mina Sabry 129 views 13 comments 0 points Most recent by Sudip Dutta Payables, Payments & Cash Management
-
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…
-
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 10 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 22 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 28 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 21 views 5 comments 0 points Most recent by Venkatesh Padamwar 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 24 views 0 comments 0 points Started by Ucup Maulana 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 9 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 3 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 23 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…
-
AP Check print squares instead of MICR Numbers at bottom of the CheckSummary: AP Check print squares instead of MICR Numbers at bottom of the Check BIP Report = Downloaded the Disbursement Payment File Formats Shared Folders > Financials …Vincent T 25 views 2 comments 0 points Most recent by Vincent T Payables, Payments & Cash Management
-
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 115 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 263 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 2 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 56 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 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 71 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 23 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 17 views 5 comments 0 points Most recent by Purvi -Oracle Payables, Payments & Cash Management