10 Replies Latest reply on Aug 25, 2014 8:34 AM by Francisco Amores

ERPI Source Adapter load to FDM - No Records Found

Mike_Lau Aug 12, 2014 4:54 AM

Hello All,

I am trying to implement an FDM data load that pulls data from ERPI. I setup the ERPI components and when I run the Data Load Rule in ERPi, I see results in the Data Load Workbench. When I try to import the data (using the same data load rule) into FDM i get an error saying No records found for Load ID (###). When I go to ERPI Process Details to see the log for Load ID (###) I see that records were processed and records were inserted into the TDATASEG table. So it seems like the call to fTransferData in the GETDATA action script of the adapter doesn't seem to be pulling the correct data, or something is not configured correctly and it can't see the data. Any help would be greatly appreciated.

Both ERPI and FDM are on Oracle databases.

We are running 11.1.2.1

Thanks,

Mike Lau

1. Re: ERPI Source Adapter load to FDM - No Records Found

Francisco Amores Aug 12, 2014 10:10 AM (in response to Mike_Lau)

Hi,
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)

Regards
Like Show 0 Likes(0)

Actions
2. Re: ERPI Source Adapter load to FDM - No Records Found

Mike_Lau Aug 13, 2014 1:19 AM (in response to Francisco Amores)

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.

-Mike
Like Show 0 Likes(0)

Actions
3. Re: ERPI Source Adapter load to FDM - No Records Found

Francisco Amores Aug 13, 2014 1:43 AM (in response to Mike_Lau)

Hi Mike,

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)

Regards
Like Show 0 Likes(0)

Actions
4. Re: Re: ERPI Source Adapter load to FDM - No Records Found

Mike_Lau Aug 13, 2014 2:41 AM (in response to Francisco Amores)
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
Like Show 0 Likes(0)

Actions
5. Re: Re: Re: ERPI Source Adapter load to FDM - No Records Found

Mike_Lau Aug 13, 2014 2:44 AM (in response to Mike_Lau)
Here is the ERPI Process details log. Am I missing something else you need? Thank you again for taking the time to look at this.

ERPI Process Details.pdf 99.1 K
Like Show 0 Likes(0)

Actions
6. Re: ERPI Source Adapter load to FDM - No Records Found

Francisco Amores Aug 13, 2014 3:13 AM (in response to Mike_Lau)

FDM communicates with ERPI using a dblink.
If I remember well, in 11.1.2.1.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 11.1.2.1.501? I would suggest you upgrade to last patch for 11.2.1.x (I guess it's 503)
Like Show 0 Likes(0)

Actions
7. Re: ERPI Source Adapter load to FDM - No Records Found

Mike_Lau Aug 13, 2014 3:27 AM (in response to Francisco Amores)

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 11.1.2.1. I will see if there are any plans to upgrade to latest patch.
Like Show 0 Likes(0)

Actions
8. Re: ERPI Source Adapter load to FDM - No Records Found

Francisco Amores Aug 13, 2014 3:41 AM (in response to Mike_Lau)

You don't need to make any config changes.

Just try after the Dblink is created.

Rgds
Like Show 0 Likes(0)

Actions
9. Re: ERPI Source Adapter load to FDM - No Records Found

Mike_Lau Aug 19, 2014 1:58 AM (in response to Francisco Amores)

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?
Like Show 0 Likes(0)

Actions
10. Re: ERPI Source Adapter load to FDM - No Records Found

Francisco Amores Aug 25, 2014 8:34 AM (in response to Mike_Lau)

Hi,

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
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.