4Site
Support Request System
View Patch #50.024.023
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
02872 -
Bids - SQL error creating PO - error converting string to int.
02621 -
Error entering a supplier when creating a new PO in Oracle
Symptoms:
Error message "expression must have same datatype as corresponding expression" is displayed when creating a new PO using an Oracle database. The error manifests when a supplier id is entered (typed or selected via lookup) and focus is moved off the supplier Id text box.
Solution:
The SQL Select query which retrieves supplier data was revised so that the select list is in corresponding order in each of the union segments. See patch 50.019.001
Browse Patches
Find a Patch
Return to Request System Menu