value set used by report is throwing ora-24345 error
I created a custom value set for a custom report
the value set is based on a view I created called BSDM THIRD PARTY
CREATE OR REPLACE FORCE VIEW APPS.BSDM_THIRD_PARTIES_V
(
THIRD_PARTY_ID,
THIRD_PARTY_TYPE,
THIRD_PARTY_NUMBER,
THIRD_PARTY_NAME
)
AS
SELECT v.VENDOR_ID,
'S',
v.SEGMENT1,
VENDOR_NAME
FROM AP_SUPPLIERS v
UNION ALL
SELECT hca.CUST_ACCOUNT_ID,
'C',
hca.ACCOUNT_NUMBER,
P.PARTY_NAME
FROM HZ_CUST_ACCOUNTS hca, HZ_PARTIES P
WHERE P.PARTY_ID = HCA.PARTY_ID;
I created a value set based upon this view which I then tested and it tested successfully but when I use it within my report definition parameter and select on this parameter -- I get ora-24345 a truncation or null fetch error occurred