Cannot Pay "Payment Request" In Cash Management

(Doc ID 2274801.1)

Last updated on OCTOBER 11, 2017

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

Cannot Pay "Payment Request" from CM

The payment request can be manually paid from AP ...but not CM

The LOV attached to the Payment form (APXPAWKB) does not pick up the 'Payment Request' supplier site :


select hps.party_site_id,
  hzl.address1 || ' ' || hzl.address2 || ' ' || hzl.city ||
  ' '|| hzl.state || ' '|| hzl.postal_code party_site_address,
  hps.party_site_name,
  hzl.address1,
  hzl.address2,
  hzl.address3,
  hzl.address4,
  nvl(hzl.address_style, 'DEFAULT') address_style,
  hzl.city,
  hzl.county,
  hzl.state,
  hzl.province,
  hzl.postal_code,
  hzl.country
from hz_parties hzp, hz_party_sites hps, hz_locations hzl
where hzp.party_id = :pay_sum_folder.party_id
and hps.party_id = hzp.party_id
and hps.party_site_id = nvl(:parameter.pay_in_full_party_site_id, :pay_sum_folder.party_site_id)
and hzl.location_id = hps.location_id
and (trunc(sysdate) between trunc(nvl(hps.start_date_active, sysdate))
  and trunc(nvl(hps.end_date_active, sysdate)))
and (trunc(sysdate) between trunc(nvl(hzl.address_effective_date, sysdate))
  and trunc(nvl(hzl.address_expiration_date, sysdate)))
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms