Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FDM Import Format Spec with multiple Amount Fields

623479Nov 8 2008 — edited Feb 27 2009

Hello,

I'm in the process of setting up an Import specification for one of our sites and the source extract consists of the following fields:

Source Account Description BegBalDR BegBalCr YTDDR YTDCR
---------------------------------------------------------------------------------------------------------------------------------------
01-511-5110 Inventory Adjustment 1,754.00 0 0 14,844.76

I'm am trying to Import Field 5 & 6 and net them if necessary (example: YTDDR - YTDCR) and I continue to get an error. I have tried several diffrent ways but it seems that I can only import one or the other. After reading the FDM Admin guide I am wondering if I need to create a custom Script to accomplish this task.

Any advice would be appreciated.

Thank you,
Tony

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 26 2009

Added on Nov 8 2008

#business-intelligence-applications, #fdm, #financial-data-management, #import, #performance-management-applications, #script

11 comments

5,772 views