How to extract data from ORCL GL in "full" and not "delta " with FDM ERPI?

Fanny B Sep 28, 2012 8:49 AM

Hi

I am using FDM ERPI 11.1.2.1 to extrct data from Oracle eBS 11.

I can see that FDM ERPI extracts data in "delta mode" using the GL_TRACK_BALANCES_DELTA (FDM adds a row in this table after the 1st load of the period").

Is it possible to force the "full mode" in order to reload all the data from Oracle GL for each FDM data load?

Because I don't know why, but I have each month rows which are not imported into FDM.

thanks in advance for your help

Fanny

1. Re: How to extract data from ORCL GL in "full" and not "delta " with FDM ERPI?

JeffJon Oct 2, 2012 7:22 PM (in response to Fanny B)

You can use the "Full Refresh" option
Like Show 0 Likes(0)

Actions
2. Re: How to extract data from ORCL GL in "full" and not "delta " with FDM ERPI?

Fanny B Apr 18, 2013 1:26 PM (in response to JeffJon)

Hi

I had see that I have to install the FDM 11.1.2.1.502 patch in order to see this option in my ERPI adapter options.
I have passed this patch.
So I have the ERPI-FIN-C1 adaptor.
I can see a new option (Time Out Value) but no "Load Data" or "Execution mode" option :-(

Any idea of where the problem come from?

Fanny
Like Show 0 Likes(0)

Actions
3. Re: How to extract data from ORCL GL in "full" and not "delta " with FDM ERPI?

JeffJon Apr 22, 2013 1:32 PM (in response to Fanny B)

11.1.2.1.502 should have the ERPi-Fin-D1 adapter. Check the SharedComponents folder of the FDM installation and see if there is a ERPi-Fin-D1.zip file.
Like Show 0 Likes(0)

Actions

Go to original post

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