Can you see the file exported from ERPI? Does it have data?
Have you checked the ERPI adapter log? you should have in the readme instructions about enabling this log.
Also check the FDM log and ODI Operator.
There are several Oracle Support entries for similar issues. For example:
ERPI- Source File For FDM Is Not Populated At 'Export Balances to File' When Running Data Rule (Doc ID 1087460.1)
Thank you Francisco for your reply. Can you let me know where I am supposed to look for the file that gets exported from ERPI? I checked the directory I have setup in the ERPI_FDM physical schema and nothing is getting created there.
I have checked the ERPi adapter log, all it says is "No records found for Load ID (###)"
ODI operator shows that all jobs ran successfully (COMM_LOAD_BALANCES & ERP_GL_LOAD_BALANCES_DATA), nothing shows up in the FDM log.
Thanks for posting that link, I didn't see this one yet, but I already have the correct file driver on the ERPI_FDM schema.
Have you checked this document?
Troubleshooting Errors Between FDM and ERPI When Importing Data (Doc ID 1549825.1)
Which version of the adapter are you using?
Please can you attached both FDM and ERPI logs (please make sure you enable the ERPI Error Log. In the document above you have instructions to enable it)
I am using the ERPI-FIN-D adapter.
I'm attaching screenshots of the log files and the configuration items from the document you listed.
I noticed that ERPI is on the fincqa1 service and FDM is on the fincqa2 service. Is that causing the issue? Do they need to be on the same service?
Screenshots.pdf 110.7 K
FDM communicates with ERPI using a dblink.
If I remember well, in 18.104.22.168.501, FDM was creating a dblinkg called "fdm" to the ERPI database.
Please check if the DB has been created in the FDM database. You need to make sure that FDM database user is granted to create dblinks.
As a test, you can use any SQL tool (i.e: SQL developer) and logon with the FDM database user. Then run the following command:
CREATE DATABASE LINK fdm strERPIServerName CONNECT TO strERPIdbUserID IDENTIFIED BY strERPIdbPassword USING 'strERPIServerName'
If you get error saying you don't have enough permissions then you need to grant FDM db user with "Create DB Link" (ask your dba)
You need to replace values for your ERPI database
BTW, are you using 22.214.171.124.501? I would suggest you upgrade to last patch for 11.2.1.x (I guess it's 503)
I am getting insufficient privileges, I will ask the DBA to create it and let you know what happens after that is done. Once the DB link is in place, do I need to make any configuration changes?
We are on the base 126.96.36.199. I will see if there are any plans to upgrade to latest patch.
You don't need to make any config changes.
Just try after the Dblink is created.
Ok so the user was granted db link privileges and a db link was created, but still not getting any data into FDM. Any other suggestions?
so if the db link was created by the import process, then we moved one step forward.
Have you granted the FDM users also with CREATE SYNONYM. Besides the DBLINK, as they are in different db servers, the dba needs to create the following synonym:
CREATE SYNONYM ADAPTERTDATASEG FOR "<erpiSchemaName>".TDATASEG@ERPI
where "<erpiSchemaName>" is your ERPI schema
Also make sure the FDM database server had an entry in tnsnames.ora file with the network alias name specified in the Create DATABASE LINK query above to connect to ERPI database server.
If FDM is on the Oracle RAC environment, and when more than one database servers are involved, all of them should have that same entry in the tnsnames.ora file.
Hope that helps