FDMEE - BefImport.py event script SELECT statement
edited Sep 15, 2015 10:11AM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 7 commentsAnswered ✓
I'm trying to set up FDMEE to pull FX rates. I had the Oracle DBA set up a synonym to GL.GL_DAILY_RATES for the ERPIUSER account. I have set up the myPeriodName variable to that the period is in the format of "__-May-15" and have confirmed the SQL works in SQL Dev; however, when I run thru FDMEE, I see in the log :
2015-08-12 11:27:37,589 INFO [AIF]: -------START IMPORT STEP-------
2015-08-12 11:27:38,082 INFO [AIF]: Executing the following script: /opt/oracle/product/Middleware/ERPI/FinXXX.XXXX/data/scripts/event/BefImport.py
2015-08-12 11:27:48,135 INFO [AIF]:
Import Data from Source for Period 'May-15'
0