Contract, Purchase Order (PO) and Voucher End Up Having No Withholding Setup on it After Contract is Created with a Blank Withholding Value (Doc ID 2759872.1)

Last updated on MARCH 06, 2023

Applies to:

Symptoms

Contract, Purchase Order (PO) and Voucher End Up Having No Withholding Setup on it After Contract is Created with a Blank Withholding Value.

Steps

1) Turn on version control for contracts by checking the Use Version Control checkbox under Set Controls- Contracts (Navigation: Main menu > Setup Financials/Supply Chain > Product Related > Procurement Options > Purchasing > set Controls -Contracts)
2) Find a supplier that has withholding turned on by running a query on PS_VENDOR table where WTHD_SW = 'Y'

3) Pull up Supplier and go to Withholding on the Location Tab (Navigation: Suppliers > Supplier Information > Add/Update > Supplier -Locations tab).  Verify a default jurisdiction is checked ON

4) Create a contract for that supplier(Navigation: Main menu > Supplier Contracts > Create Contracts and Documents > Contract Entry) – check ON allow open item reference

5) Save contract.  Make sure status is approved, if not, approve it.

6) Now create a new version the contract

7) Add a contract line on the new version.  Save and approve if necessary

8) Query the contract line and see that withholding is blank

9) Navigate to (Maine menu > Purchasing > Purchase Orders > Add/Update POs) Create a PO by copying contract ID created above. Save and approve if necessary.

10) Query sql for the PO – note that withholding gets set to ‘N”  EVEN though the Supplier’s WTHD_SW is Y

11) Dispatch PO

12) Now create a voucher from the PO (Navigation: Main Menu > Accounts Payables > Vouchers > Add/Update > Regular Entry). Add invoice and invoice date and save the voucher

13) Now query the voucher line – withholding is set to “N” even though supplier ID withholding is set to “Y”

See replication steps here.

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.