Hi all,
I want to use APPS.FND_FLEX_EXT under a user I just created.
If I execute the query below with the user I get no result:
SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', 50560, 22093)
FROM dual;
Then I did execute SELECT fnd_flex_ext.get_message() from dual; to get the last error. Then I get
Program error: Please inform your support representative that:
FLEXFIELDS SERVER-SIDE VALIDATION package reports error:
SV2.get_keystruct() exception: ORA-00942: table or view does not exist
I execute this under APPS to be shure the user has te correct rights.
GRANT SELECT ON FND_APPLICATION TO VIEWERUSER;
GRANT EXECUTE ON FND_FLEX_EXT TO VIEWERUSER;
GRANT EXECUTE ON FND_FLEX_SERVER TO VIEWERUSER;
GRANT EXECUTE ON FND_FLEX_SERVER1 TO VIEWERUSER;
GRANT EXECUTE ON FND_FLEX_SERVER2 TO VIEWERUSER;
GRANT EXECUTE ON FND_GLOBAL TO VIEWERUSER;
GRANT SELECT ON FND_ID_FLEXS TO VIEWERUSER;
GRANT SELECT ON FND_ID_FLEX_SEGMENTS TO VIEWERUSER;
GRANT SELECT ON FND_ID_FLEX_STRUCTURES TO VIEWERUSER;
GRANT EXECUTE ON FND_MESSAGE TO VIEWERUSER;
GRANT EXECUTE ON FND_PLSQL_CACHE TO VIEWERUSER;
Under VIEWERUSER I created the following synonyms:
CREATE SYNONYM FND_APPLICATION FOR APPLSYS.FND_APPLICATION;
CREATE SYNONYM FND_FLEX_EXT FOR APPS.FND_FLEX_EXT;
CREATE SYNONYM FND_FLEX_SERVER FOR APPS.FND_FLEX_SERVER;
CREATE SYNONYM FND_FLEX_SERVER1 FOR APPS.FND_FLEX_SERVER1;
CREATE SYNONYM FND_FLEX_SERVER2 FOR APPS.FND_FLEX_SERVER2;
CREATE SYNONYM FND_GLOBAL FOR APPS.FND_GLOBAL;
CREATE SYNONYM FND_ID_FLEXS FOR APPLSYS.FND_ID_FLEXS;
CREATE SYNONYM FND_ID_FLEX_SEGMENTS FOR APPLSYS.FND_ID_FLEX_SEGMENTS;
CREATE SYNONYM FND_ID_FLEX_STRUCTURES FOR APPLSYS.FND_ID_FLEX_STRUCTURES;
CREATE SYNONYM FND_MESSAGE FOR APPS.FND_MESSAGE;
CREATE SYNONYM FND_PLSQL_CACHE FOR APPS.FND_PLSQL_CACHE;
On Oracle ETRM I found the dependencies(http://etrm.oracle.com/pls/etrm/etrm_pnav.show_object?c_name=FND_FLEX_EXT&c_owner=APPS&c_type=PACKAGE%20BODY)
But am I missing some grants, because I get table or view does not exist?