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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

FDMEE - TypeError: 'NoneType' object is unsubscriptable

fiammdinAug 25 2015 — edited Aug 25 2015

Hi there,

Im facing a topic that makes me going crazy.

i have a simple Custom 2 Like mapping that checks with a #SCRIPT if the Target Account of that DataRecords starts with "B".

Then he needs to go to "[None]" else to "IC_ELIM". it looks like that.

**********************************************************************************************

vTAcc = (fdmRow.getString("ACCOUNTX"))[:1]

if vTAcc == "B":

fdmResult = "[None]"

else:

fdmResult = "IC_ELIM"

**********************************************************************************************

But during the Import phase (i upload a fixed string to UD2 called  "EMPTY" im getting always the following error.

##################################################################

Processing Mappings for Column 'UD2'
2015-08-25 08:50:09,751 FATAL [AIF]: Error in 'C2_10_BALANCESHEET' (LIKE)
Traceback (most recent call last):
  File "<string>", line 2074, in updateTDATASEG_T_TDATASEGW
  File "<string>", line 1, in <module>
TypeError: 'NoneType' object is unsubscriptable

2015-08-25 08:50:09,751 INFO  [AIF]: Data Rows Updated by Location Mapping 'C2_10_BALANCESHEET' (LIKE): 0
2015-08-25 08:50:09,751 INFO  [AIF]:

##################################################################

and i cant figure out why. Other mappings location work well with the same mapping.

I would like to keep it in the LIKE mapping, as im wondering why it is not working instead of just put it in the MultiDim mapping

Any help on that?

thx

This post has been answered by fiammdin on Aug 25 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 22 2015
Added on Aug 25 2015
2 comments
691 views