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:PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
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.
-- 10:24:17.020 Process 21757703 ABENDED at Step AP_APY1099.BD100.Step32 (Action SQL) -- RC = 1407
-- 10:24:17.031 SQL Error: ORA-01407: cannot update ("SYSADM"."PS_WTHD_1099_3TMP"."COUNTRY") to NULL
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
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