Skip to Main Content
Forums

Database 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!

OWB mapping not run through Process flow

User_9XA6ODec 19 2019 — edited Dec 19 2019

Hi All ,

In my OWB we have Avesta_STG process flow it contains a mapping name avesta016_max_map.

Due to some reason I need to change some tables from the mapping and for that I have created copy of the mapping i.e. copy_of_avesta016_max_map.

I have created set Action and deploy the mapping and after that, I have executed the mapping copy_of_avesta016_max_map and it run successfully.

Now I have changed the name of mapping from copy_of_avesta016_max_map to avesta016_max_map  and replace & deploy the mapping using Control center . also keep avesta016_max_map as avesta016_max_map_org as for backup purpose and to avoid modification of Process flow.

Now I ran process flow Avesta_STG, all the mappings from Process flow runs successfully and created a log for all mappings except  avesta016_max_map. I could not find any log with this mapping when it runs with Process flow .

So I have a question that whether the new mapping avesta016_max_map is running or not and I am also unable to see any log for the same mapping.

Could you please help me what step I missed so that I m unable run this mapping on the Avesta_STG process flow.

Thanks

Comments

SH_INT
Answer

Why won't your finance team accept the approach of logic accounts? This is the obvious solution to your problem. In FDM or FDMEE you can only load on piece of data to one target intersection. If you want to load the same piece of data to multiple target intersections then you need to have that piece of data repeated in the source data nad then you will still need something in the source that could uniquely identify each of those copies so you could map appropriately. As mentioned that is one of the primary functions of logic accounts, other approaches are likely to be messy, more prone to error and a lot more difficult to audit.

Marked as Answer by MarkSmithHFM · Sep 27 2020
1 person found this helpful
MarkSmithHFM

Hi SH,

Thanks for your reply.

I agree with you 100% that logic accounts are the way to go here.  I was just trying to find out if there were any other approaches that would be relatively straightforward and easy to implement.

Other approaches would definitely not be elegant and would involve scripting and probably rewriting file or copying data records via scripts which to me are non-starters.

You reinforced my opinion.   I'll develop my solution using logic accounts.

Thanks,
Mark

1 - 2

Post Details

Added on Dec 19 2019
#data-warehousing, #warehouse-builder
3 comments
264 views