Skip to Main Content
Forums

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!

BefImp script on FDMEE Aif_open_interface

2631549Jun 22 2017 — edited Jun 22 2017

Hi All,

Can anyone help me Paste here Jython script on below requirement.

I would like to wirte BefImport script as to import the data from open interface table for below reason

Example

one of Business unit is coming with " 01020-XXXX-SBL "

In HFM It is "XXXX" only

I have given Like mapping as " * to * " for Entity in FDMEE, obliviously it will fail since source and target members are different

I request from community experts for Jython script as to import only Middle 4 characters from AIF_OPEN_INTERFACE Table from column "COL01" (Where entity is stored)

Thank you in advance

Comments

1043586
Answer

Solved:

My SQL Array Fetch Size value was blank.  (Pref -> Database -> Advanced).  I had set it to 1000 or so a while back (2+ years), but apparently more than 500 crashes now.

Posting resolution here in case this ever happens to someone else. 

Marked as Answer by 1043586 · Sep 27 2020
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 20 2017
Added on Jun 22 2017
#business-intelligence-applications, #financial-data-management, #performance-management-applications
1 comment
203 views