Return
-
Title
Unable to retrieve EBS Schema objects if DB entry is not in local (stat windows client workstation) tnsnames.ora file -
Description
Stat for Oracle EBS not working if TNSNAMES.ORA entries not on workstation -
Cause
Schema Object retrieval is done on the client itself. Archiving is done by the central agent. Migration is done by the Oracle agent. -
Resolution
That let us to conclude that connectivity from the workstation IS required for Schema Objects.Thus, you MUST have EBS DB tns entry for local workstation on the tnsnames.ora file in order to successfully fetch EBS Schema objects.