Refer to Blog Post for generating Public/Private Key combination Through File Import and Export wizard, Private key should be uploaded to UCM Account “fin/payments/import“ Note:… Read More »Process to Upload Public/Private Key for File Transmissions in Oracle ERP Cloud
This query list all payment documents under a payment batch with detailed invoice and Supplier/Employee information. /********************************************************************** *PURPOSE: Query to list all Documents and their… Read More »Query to list all Documents and their information under a Payment Process Request
/********************************************************************** *PURPOSE: Query to list Supplier Bank, Bank Branch, Bank Account information *AUTHOR: Shailender Thallam ***********************************************************************/ SELECT owners.account_owner_party_id, asp.segment1 vendor_num, asp.vendor_name, (SELECT NAME FROM apps.hr_operating_units… Read More »Query to list Supplier Bank, Bank Branch, Bank Account information
/********************************************************************** *PURPOSE: Query to list all Bank, Bank Branch, Bank Account information * Operating Unit wise *AUTHOR: Shailender Thallam ***********************************************************************/ SELECT cba.bank_account_name , cba.bank_account_id, cba.bank_account_name_alt,… Read More »Query to list Bank, Bank Branch, Bank Account information Operating Unit wise
Unlike check printing, Positive Pay XML data is NOT present in table IBY_TRXN_DOCUMENTS. To get XML data for Positive Pay, we need to attach ‘Extract… Read More »XML Data for Positive Pay
Generally after running Payment Process Request, we can get the XML data in the log file of ‘Format Payment Instructions with Text Output’ using which… Read More »XML Data of AP Check Payments – Format Payments Instructions in R12
Oracle has provided an extensible user hook “IBY_FD_EXTRACT_EXT_PUB” to add custom tags as part of seeded payment XML extract generated by Oracle Payment process. This… Read More »Customizing Oracle Payments XML extract to include Custom XML Tags