FND_GLOBAL.APPS_INITIALIZE Error

When you are trying to use the FND_GLOBAL.APPS_INITIALIZE procedure from any other schema other than APPS, you may run into following issues.
Issue:

1.      ORA-20001: Oracle error -942: ORA-00942: table or view does not exist has been detected in fnd_global.set_nls

2.      ORA-20001: Oracle error -1031: ORA-01031: insufficient privileges has been detected in fnd_global.set_nls

Cause:
The root-cause is the application of a newer Release of the FND_GLOBAL package (body), which is delivered by Patch 6241631 - '11i.ATG_PF.H.RUP7'. It includes a code change causing the FND_LANGUAGES table  to be referenced. Under normal circumstances this does not cause any problem since it is an existing table and the APPS account has access to it.

However in this case a custom SCHEMA is used (for example: FIPM). This has in generic only access to a small set of Objects required for Integration. This Object does not have a SYNONYM (or other access) to the FND_LANGUAGES table, so when this is referenced in the package the ORA-942 error is raised.

Solution: To avoid these errors perform the following operation:
1.
CREATE SYNONYM <SCHEMA>.FND_LANGUAGES FOR APPS.FND_LANGUAGES;

2.
GRANT SELECT ON <SCHEMA>.FND_LANGUAGES TO <SCHEMA>;