FIM Mappings

[Former Member]

Hi Experts,

We are trying to load the data from Oracle to BPC 10.0 MS version, where we have Account and Subaccount columns in Source(Oracle) and they should be mapped to Account column in target(BPC).

The requirement is, for some line items the account in target system is directly mapped with only account column in source system .

Ex:

Source                                           Target

ACCOUNT                                     ACCOUNT

12345                                             A2160

and for some line items the account in target system should be mapped with the combination of account and subaccount columns in source system.

Ex:

              SOURCE                                                               TARGET

ACCOUNT         SUBACCOUNT                                         ACCOUNT

67890                  1234                                                          A2614

Here the account in target system should be mapped with the combination of account and subaccount columns in source system ie 678901234 should be mapped to A2614 in target.

Kindly suggest me if we have such functionality in FIM.

Many thanks in advance.

Regards

Srikanth.

[Marc_Kuipers · Accepted solution]

Hello Srikanth

Yes, this is possible

Below rule would achieve this

Thanks

Marc

[Former Member · Accepted solution]

Hi Marc,

Thank you so much for your quick response.

Could you please confirm that instead of using * in subaccount in first column, can we use {empty} as 12345 can directly mapped to 'AC1'

Thanks

Srikanth

[Marc_Kuipers · Accepted solution]

Hello Srikanth

Sure, you can use {empty}

It really all depends on how your source file is defined

Best regards

Marc

[Former Member · Accepted solution]

Many thanks for your quick reply.

Regards

Srikanth..