AP9.2.Payment Staging Record PMT_UPARTY_STG Do Not Get Deleted After the Payments Are Loaded From Paycycle to Financial Gateway (Doc ID 2881091.1)

Last updated on JULY 04, 2022

Applies to:

Symptoms

The record PMT_UPARTY_STG is not deleted after the payments are loaded from Paycycle to Financial Gateway. All the other stg records are deleted:

PS_PMT_HEADER_STG, PS_PMT_OTHID_STG, PS_PMT_DETAIL_STG, PS_PMT_ADDRESS_STG, PS_PMT_REF_STG, PS_PMT_INVOICE_STG , PS_PMT_INTRM_STG

Steps to replicate the issue :

1.For the supplier USA000000001 setup the bank USBNK and bank account CHCK on Location tab>Payables hyperlink> Supplier bank account options section

2.For the external bank account CHCK, for the bank USBNK, on the payment method EFT, setup the Finance Gateway as default Electronic Layouts. (Banking>Banks and Branches> Bank Accounts>External Bank Account )

3.Create a voucher with the bank USBNK, account CHCK and payment method EFT and save it.( Accounts Payables>Vouchers>Add/Update Voucher)

4.Setup paycycle in order to include vouchers for bu US001 and Bank USBNK, bank account CHCK and payment method EFT. ( Accounts payables>Payments>Paycycle>Setup )

5.After running the paycycle and the Financial Gateway Electronic Payments  process (AP_FG_PROC) from Paycycle , notice that the record PS_PMT_UPARTY_STG is not

deleted as the other STG records : PS_PMT_HEADER_STG, PS_PMT_OTHID_STG, PS_PMT_DETAIL_STG , PS_PMT_ADDRESS_STG, PS_PMT_REF_STG , PS_PMT_INVOICE_STG

PS_PMT_INTRM_STG

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.