If you get error ODI-1217 after you initialize ERP Integrator cause may be user has not granted proper privileges to your schema which you have configured in EBS_DATA_SERVER in ODI.
ODI_11.1.1.6.0_GENERIC_111219.1055
Standalone Edition Version 11.1.1
Session Failed :3501 : ODI-1217: Session EBS_GL_SETUP_SOURCE_SYSTEM (3501) fails with return code 942.
ODI-1226: Step EBS Extract COA Ledgers fails after 1 attempt(s).
ODI-1240: Flow EBS Extract COA Ledgers fails while performing a Loading operation. This flow loads target table AIF_COA_LEDGERS.
ODI-1227: Task SS_0 (Loading) fails on the source ORACLE connection EBS_DATA_SERVER.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
ODI_11.1.1.6.0_GENERIC_111219.1055
Standalone Edition Version 11.1.1
Session Failed :3501 : ODI-1217: Session EBS_GL_SETUP_SOURCE_SYSTEM (3501) fails with return code 942.
ODI-1226: Step EBS Extract COA Ledgers fails after 1 attempt(s).
ODI-1240: Flow EBS Extract COA Ledgers fails while performing a Loading operation. This flow loads target table AIF_COA_LEDGERS.
ODI-1227: Task SS_0 (Loading) fails on the source ORACLE connection EBS_DATA_SERVER.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
Solution:
Grant all privileges to your user similar to APPS user.
Restart ODI Agent
Login into Workspace--> ERP Integrator and Initialize it again.
No comments:
Post a Comment