Your validation table resides in your application's ORACLE account. Oracle E-Business Suite requires access to your flexfield validation table, as follows:

Create a synonym for your validation table in the APPS schema (ORACLE account). Your synonym should be the same name as your table name.

Grant SELECT privileges on the table from your application's ORACLE account to the APPS schema.

Ensure that your responsibilities connect to the APPS schema.