PUBLIC SYNONYM
Dears,
I'm installing custom application from Opentext Company called Extended ECM on E Business Suite 12.2.5 on DB 11.2.4 , one of the installation steps to create PUBLIC SYNONYM using below statement,
"CREATE OR REPLACE PUBLIC SYNONYM fnd_env_context FOR applsys.fnd_env_context"
but it's returning below error
"Error ORA-01948: identifier's name length (42000) exceeds maximum (30)"
if i tried to create same synonym not public like " CREATE OR REPLACE SYNONYM SYSTEM.fnd_env_context FOR applsys.fnd_env_context; " it will work fine,
i tried the same on EBS 12.2.6 on 12C DB it was also working fine
kindly advise.