Hi,
I have seen a couple of subject related to this issue but since they are archived and I cannot reply, I am opening a new discussion on the subject.
Here is my issue.
I have a location (PeopleSoft) where the source file has empty cells for intercompany. The source file contains 2 columns for intercompany called Affiliate 1 and Affiliate 2. The first intercompany column is used for parent intercompany and the 2nd column is used for Business Units intercompany. In the import format, i concatenate these 2 columns for the ICP mapping. When a line item in the source file involves a non interco account, these cells are empty (see below).
| Legal BU | Oper Unit | dept | Account | Affliate 1 | Affiliate 2 | Amount |
| 70001 | CA130 | 130300 | 10212014 | | | 100 |
In the mapping for ICP, I have added all intercompay partners as explicit mapping and I put * in the Like mapping for [ICP None]. This mapping works welll if you did not forget any ICP partners in your ICP mapping. If you do, they will end up with [ICP None]. If I could map the concatenated blanked cells as explicit mapping to [ICP None], it would solve this issue as the new ICP would come up as unmappped ICP (which is what I want).
I have tried to use a Import datapump script to replace blank with a distinct name such as Blank or NO_ICP and then mapped this name as explicit mapping to [ICP None]. This would work if did not have 2 columns for ICP in the import format.
Here is the import script:
Function No_ICP(strField, strRecord)
'------------------------------------------------------------------
'Oracle Hyperion FDM DataPump Import Script:
'
'Created By: daniel.wilson
'Date Created: 12/9/2013 12:37:18 PM
'
'Purpose:
'
'------------------------------------------------------------------
If Not Len(strField) > 0 Then
strField = "Blank"
End If
No_ICP = strField
End Function
It works well but since I can have a blank cell in one intercommpany column and a ICP partner in the other one, it adds "Blank" to the ICP partner source cell (see below).
| PARTITIONKEY | CATKEY | PERIODKEY | ACCOUNT | ENTITY | AMOUNT | DATAVIEW | ICP | UD1 | UD2 | UD3 | UD4 |
| 750 | 13 | 2013-12-31 00:00:00 | 10101010 | 70001 | 1000 | YTD | BlankBlank | 70001 | 10101010 | 10101010 | 10101010 |
| 750 | 13 | 2013-12-31 00:00:00 | 10231010 | 70001 | 1000 | YTD | 70081Blank | 70001 | 10231010 | 10231010 | 10231010 |
| 750 | 13 | 2013-12-31 00:00:00 | 40306600 | 70001CA011 | 1000 | YTD | BlankCA144 | 70001CA011011090 | 40306600 | 40306600 | 40306600 |
Unless I modify this script to fit my import format, it is useless.
Thank you all for you help.
Daniel