The table ERPI.aif_ebs_gl_balances_stg has data in it.
The ODI scenario's do execute when they are executed from workspace; when the Import from FDM is triggered, then it does not even start the ODI scenarios.
Hi George ,
See the process works like this : EBS -> ERPI_SCHEMA ( Using ODI Scenarios ). The data will be stored in AIF_GL_BALANCES_STG Table. From there using a DB link it will transfer the data into the FDM Tables .. and You will see it in the import screen in Workflow in FDM Web.
While doing the second step ODI scenarios dont have to be triggered. So i guess you are fine on that front.
I would suggest you check your adapter that you have imported in the workbench client and check whether you have configured the adapter properly.
1) Import the adapter
2) Register the adapter using the .dll or exe file as the case maybe
3) Once imported right click the adapter - > options.
Please enter all the options in upper case.
Use the script that i have sent you as that script has been tested previously many times.
Your reply prompted me to check the options in the ERPi Source Adapter. In the ERPI Database Server/Service, I had entered the details of the database server hosting the ERPI database. I changed this to the SID of this database, and checked again, and it starts working.