EAP WTHD18: 1099 Report Post abends at Step AP_APY1099.BD100.Step32 if Supplier Address is deleted (Doc ID 2500390.1)

Last updated on DECEMBER 06, 2019

Applies to:

Symptoms

When running the 1099 Report, process abends at Step AP_APY1099.BD100.Step32 with an error.

Supplier has 2 different Address ID's with 1 Location and 2 different Effective Dated rows, where each Effective Dated rows points to a different Address on the Withholding Supplier Information page.

Issue occurs if the Voucher is created for a particular Address then that Address is deleted from the Supplier prior to running the 1099 processes.

ERROR
-- 10:24:17.020 Process 21757703 ABENDED at Step AP_APY1099.BD100.Step32 (Action SQL) -- RC = 1407
ROLLBACK
/
-- 10:24:17.031 SQL Error: ORA-01407: cannot update ("SYSADM"."PS_WTHD_1099_3TMP"."COUNTRY") to NULL

STEPS
1. Supplier setup with 2 different Address ID's with 1 Location and 2 different Effective Dated rows, where the 1st Effective Dated row points to Address 1 and the 2nd Effective Dated row points to Address 2
2. Create Withholding Voucher for Address 2
3. Manually record a payment for the Voucher
4. Run Payment Posting
5. Run Post Withholding
6. Run 1099 Report Post
7. Run 1099 Report
8. Process abends at Step AP_APY1099.BD100.Step32 with the above error

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.