My Oracle Support Banner

EAP: Unable to Set New Withhold to Y on Update Supplier Withholdings Page Even After Setting New Withhold to N - Keep Getting Message (7400,111) (Doc ID 2893400.1)

Last updated on APRIL 28, 2024

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

After applying <Bug 32999171> - AP: UPDATE VOUCHERLINE WITHHOLDING, UPDATE SUPPLIER WITHHOLDINGS, NOT UPDATING WTHD_TRXN_TBL, when a 1099 Supplier has data on the WTHD_TRXN_TBL with 2 different WTHD_TYPE’s and at least 3 different years specified for the WTHD_DECL_DATE, unable to set the New Withhold option to Y on the Update Supplier Withholdings page. Keep on getting the below message even if Step 1 was performed prior to performing Step 2.

MESSAGE
Supplier (xxxxx yyyyyyyyyy z) has withholding data with multiple withhold entities/types for Business Unit zzzzz (7400,111)

For this scenario follow these steps to make necessary corrections:

1. Set the New Withhold option to N and run the Withholding Update process

2. Set the New Withhold option to Y, change the necessary Type/Class, and run the Withholding Update process

Another option would be to use Update Voucher Line Withholding to change the withholding Type/Class.

STEPS
1. 1099 Supplier is setup with 2 different Withholding Types -- 1099 and 1099N
2. 1099 Supplier has data on PS_WTHD_TRXN_TBL for the 2 different Withholding Types (WTHD_TYPE) and in at least 3 different years (WTHD_DECL_DATE) -- 2019, 2020, and 2021
3. Navigate to Accounts Payable > Vouchers > Add/Update > Regular Entry
4. Create a non-Withholding Voucher for the Supplier from Step 1 with Accounting Date of 10-21-2021
    a. On the Voucher > Invoice Information > Withholdings link > Withholding Information page, delete the Withholding Detail and un-check the Withholding Applicable box
5. On the Voucher > Payments page, click the Express Payment link to pay the Voucher through Express Payment
6. Navigate to Accounts Payable > Batch Processes > Payment > Payment Posting
7. Run Payment Posting
8. Navigate to Suppliers > 1099/Global Withholding > Maintain > Update Supplier Withholdings
9. Add a Withholding Update ID
10. On the Update Supplier Withholding page, enter the Supplier ID and set the New Withhold option to Y for Tax Reporting Year of 2021 since want all the Vouchers for the Supplier to be Withholding
11. Save the page
12. Above Message is received
13. Change the New Withhold option to N
14. Save the page -- Criteria = Pending Database Update on the New Withhold Details tab
15. Navigate to Suppliers > 1099/Global Withholding > Maintain > Update Withholdings
16. Run Update Withholdings with Process Option = Process Only Supplier Updates
17. Check the Withholding Update ID created in Step 9, Criteria = Database Updated
18. Through SQL, Check the WTHD_TRXN_TBL for the Supplier
      a. All of the rows for WTHD_DECL_DATE of 2021 have been deleted
19. Add a new Withholding Update ID
20. On the Update Supplier Withholding page, enter the Supplier ID from Step 10 and set the New Withhold option to Y for Tax Reporting Year of 2021
21. Above Message is still received even though Step 1 has already been performed

Changes

 Message appears after applying Bug 32999171 - AP: UPDATE VOUCHERLINE WITHHOLDING, UPDATE SUPPLIER WITHHOLDINGS, NOT UPDATING WTHD_TRXN_TBL

Cause

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
Symptoms
Changes
Cause
Solution
References


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