BI Publisher
Discussion List
-
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… -
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…
-
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 18 views 2 comments 0 points Most recent by Vivek Mandowara-Oracle Payables, Payments & Cash Management
-
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. 485 views 17 comments 0 points Most recent by Thriveni Gudipati 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 10 views 1 comment 0 points Most recent by User_UI5GK 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 21 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 261 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 8 views 0 comments 0 points Started by Rama Krishna T 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 326 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 11 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 192 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 131 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 33 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 35 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 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 4 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 27 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 119 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 267 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 3 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 66 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management