My Oracle Support Banner

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.


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.state || ' '|| hzl.postal_code party_site_address,
  nvl(hzl.address_style, 'DEFAULT') address_style,,
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)))


To view full details, sign in with your My Oracle Support account.

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

In this Document

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