Introduction:
Information in this document applies to any platform.
Oracle Financials for India – Version 12.1.1 and later
Vendor not showing up in LOV (List of Values) while performing Exception Threshold Setup
Cause of the issue:
The issue is caused by the following setup:
Vendor type mismatch in Third party registration and Threshold Setup
Vendor Type Mismatch causing the Supplier not to be retrieved in the Exception Setup > Assign Vendors
Vendor Type in Third Party Registration Setup is say for example “COMPANY-IND” but Exception Threshold Setup is done for “INDIVIDUAL-IND”
How do we solve:
a) Query the Third party registration Setup for existing Supplier.(Null Site)
b) Navigate to Reporting Codes.
c) End Date the Reporting Codes Setup.
d) Create a new record with correct Vendor Type.
e) End Date the Reporting Codes Setup at site level.
f) Create a new record and whatever value is provided in null site gets defaulted at site level.
g) Post that the same will show up in Exception Setup > Assign Vendors.
The issue can be reproduced at will with the following steps:
1. Oracle Financials for India > Withholding Tax Setup > Define Withholding Thresholds
2. Select the Regime, Vendor Type, Section code and check the Exception Setup Flag.
3. Click on Find.
4. Click on Assign Vendors.
5. Try to fetch the expected Vendor from the LOV
Conclusion:
After performing the above setup, Users can able to select the Vendor in the LOV (List of Values) while performing Exception Threshold Setup.