Skip to Main Content

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!

FDMEE custom script

Sophia WangDec 14 2017 — edited Dec 22 2017

Is it possible to use script to validate an account balance from FDMEE load file against a HFM account which is calculated in HFM at FDMEE validation stage?  For example, HFM calculated the beginning retained earnings (calculated account).  We map the beginning retained earning accounts from load file to a HFM statistical account.  We'd like to verify if the loaded statistical account equal to the calculated account.  If not, prevent the export.

Your input is appreciated!

Comments

Aravind N

Hi,
This is a known bug and is documented in MOS document ID 784038.1

If you are not particular about using exp/imp, try expdp and impdp which would be faster as well. Else you might have to apply the patch mentioned to fix this.

-Aravind

Paul M.
Answer

I like to copy the data from 10.2.0.4 oracle database to 11.2.0.3 db, so i tried to fired the traditional export from 11gr2 db server throw network

Apart that you should use expdp, you can't export a database using an exp utility from an higher version, you have to export using 10g exp utility, and import using 11g imp utility.

Export done in US7ASCII character set and AL16UTF16 NCHAR character set

server uses AL32UTF8 character set (possible charset conversion)

Couldn't this be a problem ? You should set NLS_LANG environment variable before exporting and importing.

Marked as Answer by 906790 · Sep 27 2020
Mark D Powell

I agree with Paul that if you are going to use exp you must use the 10.2 version to perform the export which the 11.2 imp can then process.  If you use expdp to run the export then you should be able to use the 11.2 version providing you specify the version= parameter to identify that an older database is being read. 

HTH -- Mark D Powell --


1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 19 2018
Added on Dec 14 2017
6 comments
402 views