EAP: Voucher Build Withholding Errors Occur When the VENDOR_LOC Field In PS_VCHR_LINE_QV is Populated With An Invalid Value (Doc ID 3040495.1)

Last updated on AUGUST 09, 2024

Applies to:

Symptoms

When a withholding voucher is loaded into the Voucher QV records from a 3rd Party system, there are times the VENDOR_LOC field in PS_VCHR_LINE_QV is loaded with an invalid value. When the Voucher Build process completes, this withholding voucher has Voucher Build errors.

There is not a way for the users to know the PS_VCHR_LINE_QV.VENDOR_LOC value is invalid because field is not seen online. There is also not a way to correct the error online.

ERRORS
--------------------------
Field Name:                             Message:
Address Sequence Number       TSE Prompt table edit; value not found in prompt table
Supplier Location                      TSE Prompt table edit; value not found in prompt table
Withholding Applicable               Voucher Line marked as withholding for a Supplier with incomplete withholding setup

STEPS TO REPLICATE
----------------------------------------
1. Withholding Supplier setup: Suppliers > Supplier Information > Add/Update > Add/Update Supplier >
    a. Two Addresses: Address1 = Active, Address2 = Inactive
    b. Two Locations: Location1 = Active, Location 1 Inactive
    c. Location1 is setup with Withholding Information
    d. Locaiton2 is not setup with Withholding Information

2. Add a Quick Invoice for the Withholding Supplier: Suppliers > Supplier Information > Add/Update > Add/Update Supplier
    a. Add required Quick Invoice values using Active Location1
    b. Save

3. Since Quick Invoice data is not loaded through a 3rd Party, SQL update through the back end the following values:
    a. PS_VNDR_HDR_QV.VENDOR_LOC = 2 (Inactive)
    b. PS_VCHR_LINE_QV.VENDOR_ID = Withholding Supplier ID
    c. PS_VCHR_LINE_QV.VENDOR_LOC = 2 (Inactive)

4. Voucher Build: Accounts Payable > Batch Processes > Vouchers Voucher Build

5. Review Voucher Build Errors: Accounts Payable > Vouchers > Maintain > Voucher Build Error Detail > Errors
    Field Name:                           Message:
    Address Sequence Number     TSE Prompt table edit; value not found in prompt table
    Supplier Location                    TSE Prompt table edit; value not found in prompt table

6. Correct Voucher Build errors: Accounts Payable > Vouchers > Add/Update > Quick Invoice Entry > Find an Existing Value
    a. Open Voucher in question
    b. Correct Address = Address1
    c. Correct Location = Location1

7. Voucher Build: Accounts Payable > Batch Processes > Vouchers Voucher Build
 
8. Review Voucher Build Errors: Accounts Payable > Vouchers > Maintain > Voucher Build Error Detail > Error
    Field Name:                      Message:
    Withholding Applicable        Voucher Line marked as withholding for a Supplier with incomplete withholding setup

9. Correct Voucher Build errors: Accounts Payable > Vouchers > Add/Update > Quick Invoice Entry > Find an Existing Value
    a. Supplier Location seen online is correct
    b. The PS_VCHR_LINE_QV.VENDOR_LOC value is incorrect but there's not a way to correct this value online
    c. The invalid VENDOR_LOC value needs to be corrected through the back end using SQL

10. This is not a problem for a Non-Withholding Voucher if an invalid Location is loaded to PS_VCHR_LINE_QV.VENDOR_LOC

Cause

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