R12 Descriptive Flex Field with Value Set based validation on Table dedicated to Customer Framework
Hello
I have defined a Descriptive FlexField segment assigned to Customer Address as defined in 11i and I received this error message "No field listener is registered to resolve field ADDR.CUSTOMER_ID referenced by the flexfield with application short name AR and name RA_ADDRESSES_HZ. Please contact your system administrator"
Value set table validation contains is
select *
from hz_cust_acct_sites hcs, hz_cust_site_uses hsu
WHERE hcs.cust_account_id = :ADDR.CUSTOMER_ID
AND hcs.status = 'A'
AND hsu.cust_acct_site_id = hcs.cust_acct_site_id
AND hsu.site_use_code = 'INV'
AND hsu.status = 'A'