BI Publisher
Discussion List
-
How do you manage consecutive check number using Remittance stub?Summary: When you use Remittance Stub and Void by Overflow in "ExternalCheck.rtf" template for PPR in Account Payables, you have check numbers for void check as well as …Yuko Asanuma 30 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management -
Query/tables to find payment approved by final approver approved PPRSummary: Query/tables to find payment approved by final approver approved PPR Content (please ensure you mask any confidential information): Hi All, We got a requirement…
-
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 226 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
How to customize ISO20022CGI2019.xslSummary:How can I customize ISO20022CGI2019.xsl? Which fields from which records can I use? Content (please ensure you mask any confidential information): Version (inclu…User_VJR36 24 views 2 comments 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
Need query/table to get accounting status of external transactionsSummary: Need query/table to get know the accounting status of an External Transaction Content (please ensure you mask any confidential information): Version (include th…Dipak Das 11 views 1 comment 0 points Most recent by Shouryadeep12-Oracle Payables, Payments & Cash Management
-
Oracle Analytics Publisher Desktop Silent Install FailSummary: I have a requirement to install Oracle Analytics Publisher Desktop to client's machines via a silent install. When trying to perform this install with the synta…Johnny'sDaddy 46 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
SUPPLIER BALANCE AGING REPORT Showing invoices in Unallocated AmountSummary: Needs to understand the current logic of this "Supplier Balance Aging Report Content (please ensure you mask any confidential information): The accounting event…
-
How to get Trial balance detailed ReportSummary: Please let me know how to drill down from the Payables Trial Balance Report to view invoices? Content (please ensure you mask any confidential information): Ver…sailesh_cloudare 12 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Intelligent Payment/ Dynamic Discounting NotificationsHow does the Intelligent Payment/ Dynamic Discounting Notifications get sent out to suppliers on a weekly basis through a scheduled process job?Anushree Chitranshu 13 views 3 comments 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Concatenate elements in eText templateSummary: Concatenate elements in eText Positive Pay template Content (please ensure you mask any confidential information): I am looking to concatenate two data elements…KDR 98 views 3 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Where can I configure date tolerance for PO and AP Invoice matching in Oracle Cloud?Hi everyone, I'm encountering an issue when trying to match a Purchase Order (PO) with an Accounts Payable (AP) Invoice. The error message indicates that "This line has …Engel 57 views 2 comments 0 points Most recent by Abdelaziz Safwat 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 22 views 1 comment 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management
-
Payment Process Request Status RTF Templatein Payment Process Request Status RTF Template, Get_Variable working directly without declaring Set_Variable. Anybody experienced same in RTF? If I use Set_Variable syst…KISHAN BUSSA 1 view 1 comment 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management -
Does Oracle Fusion support Microsoft Unified Printer ServerSummary: Does Oracle Fusion support Microsoft Unified Print Server, Can we connect to a printer which is exposed on Microsoft Unified Server. As the client specifically …
-
How to prevent approval or validation of invoices whose BUs are different between line and headerSummary: I would like to know how I could create a rule to prevent the approval or validation (preferably) of invoices whose Business Unit is different between the Invoi…FilipeFerreira_ 2 views 1 comment 0 points Most recent by Shouryadeep12-Oracle Payables, Payments & Cash Management
-
How to add Intermediary Bank account field for Customized ISO20022 Payment FormatSummary: Hello, We need a customized ISO20022 Payment format with the intermediary bank account fields. I followed the doc ID How To Add Intermediary Bank Fields for Cus…Mariam Lefranc 91 views 3 comments 0 points Most recent by JANKUR Payables, Payments & Cash Management -
How to print overflow checks on plain paper using different tray's in printer.Summary: Hi Team. We have a requirement to print overflow remittance pages of AP Check on a different paper than the check paper. For example, in the check template, if …Ramprakash09 158 views 4 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
Is there any settings for Check Print to print void at the last actual check amount on the 1st page?Summary: Standard check print Report is invoked as part of payment process request whenever payment is done automatically Format Payment Files program trigger and output…Sonal Umesh Jawalkar 172 views 7 comments 0 points Most recent by Yuko Asanuma Payables, Payments & Cash Management
-
How to handle & symbol in payment file xsl templateSummary: Need to replace '&' symbol with 'and' in payee name and address fields. We have triedsrziffdavis 13 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
On Etext template, is it possible to create LOV for reference within the template?Hello, We have a requirement to create a payment file format on Etext template. We have a field that needs to display a 3 character string that will serve as a code equi…Kristelle 11 views 1 comment 0 points Most recent by Lakshmish Rao-Oracle Payables, Payments & Cash Management
-
Address information for SingaporeSummary: HI All Could anyone advice what is the correct navigation for StreetName and Building number in case of Syngapore? I'm trying to create xsl payment file Content…Aleksandra Bykhan 12 views 1 comment 0 points Most recent by Lakshmish Rao-Oracle Payables, Payments & Cash Management -
Query to get tax registration from supplier address levelSummary Tax Registration from Supplier AddressContent Hello I was wondering if you can share with me any SQL to get the Tax Registration at the address Level. I have the…gabriel kinovisques-163562 4K views 6 comments 1 point Most recent by Ch M Prasad-Oracle Payables, Payments & Cash Management
-
How is the data in the DOCUMENT column of IBY_TRXN_DOCUMENTS generated?Summary: How is the data in the DOCUMENT column of IBY_TRXN_DOCUMENTS generated? Content (please ensure you mask any confidential information): Version (include the vers…User_VJR36 11 views 1 comment 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management
-
What is SrcDescriptiveFlexField?We are using the standard Oracle data model TransactionDocumentExtractDm to review Payment files for XML and standard remittance template building but are not sure what …Cam Mistry 22 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
invoice approval report with signatures of all approversHi, Business requirement is to create a payable invoice pdf template with signatures of all approvers. Currently we are having signatures on PO pdf output but only of la…Rahim Azam Butt 3 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
Automatic Report Printing PaymentsDear All, I have successfully customized two BI reports using my own data model and RTF template—one for cash payments and the other for check payments. I need to config…George Mattar 1 view 1 comment 0 points Most recent by Priyanka Gunasekaran-Oracle Payables, Payments & Cash Management
-
QR Codes For Billing and PaymentsSummary QR Code Integration For Oracle PaymentsContent This summer (June 2020) Switzerland has announced that it will be switching from payment slips (orange and red) to…User_8O6L5 724 views 13 comments 3 points Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management
-
Table details to get Business unit for a tax code definedSummary: We need table or query to fetch business unit name for the given tax rate code. Content (required): Version (include the version you are using, if applicable): …Nishanth B Jain 139 views 4 comments 0 points Most recent by Nishanth B Jain Payables, Payments & Cash Management -
Self Service related Privilege's for Oracle Fusion PayablesSummary: We are looking Self service related Privilege's to Invoice Payables. The below two privileges provide access to Payables and are considered part of the license …Linga Murthy 190 views 4 comments 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Report Fail with ErrorSummary: Content (please ensure you mask any confidential information): I have created a report to retrieve unreconciled transaction details. The report contains four da…Tharushi Sathsarani 14 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management