Debit-Credit in Import Script

3355552 Feb 10, 2017 9:11 AM

Hi everyone,

I am using FDMEE and would like to create an import script for column debit-credit(2 seperate columns in the CSV files) and put this script in AMOUNT dimension in the Import Fomat

Anyone has sample of this script? I was looking into Administrator guide but did not see any sample for it.

And I have checked in this forum: FDMEE Amount Mapping to (Ending - Beginning)? --- I would not use this solution because there are hundreds account mapping so writing SQL script to each account mapping is not a nice solution....

Thx.

1. Re: Debit-Credit in Import Script

3355552 Feb 10, 2017 9:21 AM (in response to 3355552)

Please ignore my question: Have found the answer in this thread: How to load 2 Amount columns for delimited file and How to use Import Format DRCRSplit? in fixed file.
Like Show 1 Likes(1)

Actions
2. Re: Debit-Credit in Import Script

Dayalan Punniyamoorthy Feb 10, 2017 9:21 AM (in response to 3355552)

I had a similar situation in PBCS where there is very limited option. since you mentioned Script i am assuming this on On-Premise.
I have created 2 separate load for loading the Credit and Debit and it does works for us, as i said this was for PBCS.

HTH,
Dayalan P.
Like Show 0 Likes(0)

Actions
3. Re: Debit-Credit in Import Script

3355552 Feb 10, 2017 9:35 AM (in response to Dayalan Punniyamoorthy)

Hi Dayalan, my target application is HFM, neither PBCS nor Planning on premise.
So, it is a little bit different approach I think.
Like Show 0 Likes(0)

Actions

Go to original post

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