ECM: No Payments Coming Up In Financial Gateway when searching on Payment Dispatch and Review Payments page with Payee name that has Apostrophe (``) character in the Name. (Doc ID 2523643.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Payment Review and Payment Dispatch Search Not working if Payee name has apostrophe ` character in the Name.

If supplier/Employee Name is having apostrophe ` character in the Name. Searching on Review Payment with Payee Name populated ,does not Fetch the results.
    Navigate: Financial Gateway > Review Payments > Payments
    Navigate: Financial Gateway > Process Payments > Payment Dispatch
        - Provide all relevant details and Payee Name, Click Search

STEPS:

1) Create Supplier with Supplier Name has Apostrophe ` (Example: Abc`xyz)
2) Create Voucher for the Supplier
       - Settle by Financial Gateway , Payment Method = ACH
3) Pay the voucher using Pay Cycle and Interface to Financial Gateway by running AP_FG_PROC
4) Navigate: Financial Gateway > Process Payments > Payment Dispatch
    - Provide Date Criteria and other details except (Payee Name)
    - Click Search and Rows is fetched
 
5) Navigate: Financial Gateway > Review Payments > Payments
    - Provide Date Criteria and other details except (Payee Name)
    - Click Search and Rows is fetched

6) Navigate: Financial Gateway > Process Payments > Payment Dispatch
    - Provide all relevant details and Payee Name
    - Click Search
       No Rows is fetched  ===> Issue with Payee Name
 
7) Navigate: Financial Gateway > Review Payments > Payments
    - Provide all relevant details and Payee Name
   - Click Search
       No Rows is fetched  ===> Issue with Payee Name

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.