1. What version of FDM are you using
2. what is the target application you are loading to?
3. are you using the single period load or multiload?
4. Can you confirm that these records do not get written to the .DAT file or do they get written to the .DAT file but are then not loaded into the target application?
Thank You for your reply.
1. FDM version-126.96.36.199.00
2. Target - Oracle application (Data is getting filter in .dat file in FDM Outbox folder)
3. Using single period- Source file contains data for only one period.
4. Amount with less than 0.5 is not getting written to .DAT file. But when I try to export option (Export to Excel) in FDM screen, I see all the records including amount less than 0.5.
Any information or help, will be greatly useful.
When you say the target is 'Oracle application', exactly what do you mean. i.e. Is the location using the pull adaptor? If so, then check the export script attached to the adaptor and see if any bespoke code is included that would omit these records from being written out to the export file.
File is sent to ERP system (but we need not verify the target system- because the records are getting filter in .DAT file in Output folder of FDM server)
But when I click on (Export to Excel) from Export in FDM- I can see the compete rows in the xls.
Records which are getting filters are with amount less than $0.5.
We are not using any pull adaptor.
Sorry if i appear a bit bemused by this, but i do not follow your logic here. If you are exporting the file (after import / validate) then there must be an adaptor linked to the location, (or it uses the default if not specified on the location) as that is where the export script is that creates the .DAT file is located. Is this a feature i am not aware of or connected with the ERPI writeback functionality?
Here is the latest update. We have a script "AftExportToDat", but this script dont do anything- other then adding the trailer record to the target file ( .Dat) and it working fine.
For testing purpose I modified the source file (With amount less than 0.5 to 999.XXX, for example 0.450 to 999.450) When I import, validate and export the file to .Dat, count of the .Dat file is increased and showing exactly the same which we are looking for.
So the issues is with the decimal format in FDM, can you please confirm if FDM support the export file format with amount less than 0.5.
I have worked with FDM for 8 years and never had issues with the values passed to any Hyperion or external target application. This is why i am asking about whether you are using the standard 'Pull' adaptor to produce the .DAT export file. If this is the case then i would suspect that the export script within the adaptor has been modified to to meet the requirements of your export file, and might have something in there to ignore particular records. when you look a thte FDM location metadata record, does it show an adaptor name? If not, what is the 'system name' defined in the applicaiotn settings as that would be the default if no adaptor is defined in the location record.